Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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.
0