The Extended Terms Advanced Preference was created to offer customers a more favorable payment term based on the quantity of an item that is ordered. For example, if the total quantity of items in basket A exceed 1000, all order lines in the basket will receive payment terms of net 60 days, rather than net 30 days. The Extended Terms preference offers additional flexibility in extending different payment terms options for Basket and Enhanced Baskets.
The Extended Terms Advanced Preference was created to offer customers a more favorable payment term based on the quantity of an item that is ordered. For example, if the total quantity of items in basket A exceed 1000, all order lines in the basket will receive payment terms of net 60 days, rather than net 30 days.
The functionality is based on Advanced Preferences functionality. Both simple baskets (those defined at the Item Branch) and enhanced baskets can be used. This preference only works with groups (baskets) of items; the preference cannot be set up to work with individual items. Order Level adjustments are not supported with Extended Terms. For more information on baskets and enhanced baskets please see the solutions: Basket and Order Re-pricing (Advanced Pricing) and Enhanced Baskets.
Advanced Preferences Name Revisions
From menu G40311 select Advanced Preferences Name Revisions (P4071).
Click Add and input the Preference name and Description
Input a Preference Hierarchy, Advanced Preference Type 17, and Level Break Type.
Note: The Level Break Type can be Quantity or Non-Quantity based. Also, Preference History can be activated as well as activating this preference for Enhanced Baskets.
Advanced Preference Detail Revisions
From menu G40311 select Advanced Preference Detail Revisions (P4072).
Select an existing detail record or press Add to create a new Preference Detail
The preference hierarchy selection form will appear. Which hierarchy options appear is based on the preference hierarchy defined for this preference during Preference Name Definition
Specify the desired Basket Reprice Group, From Level and Date Range
To access the Preference Details form, select the record and take Row Exit to "Pref Details".
Add the new details: Sequence, Business Unit, and Payment Terms (PTC).
Basket and Order Level Pricing (R42750)
Processing options have been added to the Order and Basket Level Pricing (R42750) UBE, in the Update Options tab, for resolving the Basket Level Preference:
Extended Term Preference: If this processing option is set to 1, the system will use the Extended Term preference for simple baskets specified in Advanced Preference Detail Revisions (P4072).
Extended Term Payment Comparison: Use this processing option to specify whether the system replaces the payment terms on a sales order line with an extended-terms-preference value. Valid values are:
Blank- the system selects the payment terms code with the greater discount percent. For example, if the payment terms discount is "2% 10, Net 30 Days", the system only replaces the discount with a payment terms code (with a discount greater than 2%).
1 - The system selects the payments-terms code with the greater amount of discount days. For example, if the payment terms discount is "2% 10, Net 30 Days", the system replaces the discount with a payment terms code (discount days that are greater than 10 days).
2 - The system selects the payment terms code with the greater net days to pay. For example, if the payment terms discount is "2% 10, Net 30 Days", the system replaces the discount with a payment terms code in which net days to pay is greater than 30 days. Note: The system will not replace payment terms that you enter manually during sales order entry.
Sales Order Entry (P4210) Processing Options
Make sure that the correct version of the R42750 UBE is set in the processing option for the P4210 application, in the Versions tab.
If required, check that the Auto Order Repricing option, in the Process tab, is also set to value 1.
Example
Define a new basket and add an item to the basket pricing group in the Item Branch information (P41026) application. For more information on baskets please see solution: Basket and Order Re-pricing (Advanced Pricing).
Define a new preference name.
Create a new preference detail specifying the basket reprice group and the level from where the new payment term will apply.
Define Preference Details and set the new payment term.
Create a new sales order that defaults payment terms "002"-Net 30 days. Check the payment terms field in Sales Order Detail table, F4211:
Reprice the order by selecting it and take the Form Exit "Reprice Order" option. Alternatively, if the Auto Re-price processing option behind the P4210 has been set, the order will be repriced automatically.
Based on the Advanced Preference setup above, the new payment term should be P4 (net 40 days) since the item in the basket exceeds the 'From level' set in the Advanced Preference Detail based on the processing option set behind R42750 to use the payment term with the greater number of net days:
Additional Information
Additional logic was added in Extended Terms processing to handle the Enhanced Basket enhancement starting in E1 8.9 - enhancement BUG 12491165 -"Extended Terms".
The Extended Terms preference (type 17) is used for Item Groups only. For more details please see BUG 10999744 - "Extended Payment Terms hierarchy".
The preference can be based on a Quantity ONLY; it is not possible to set up the preference details (P4072) with a monetary amount or a weight value.
