Need FMS to populate the avaliable stock of item accoding to Selected WHS IN Delivery Note

[Former Member]

Dear Experts

I had created a UDF in delivery not in the name of 'Stock In Whs',

what i need is when i select an item in line i need to get the Stock in Hand of that item in the that whs , in system default am getting All items under the Company,

Pls provide me an FMS which will auto populate the IN Stock against the item and Whse which i select in line wise

Regards

[former_member312729 · Accepted solution]

Hi Shahan

SELECT T0.[OnHand] FROM OITW T0 where T0.[ItemCode] =$[$38.1.0] and T0.WhsCode =$[dln1.WhsCode.0]

Regards:

Balaji.S