How Can one Automatically Add an Item To the Sales Order Based On Ordered Quantity From Another Item?
Last updated on APRIL 03, 2017
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?
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
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 ABC with quantity = 100
The system automatically adds item "Setup Item" ($250) on a new line
if the quantity for item ABC < 5000.
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