tinhx7

Generate Reports from Line Items

Discussion created by tinhx7 on Feb 8, 2018
Latest reply on Feb 8, 2018 by tinhx7

Hello all,

 

I'm currently generate daily, monthly reports base from Line Items table.

It working fine, however, it's too much work because I had to created many fields like SubSummary, SumSummary (Running), etc..

My reports are complex b/c it base on the commission. Commission % is base on the service type/product type.

I need some suggestions.

I want to have options that the managers can view the reports such as 60%-40%, 50%-50%, 55%-45%.

 

Is there a way I can write a script to generate such reports ?

 

For example:

Technicians:

60% of Service A

20% of Product A

 

Shop:

40% of Service A

80% of Product A

Outcomes