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 MAY 01, 2023

Applies to:

Goal

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

or

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.

Solution

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