Custom reports for vTiger 6.2 -- 2

已关闭 已发布的 Feb 19, 2015 货到付款
已关闭 货到付款

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

项目ID: #7169909

关于项目

3个方案 远程项目 活跃的Mar 28, 2015

有3名威客正在参与此工作的竞标,均价$167/小时

mrt3vn

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

$222 USD 在3天内
(60条评论)
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 更多

$80 USD 在3天内
(1条评论)
0.4