In Progress

Customize Sugar CRM commercial force

This Sugar CRM is used into a Media Enterprise to control its commercial and sales staff. Customers, sales, products and staff information are the core of this CRM.

Spanish - English dictionary could be needed to understand what CRM says

Customize Tasks Query:

See image #1 of attached file

1. In menu ACTIVIDADES (activities in english), option TAREAS (tasks in english), tab BUSQUEDA AVANZADA (advanced search) more search fields are required:

Tasks browser must allow queries by 5 new fields:

- REGIONAL (region): Table name: [url removed, login to view]

- CIUDAD (city): [url removed, login to view]

- GRUPO (sales team): [url removed, login to view]

- CLIENTE (customer): [url removed, login to view]

Note: REGIONAL, CIUDAD and GRUPO information are in the same table because they are part of the same sales hierarchy tree: Sales teams (GRUPO) are included in cities (CIUDAD) and cities in regions (REGIONAL)

(See commercial hierarchy tree: image #2 in attached file, menu MERCADEO (marketing), option ARBOL DE GRUPOS ASOCIADOS (sales teams tree)

Tasks query must respect hierarchy tree: (se field PARENT into [url removed, login to view] data table)

- Sales executives are only allowed to check tasks assigned to him,

- Team Managers are only allowed to check tasks assigned to him, and to executives into the team

- City Managers are only allowed to check tasks assigned to him, to team managers into his city and to executives into those teams.

- Regional Managers are only allowed to check tasks assigned to him, to city managers into his Region, to team managers into those cities, and to executives into those teams.

- National manager, upper levels and CRM administrator are allowed to check any bodys tasks, no matter who is asssigned to.

Tasks information are located in [url removed, login to view] data table

2. Additionally, task browser must allow filtering by date: FROM - UNTIL data fields must be available for users.

3. ASIGNADO A (assigned to) field have to change its display: it is required to use a data box instead data list.

Query system must be the same as the one used in menu VENTAS (sales) option CLIENTES (customers), where the field ASIGNADO A (assigned to) is just a data empty box. When

SELECCIONAR (select) button beside is clicked, sales executives/teams list is displayed. It allows user filter CRM users by name and city to pick one up.

List displayed into a pop up includes the whole hierarchy tree of sales department: executives, team manager, city manager, regional manager and national manager, because all of them could have tasks assigned.

Developer must use the browser space in proportion of fields required. Good looking display and less scroll as possible are desirable.

This is only the first of 22 changes required in the CRM. Nice performance in this development should be important to choose enginner who will be hired to complete the rest of the work.

Skilled developer should require less than 10 hours to finish this job.

Skills: CRM, PHP

See more: what is needed to be a good manager, tree to box, tree query, team national, system administrator looking for job, sugar crm development, sugar crm developer, staff force, sales and marketing manager job, require marketing manager, regional sales manager, regional manager, pop up search box, pop sugar, php developer nice, php developer levels, national sales manager, national commercial manager, marketing manager require, marketing executives needed, looking for marketing executives, job search skilled, job search administrator, job se, hired in spanish

About the Employer:
( 16 reviews ) Bogota, Colombia

Project ID: #1374442

Awarded to:


Please check PMB

$180 USD in 10 days
(15 Reviews)

4 freelancers are bidding on average $215 for this job


Hi We are CRM/ERP/POS/Custom Software solution providing company So we are really interested to deliver this project. Regards AuricleSoft

$210 USD in 25 days
(25 Reviews)

please chk pmb

$220 USD in 4 days
(0 Reviews)

Tengo experiencia en el desarrollo de ERP, CRM, HCM... Puedo realizar el trabajo, necesito mas detalles de tu proyecto...

$250 USD in 7 days
(0 Reviews)