How Splitting a Line Which Uses Block Pricing Shows An Incorrect Price
Last updated on MARCH 08, 2017
Applies to:Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
If we are using Block pricing for 0-250 Quantity = 0$,
then 251 -99999 as 2$, then while creating order for a quantity of 300,
the list price and unit selling price(USP) is showing as .333 and calculating total as 100$.
But Business requirement is it should create two lines for the same item.
Business requirement is if order will be booked for 300 Quantities,
then 1st for same item should be of Quantity 250 with 0$ for the list price and USP,
then 2nd line with same Quantity with Quantity as 50 with list price and USP as 2$ each,
making total as 100$.
If one manually splits the line which is for quantity of 300 with unit selling price = .333
using Actions > Split line for quantities 250 and 50, then the unit price is not as expected.
Line with quantity 250 has list price = 0$.
Line with quantity 50 has list price = 0$
Since I am splitting one order line, the list price and unit selling price(USP) of the original
should be maintained in all the split lines.
A valid scenario could be that the lines had to be split because they needed
to be sourced from different warehouses, but the customer is buying that
quantity for the block price. But in the present behavior he would be paying
twice the block price for no reason of his.
How can this be accomplished?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms