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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to Get Report Sales Gross Profit by Sales Rep ?
Hi Community,
Is there any standard NetSuite report that can show Gross Profit by Sales Rep?
Based on my review, the closest standard report is Customer Profitability. In this report, I can see Revenue, Cost, and Profit amounts.
However, when I try to add a Sales Rep column, I face an issue:
- The Sales Rep name only appears on the Revenue row.
- On the Cost row, the Sales Rep field is blank.
From what I understand, the Revenue is sourced from the Invoice transaction, which contains Sales Rep information.
But the Cost is sourced from the Item Fulfillment transaction, and Item Fulfillment does not have a standard Sales Rep field. That may be why the Sales Rep column is empty for the Cost row.
Tagged:
0