JDE Reference
45Advanced Pricing
Supply chainRules-based pricing and adjustments layered over base sales and procurement pricing
9 tables2 programs
Verified September 2026
Tables
Master Data · 3
- F4072One row per adjustment rate: the factor value for a given adjustment name, item or item group, customer or customer group, currency, UOM, quantity level break, and effective-date window. The rate lookup behind every Advanced Pricing calculation.master
- F4106Item base price table: effective-dated unit and credit prices by item and branch, optionally specific to a customer, customer group, currency, and unit of measure.master
- F41061Supplier price catalog: supplier- and catalog-specific purchase prices with quantity breaks and effective date ranges, feeding PO unit cost retrieval.master
Transactional · 1
Control / Setup · 5
- F4071One row per price adjustment definition: the named rule (discount, rebate, promotion, override) with the control switches that decide how it applies — group keys, level-break type, adjustment level, mandatory and G/L behavior.control
- F4092One row per price group definition: names an item, customer, or order group and lists which category-code keys (up to 10) make up the group, ordered by the key columns.control
- F40941One row per item price group combination: an item group plus a specific set of item category-code values, assigned a numeric key ID (IGID) that F4072 rate rows point at.control
- F40942One row per customer price group combination: a customer group plus a specific set of customer category-code values, assigned a numeric key ID (CGID) that F4072 rate rows point at.control
- F40943One row per order detail group combination: an order detail group plus a specific set of sales-order line attribute values (up to 8), assigned a numeric key ID (OGID) that F4072 rate rows point at.control
Programs
- P4071Price Adjustment Definitions — the screen where advanced pricing adjustments are defined: adjustment name, controls, target application, and preference hierarchy.Interactive
- P4072Price Adjustment Detail Revisions — the screen where the actual pricing rules are set for an adjustment: basis codes, factor values, level breaks, and effective dates.Interactive