Item Available Quantity without PO Qty

[kedalenechong]

Hi all

How to create a Query and formatted search to obtain Inventory Item Available Quantity by Warehouse to show in Item Master Data window User Defined Field per warehouse row without adding Open Purchase Orders?

Example Available Quantity = On Hand less Committed Quantity

The current Available Qty is On Hand less Committed Quantity add Open Purchase Quantity.

I used this Query statement but it only shows on the first row of warehouse code in Item Master Inventory Data tab using SHIFT F2

SELECT T0.ONHAND - T0.ISCOMMITED FROM OITW T0 WHERE T0.ITEMCODE = $[$5.0.1]
AND T0.WHSCODE = $[$28.1.1]

How to refresh values so that it will automatically display the formatted Quantity on every row of warehouse code in Item Master Inventory Data tab without using SHIFT F2?

I wasnt able to reply to Agustin Marcos Cividanes in my Archived Discussion for giving me a tip to try try this FMS:

SELECT T0.ONHAND - T0.ISCOMMITED FROM OITW T0 WHERE T0.ITEMCODE = $[$38.1.0]

AND T0.WHSCODE = $[$38.1.24]

[kedalenechong]

Thanks all! It works when I refresh regularly by Warehouse Code!

[kothandaraman_nagarajan]

Hi,

Please try this,

Thanks

[narayanis]

Hi,

Have you tried refreshing the FMS on change of warehouse ?

I guess the FMS might not be getting refreshed regularly or on an incorrect field.

Regards

Narayani