Skip to Content
0

Item Available Quantity without PO Qty

Oct 31, 2016 at 03:46 AM

44

avatar image

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]

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Oct 31, 2016 at 01:12 PM
0

Hi,

Please try this,

Thanks


image-4.png (16.5 kB)
Share
10 |10000 characters needed characters left characters exceeded
Kedalene Chong Nov 02, 2016 at 01:57 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded