My Oracle Support Banner

How Can one Automatically Add an Item To the Sales Order Based On Ordered Quantity From Another Item? (Doc ID 816244.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


How does one automatically add another item to the sales order based
on the ordered quantity of another item on the order?

For example:
Automatically add an item called "Setup Item" ($250) to sales order if another item quantity < 5000


For drop ship orders, wants to automatically add a setup fee that the supplier
adds to a drop ship order if the quantity ordered is less than $5000.
They have setup an freight charge for $250, but the charges do not go
to purchasing for a drop ship order.

They are using a blanket agreement in Purchasing.
Only the lines get moved to PO Req (not the charges).
So, they cannot add freight>special charges to the drop ship order, since they don't get moved
to PO.
Agreement with the supplier is that if they release less than an agreed upon quantity, then there
is an addition a setup charge.
So the vendor needs to see this Setup charge on the PO because they need to take some additional
action when it is there.
You enter an order with an item <item1> with quantity = 100
The system automatically adds item "Setup Item" ($250) on a new line
if the quantity for item <item1>< 5000.


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.