My Oracle Support Banner

E1: 45: Ability To Have Order Level Tiered Supplier Price Adjustment (Doc ID 1929098.1)

Last updated on JULY 21, 2020

Applies to:

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


Requirement: In Procurement, the ability to add Order Level Adjustments that break down the unit price to the line level.  The client needs a new adjustment type that allows the system to take the total order weight/amount/quantity and divide the $ by each line to determine the unit cost.  Client also needs the system to show the next level break when the purchase order is being placed so that if more product is ordered, a greater price break is achieved.  This needs to be visible to the users when entering the purchase order.

P4072 has the following price breaks
200,000 per thousand will be priced at 250.00
250,000 per thousand the price is 225.00
300,000 per thousand the price 200.00

This will be performed Item grouping using 3 Category Codes in the Item Branch/Plant record.

When a purchase order for three items (with the same Category codes) is raised, with a total of 250 EA (1 ea/1000 thousand UOM conversion), the system will  hit the price break of 250,000 at 225.00 per order total.  Client needs this value not only converted to eaches but also to each line so that each line should show the same unit cost of .225 per EA item ordered.  Once the user clicks OK, the system should display a pop-up window to indicate that if an additional quantity is ordered. (50000 in this case), a higher discount would be available.  (Thinking something like the Display Before Accept functionality in Sales).




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.