How to Prevent Selling Price from Becoming a Negative Price When Applying Modifiers
Last updated on JUNE 19, 2018
Applies to:Oracle Advanced Pricing - Version 11.5.9 and later
Oracle Order Management - Version 11.5.9 and later
Information in this document applies to any platform.
FORM:OEXOEORD.FMB - Sales Orders
The purpose of this Note is to explain and provide examples of how to apply a discount modifier
to the resultant selling price of an order line, or all lines, in such a way as to prevent the
selling price from becoming negative. This is to solve a problem caused by the current design of
modifiers whereby order level and manual modifiers are placed in the null bucket, which means that
they get applied to the list price of the item.
For example, say item A has list price 100.00 and after a discount the selling price becomes 80.00.
If an order level 100% modifier is now applied the resultant selling price would be calculated as
Selling Price = 100.00 + (-20.00 which is previous discount) + (-100.00 which is the order level modifier).
This results in -20.00, and not 0.00 which is the desired result.
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