Custom reports for vTiger 6.2 -- 2

Cerrado Publicado Feb 19, 2015 Pagado a la entrega
Cerrado Pagado a la entrega

Hello Freelancers,

Create a custom report in the Home that you give it a date range and will look into all the sales orders, then it will create a table like this:

- Name of product, how many items of the product apeared in all the sales orders in that date range, how much money sold in total for that given product, it will tell the comission for that given product in %, then calculate the comission being paid for that product, and then look at the total money of all the products sold in the period and calculate incidence in % of that product in the total.

- It will also list the products not being sold.

- The table will have to be order-able by any column.

Also, very similar querying, you select another time range, and it will look again at all the sales orders and the products within them, but this time, it will create a table by assigned too, show the total sales, and calculate the commission to the sales person... have in mind that commission is per product, therefore, it will have to look for each amount sold of which product to calculate the commission. It can show that in the table to, a detail of how much of the commission corresponds to which product.

Regards,

Akma

MySQL PHP vTiger

Nº del proyecto: #7169909

Sobre el proyecto

3 propuestas Proyecto remoto Activo Mar 28, 2015

3 freelancers están ofertando un promedio de $167 por este trabajo

mrt3vn

Hello, I'm read your job description and deady to discuss about your project right now. Regards, New2New

$222 USD en 3 días
(60 comentarios)
6.4
mnadeem24434

Hi Dear! I Can perform this job very well as I'm already working with Coca-Cola Pakistan as Voyage Officer and recently join this site. Give me a chance to prove myself. Regards, M Nadeem Asghar 0092-306-71469 Más

$80 USD en 3 días
(1 comentario)
0.4