Sales Invoice Items Reporting

#1

I have one business in manager where insurance policies are sold by the employees/sales agents and sales invoices are than sent to the broker for the policy commission and from that commission when received agents are paid 50% commission…

I have created Sale Items like Car Insurance, Health Insurance etc…
also I have created Tracking code with agents name…

Now
How can I create a report to see how many Car, Health Insurances were sold and total revenue generated by each agent?

thanks

#2

If you are using tracking codes for agents, then you will need to generate profit & loss statement for that tracking code.

You can generate P&L on cash-basis, this way you can make sure agents are paid commissions only on paid invoices.

#3

Thanks… I know that bit about tracking codes in reports…
How can I generate Sales Items report…

Would you please give me SQL query for this custom report.

Report for Sales Invoice Items
Showing total quantity in invoices issued,end of the month i.e. 1-12-15 to 31-12-15.
Item1----6-----$600
Item2----7----$700
Item3----5----$500

Another report

Showing Agents(tracking codes) and no of Sales Items sold monthly

i.e.
Tracking Code–Item1—revenue------Item2–revenue------item3—Revenue----Total Items----Revenue
Simon-------------3-----------$300----------3---------$300--------0-----------0----------------6--------------$600
Tony---------------1-------------$100---------0--------$0-----------5------------$500-----------6--------------$600

Thanks @lubos

#4

Currently, custom reports are too limited to allow for this. But you will be able to get these reports in the future. Ask in about a month. It could be possible by then.

#5

Hi I’m struggling with the same issue so wonder if any update ?

#6

Still no progress on documentation for custom reports.