on 06-04-2014 6:56 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.