Need To Understand The Priority Of Reservation Quantity Transfer Which Happens During Onhand Receipt
(Doc ID 2764045.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Goal
On : 12.1.3 version, Reservations
What is the priority of Reservation quantity transfer which happens during Onhand receipt?
Scenario
---------
Two demands are created for Inventory and Sales order having same PO as Supply.
- Create a PO# 123 for item# A, qty = 1000.
- Create a SO# 10 for the same item# A, qty = 200.
- Let us suppose current on-hand of item = 1000
- Go to Inventory > Reservations. Create below entries -
Entry #1
- Demand type = Inventory, need-by-date = 29-MAR-2021, qty = 500
- Supply type = PO, need-by-date = 29-MAR-2021, qty = 500
- On-hand = 1000
- Available = 1000
Entry #2
- Demand type = Sales Order, need-by-date = 29-MAR-2021, qty = 200
- Supply type = PO, need-by-date = 29-MAR-2021, qty = 200
- On-hand = 500
- Available = 500
- Ordered = 200
5. Now, receive PO# 123 for qty = 200
6. You will below changes in Reservations -
Entry #1
- Demand type = Inventory, need-by-date = 29-MAR-2021, qty = 500
- Supply type = PO, need-by-date = 29-MAR-2021, qty = 500
- On-hand = 800
- Available = 800
Entry #2
- Demand type = Sales Order, need-by-date = 29-MAR-2021, qty = 200
- Supply type = Inventory, need-by-date = 29-MAR-2021, qty = 200
- On-hand = 1200
- Available = 700
- Ordered = 200
You can see the supply reservation is changed to inventory and reservation quantity is transferred to sales order
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 |
Solution |
References |