JD Edwards Advanced Pricing: Adjustment Types, Schedules and Definitions Explained

Typical setup order

1. 1Turn on Advanced Pricing in the Sales Order Management constants and the order type or line type rules where pricing should apply.
2. 2Define the preference hierarchies and pricing groups you need, for example customer group and item group, so prices can target categories instead of single records.
3. 3Create price adjustment types, which control how the adjustment is calculated and which preference hierarchy it uses.
4. 4Create price adjustment definitions that specify the calculation basis, such as a unit price, a percentage off, or a markup, and any quantity or amount breaks.
5. 5Create price adjustment names and attach the types and definitions, then build the price adjustment schedule that lists those names in sequence.
6. 6Attach the schedule to customers in the customer billing instructions and to items in the item branch or sales category, as your hierarchy requires.
7. 7Test on a sales order: review the price adjustments on the order line and the price adjustment ledger to see which adjustments applied and why.

Tables you will see in support and reporting

-- which adjustments were applied to a sales order line (names vary by release)
SELECT * FROM PRODDTA.F4074 WHERE ALDOCO = 100234 ORDER BY ALLNID

Common pitfalls

• !Attaching the schedule to the customer but not setting the customer or item groups the adjustment detail relies on.
• !Overlapping adjustments in the same schedule without a clear sequence, giving different prices depending on evaluation order.
• !Not testing with realistic quantity breaks, so the rule works for one unit and fails for a pallet.
• !Changing definitions in production without effective dates, instantly repricing open orders.
• !Building reports on pricing tables without checking the data dictionary, leading to wrong joins between tables in the F407x family.