Formula to Calculate Available to Reserve at Different levels

The formula is  

Actual Available to Reserve = Minimum (Available to Reserve at Particular node/Sub Inventory level, Available to Reserve at higher nodes/ Inventory Organization Level)Explanation
——————————–
1. Organization level (highest level):

On Hand Quantity for item A = 345 – 30 = 315

(Here Consider 30 is stuck quantity in MMTT, Mean unprocessed pending transactions in MMTT)

So Available to Reserve at Organization level = 315
——————————–
2. Sub Inv level:On Hand Quantity for item A = 345
Available to Reserve at Sub Inventory level= 315
Actual Available to Reserve = Minimum (Available to Reserve at Sub Inventory level, Available to Reserve at Organization level)
Insert value in a table column c

Select Min(c) from dual

Result will be 315 Available to Reserve is 315

If anyone have any observation / reservation then let me know

Advertisements

One thought on “Formula to Calculate Available to Reserve at Different levels

  1. In R12, Where are or where I see the Available to Reserve at Particular node/Sub Inventory level, Available to Reserve at higher nodes/ Inventory Organization Level for an Item?

    I have this qry but this not retrive any rows. The table is null, why?

    SELECT SUM (reservation_quantity) FROM mtl_reservations
    WHERE inventory_item_id = :inventory_item_id AND organization_id = :p_org_id;

    Thanks in advance

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s