Discussions
Report: Sales by Sales Rep Detail
We have taken the standard report Sales by Sales Rep Detail and customized it to be linear data. I.e.
Invoice Date, Invoice #, Sales Order #, Sales Rep, Company Name, Total
We see the report is generating one line item to has been paid in full on the invoices.
Example:
06/06/2022, INV1260, SO1292, EMP1035 John Smith, Beach House, $1,225.00
06/06/2022, INV1260, SO1292, EMP1035 John Smith, Beach House, $1,000.00
We would like to see one line item with the grand total on the invoice. i.e.
06/06/2022, INV1260, SO1292, EMP1035 John Smith, Beach House, $2,225.00
Any pointers would be greatly appreciated.