Search 800 + Posts

Jun 2, 2010

Under and Over Shipment with Tolerance and Line Split

In this Post I will explain how Tolerance work in R11i Oracle Order management with respect to Under Shipment and Over Shipment .

In the 11i Release, If we have define the Tolerance and performs Over/Under, system will not Retain the Unstaged quantity, rather it will cancel the remaining Unstaged quantity (as long as Over/Under tolerance fulfilled). This is little hard to explain in words, so let me explain that with 2 simple examples, One for Under Shipment and one for Over Shipment.

Note – In R12 , Oracle Shipping has offered solution to “Retain Unstaged Quantity during Over shipment or Under shipment”, will discuss that in my next post.


Under Shipment

1.If you have Order quantity = 10 and Over /Under Tolerance is say 20%.
2.Book the Sales Order.
3.Query the Order in Shipping transaction Form .
4.Manual Split the Delivery details with Qty 9 and 1
5.Pick Release and Ship Confirm the Delivery Details with qty 9.
6.After ITS execution, System will cancel the Delivery details with Qty = 1 and Close the Order line with Order Qty = 10, Ship Qty = 9 (because criteria for Under Tolerance 20% met) and there will be no line Split as other delivery detail got cancelled.


Over Shipment

1.If you have Order quantity = 100 and Over /Under Tolerance is say 20%.
2.Book the Sales Order.
3.Query the Order in shipping transaction Form.
4.Manual Split the Delivery details with Qty 90 and 10.
5.Pick Release Order with parameter
a.Auto Allocate = Yes
b.Auto Pick Confirm = Yes and
c.Auto Create Delivery = No (because I want manual transact move order).
6.Go to Move Transact Order, Select the line with qty = 90, and press view/Update button and change Qty from 90 to 105, Press Transact Button
7.Delivery details with quantity 90 will be Staged with quantity 105and delivery details with qty = 10 will be now in cancel.
8.Run Ship Confirm and ITS.
9.System will close the line with Order Qty = 100 and Shipped Qty =105(Over Tolerance= 20%) but there will be no line Split as other delivery detail got cancelled.


Hope that helps