My Oracle Support Banner

How Does One Restrict Application of a Group Of Lines Modifier to Specific Items or Item Number? (Doc ID 1167493.1)

Last updated on OCTOBER 18, 2023

Applies to:

Oracle Advanced Pricing - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Form:QPXPRMLS.FMB - Modifier Details


Goal


This note will address the following question:

How does one restrict application of a group of lines modifier to specific items
or Item Number?


Business Requirement:
Need price break modifier to apply a discount on a group of lines,
for specific items to be considered from a sales order,
for this discount based on the total item quantity.
If item quantity between 20 - 50 discount 2%
if item quantity between 51 - 90000 discount 3%
Following sales order example:
Sales Order LInes
Line 1.1 ITEM1 QTY 15 LIST PRICE 100
Line 2.1 ITEM2 QTY 10 LIST PRICE 200
Expected results:
Sum ordered quantity for  ITEM 1, AND ITEM 2 = 25,
Discount for ITEM 1 is 2% and
Discount for ITEM 2 is 2%



Solution

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
Goal
 How does one restrict application of a group of lines modifier to specific items
or Item Number?
Solution
 Here are two modifier setup options that would provide the desired results.
 1) Add items where this price break should be given to an item category.
 2) Add all items and exclude items that are not applicable to this discount


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