Rebate Agreements (tdcms0135m100)
Use this session to view, enter, and maintain rebate agreement parameters.
You can start this session in the details mode by clicking:
- Details on the appropriate menu of the Rebate Agreements (tdcms0135m100) overview session.
- Rebate Agreement Details on the menu of the Rebate Agreement (tdcms0635m100) session.
When you double-click a record, or click the Rebate Agreement (tdcms0635m100) session is started.
button, theField Information
- Sold-to Business Partner
- Relation
- Child Agreement
-
If this check box is selected, the agreement is a child agreement. You can only access this field if the Relation field is filled and if the Parent Rebate for Child check box in the Commissions/Rebates Parameters (tdcms0100s000) session is selected.
- Agreement Group
- Project
- Item
-
- Rebate Group
- Effective Date
-
The date from which the agreement is valid and effective.
- Expiry Date
-
The date from which the agreement is no longer valid and effective.
- Cumulative Agreement
-
If this check box is selected, this is an agreement to calculate rebates based on cumulative sales. LN records all sales for which this agreement is applicable in a separate file. At the end of the current period, you can calculate the rebate based on the total sales in this period with the Calculate Commissions/Rebates on Cumulative Sales (tdcms1200m000) session.
- Grade by Quantity/Amount
-
This field determines the basis for the grades.
- Currency
-
Note: If the Currency for Invoicing is set to Agreement in the Relations (tdcms0110s000) session, you can use this field to specify the invoice currency for a relation. However, if the agreement applies to an agreement group, you cannot define an invoice currency. In this case, the reference currency is used.
- Grade Unit
-
The unit that determines the grade. A grade unit only applies to agreements defined for items.
Note: You must first fill in the Item field and then choose Quantity in the Grade by Quantity/Amount field, so you can fill in the grade unit. - Grade Calculation
-
This field determines the basis for the grade calculation.
Example
If an item is ordered:
Quantity Unit Price Commission 100 20 1 % Result: Gross The commission is 100 * 20 * 1% = 20 Net The commission is 100 * 20 * 1% = 20 The remainder amount is 2000 - 20 = 1980 The final commission amount is 1% * 1980 = 19.80
- Fixed Amount On
-
This field determines how the rebates are calculated if a fixed amount is entered.
Allowed values
- Grade
-
The fixed amount is the commission/rebate amount. If the Grade by Quantity/Amount field is Amount, the Fixed Amount On field is always Grade.
- Unit
-
The fixed amount is a per unit amount. The total commission or rebate is calculated with the following formula:
Total Commission/Rebate = Fixed Amount * Sales Order Quantity.
- Rebate Over
-
The basis on which rebates are calculated.
-
Grade
The rebate is based on the amount or quantity in this grade. -
Total
The rebate is based on the total amount of an order, or order line.
Example
An order is placed for $25,000, using the following scale:
Up to % $10,000 0 $20,000 1 $30,000 2 $999,999 3 If the percentage is based on Grade, the following applies:
- $10,000 * 0% = $0
- $10,000 * 1% = $100
- $5,000 * 2% = $100
- Total = $200
If the percentage is based on Total, the rebate is calculated as follows:
$25,000 * 2% = $500
-
- Grow Rebate Over
-
The basis on which the growing rebates are calculated.
Example
A sales order is placed for $50,000. The normal rebate is based on Total. The growing rebate is based on Grade. The following scale is used:
Up to Normal % Growing % $10,000 0 0 $20,000 1 0 $30,000 2 1 $999,999 3 3 Rebate Calculation Normal $50,000 * 3% = $1,500 Growing - $10,000 * 0% = $0
- $10,000 * 0% = $0
- $10,000 * 1% = $100
- $20,000 * 3% = $600
- Total = $700
Total = $1,500 + $700 = $2,200 - Invoice Direct/Reserve
-
This field controls how LN settles the calculated rebate.
The following restrictions apply to this function:
- If an Employee relation type is specified in the agreement, this field is always Reserve.
- If the Link with Finance check box is selected in the Commissions/Rebates Parameters (tdcms0100s000) session and no Employee relation type is specified in the agreement, this field is Invoice.
Note:- Payments to employees will not be invoiced directly, because of legal requirements concerning taxation.
- When no relation is entered in the agreement, LN checks the relation type when rebates are posted to Invoicing . If the relation is an employee, the calculated rebate will always be accumulated, even if this field has the value Invoice.
Allowed values
- Invoice
-
The calculated commission or rebate is not reserved/accumulated, but is invoiced directly (this value does not apply for an Employee relation type).
- Reserve
-
The calculated commission or rebate is reserved/accumulated for invoicing.
- Discount Code
-
The discount code's type must correspond with the agreement's type ( Commission or Rebate), and must be suitable for use in an agreement.