Update Delivery Note with Warehouse Quantity?

[Former Member]

Hello EXperts,

i have a customer who wants to update his delivery note with the quantity available in warehouse per an item been used for the delivery.

I need a query to save and apply UDV in SAP B1 so that anytime there's a delivery it shows the items available quantity per row from warehouse.

i have created a UDF(FT) so that it will be updated with the available stock per items and per row.

Attached is the images of what i want to achieve.

Urgent Help is required.

Regards

Justice

[Former Member · Accepted solution]

Hi Justice

Try this:

SELECT T0.[OnHand] + T0.[OnOrder] - T0.[IsCommited] FROM OITW T0 WHERE T0.[ItemCode] = $[$38.1.0] AND T0.[WhsCode] = $[$38.24.0]

Kind regards

Peter Juby

[Former Member]

Hi Justice,

You can get this in Standard Functionality of SAP B1.

Please activate In Stock Column from Form Setting of Delivery.

This field will give you In Stock Quantity for Selected Warehouse. Please check below Snapshot.

Hope this help

--

--

Regards:::::

Atul Chakraborty