E1: 45: Preference Hierarchy Functionality for Advanced Pricing (P40073, P4074, P4071, P4072) (Doc ID 1346821.1)

Last updated on APRIL 09, 2024

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version XE and later
Information in this document applies to any platform.

Purpose

The Preference Hierarchy (P40073) is part of the mandatory set up in order for Advanced Pricing to work. Customers must determine their hierarchy and understand that the Preference Hierarchy program (P40073) is used by the system to search and apply the Price to an order either within the Price History (P4074) or directly to the detail line (Order level adjustments).

The Preference Hierarchy is designed to work from most specific to most general when doing a search for a price adjustment.

In this example, a simple, 4-level hierarchy might indicate “First search the details that match both the customer and item number specifically. If no adjustment is found, then search the details that use Customer Group and Item number” If any adjustments exist for the Customer Group/Item then the system will stop and apply the adjustment that has been found and no further search will occur.

Note: The user can enter up to 21 hierarchies, however Oracle recommends limiting the use to 3 to 4 hierarchies for better performance per adjustment. The more hierarchies found within the Preference Hierarchy program, the longer the system will take to find and return the adjustments to the order.

Scope

Advanced pricing uses the Preference Hierarchy to locate which adjustments need to be applied. Note this same program works for Base price and Advanced Preferences and functions exactly the same. This feature is available in all EnterpriseOne releases for both Sales and Procurement.