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.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Sales Rep Profit Margin % Report to Pay Comission
My sales reps get paid different comission brackets based on their overall profit margin for the month, each month.
I am trying to make a report that shows what overall profit margin they sold at per month, and ideally i would like the report to be live, and on their dashboard so they can see what profit margin they are selling at, at any any time.
When i say profit margin, i mean
Profit Margin % = (GROSS SALES - COST OF GOODS SOLD)/GROSS SALES)*100
I have been able to accomplish something like this in accrual basis, but what if you only wanted to pay commission on sales that money has been collected on? This provides some complications.
0