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.