Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
We apologize for any inconvenience this may cause and appreciate your understanding.
Commissions Reports: Visibility of Gross Profit & Sales Team Member %
I am doing the normal hunt-and-peck in reports to try to find the fields I want in commission reports. First, there seem to be two types of reports with the following tables:
1. Commissions Overview + Sales Rep
2. Paid Commissions + Sales Rep
I am trying to figure out how to have the following fields appear on either report:
a. Gross Profit ($ or %). Source Opportunity sub-table has this field, but seems to show nothing? What does this draw from? In the Commissions Overview table, there is a Transaction sub-table that has some fields but is missing the Est Gross Profit field !?!?!
b. Net Amount Collected on a given Invoice (driver of the commission by collection; we have team selling so "base amount" would otherwise work but in this case base amount is the net amt collected x SalesRep% on the Sales Team tab. If I could isolate the sales rep % on the transaction in the sales team tab I could back into it but I can't find that either...).