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

Last updated on OCTOBER 23, 2015

Applies to:

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

Symptoms

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.

Example:
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).

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms