Skip to Content

Item Available Quantity without PO Qty

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]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 31, 2016 at 08:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2016 at 01:12 PM

    Hi,

    Please try this,

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2016 at 01:57 AM

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

    Add comment
    10|10000 characters needed characters exceeded