This article will discuss the points to be considered for custom sales commission generation in NetSuite
- Sales commission for employees are calculated based on Sales amount excluding the tax and other costs including shipping charges. The field to consider will be ” AMOUNT NET OF TAX”
- Sales commission for partial paid transactions when calculating Overdue amount: Take the ratio of amount paid to total amount * amount (net of tax) to fetch the proportion of amount remaining.
- Sales Target is saved under Quota record, unless custom redefined as a record.
- Sales manager and Sales rep may or may not have same commission percentage or amount. The total sales amount for the sales manager may be inclusive of the sales of all subordinates reporting under him + the sales done by him if he’s sales rep , if Team Quota is allowed.
- Most of the commission amount calculations are carried out monthly or quarterly. If quarterly, additional bonuses will come at play as per requirement from client.
- All the grouped invoices/ Credit Memo sales will be applied usually to the Sales Manager
- Commission can be defined for a new sales rep when target is not defined. However, the commission will be a definite percentage of the sales until target is defined for the POC.
- Check on how the commission will be generated for sales associate who became inactive during mid-month but had captured sales for the same month when he was active. The Target / quota defined for that employee will alter accordingly , from monthly basis to daily basis.
- The body level discounts will be excluded in Subtotal whereas line level discounts are included in Subtotal. When retrieving AMOUNT NET OF TAX value , it will return Subtotal value.