Crystal Report - Sales Commission
I am doing a Crystal Report that will provide the total # of invoices per sales employee, the total value of these invoices as well as the total # of credit notes and total value of these grouped per Sales Employee. The problem i am having is that the credit note repeats for each single invoice, so if there is 10 invoices then the credit notes will repeat for invoice number 1 till 10.
Another issue is that i want to report on the document owner on the same invoices and credit notes, so i will have a duplicate report that will have the same fields as above just using Doc Owner instead of Sales Employee. I have referenced the OHEM first name as the Field that i group by for Doc Owner as the Doc Owner returns a numeric value from OHEM called EMPID, so i use this to return the first name.
Please advise as to what needs to be done in order to get this report to work, i use it to calculate Sales Person commission where they are the Owner and Sales Employees of invoices and credit notes.