| Commission/rebate over cumulative sales |  |
| COMMISSION/REBATE BASED ON CUMULATIVE SALES Instead of calculating commissions or rebates for each individual sales order (or order line), you can calculate commissions or rebates on the basis of the sum of all sales orders that are closed in a particular period. Each relation can have a different period table. The relations are calculated every week: On the first grade of 20,000 : 5%. On the rest : 10%. In one week, this sales person acquires three orders:
Day | Amount
--- | ---
Monday | 7,500
Tuesday | 12,000
Friday | 13,500
Sum | 33,000
The commission is calculated over the total amount: 33,000.
    Commission calculation:
    5% of 20,000:     1,000
    10% of 13,000:    1,300
    Total commission: 2,300
CALCULATION PROCEDURE The calculation of commissions and rebates, based on cumulative sales, is performed in the following two sessions: Calculate Commissions and Rebates (tdcms0240m000) Calculate Commissions/Rebates on Cumulative Sales (tdcms1200m000) The procedure is as follows: Select the applicable agreement. ERP LN selects the applicable agreement for the calculation and determines if this is a cumulative or a non-cumulative agreement. In case the agreement is cumulative, ERP LN does not calculate the commissions and rebates immediately, but stores the sales data in a separate file, sorted by agreement and relation. See the Cumulative Agreement field in the sessions: Commission Agreement Parameters (tdcms0135s000) Rebate Agreement Parameters (tdcms1135s000) Calculate commissions and rebates. Use the Calculate Commissions/Rebates on Cumulative Sales (tdcms1200m000) session to calculate the commissions and rebates on the basis of the cumulative sales data that has been recorded. The Calculate Commissions/Rebates Based on Cum. Sales after Order Entry and the Calculate Rebates based on Cum. Sales after Order Entry fields in the Commissions/Rebates Parameters (tdcms0100s000) session determine how the commissions/rebates on cumulative sales are calculated. You can modify the calculated commissions and rebates in the following sessions: Commissions Calculated by Order (tdcms0550m000) Commissions Calculated by Relation (tdcms1550m000) Rebates Calculated by Order (tdcms2550m000) Rebates Calculated by Relation (tdcms3550m000) Note If you want to apply the cumulative calculation method, you must make sure that no non-cumulative agreement with a higher priority exists. (See the Commissions/Rebates Parameters ) session. To ensure that ERP LN does not calculate the commissions and rebates until the current period is finished, set the Calculate Commission not Based on Cum Sales after Order Entry field to Manually. Related topics Overview of commissions and rebates To calculate commissions and rebates To reserve commissions and rebates |