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!
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