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.
My question is:
Is it possible to generate a standard report that shows Sales Rep, Revenue Amount, Cost Amount, and Profit Amount in the same row?
If this is not possible using standard reports, is there any recommended workaround (Saved Search, custom report, or customization) to achieve this?
Thank you.
Rian