Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Report - Sales Commission

Hi Guys

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.

Thank You

Former Member
Former Member replied

Hi Euston

Have a look at this thread I replied to yesterday for an example of writing to Temp tables through a Stored Procedure.

Sales analysis by supplier

Let me know if you need further assistance with this.

Kind regards

Peter Juby

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question