Skip to Content
avatar image
Former Member

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

Jul 06, 2017 at 06:58 AM | 26 Views

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

SAP Business One
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Balaji Selvaraj
    Jul 06, 2017 at 07:09 AM

    Hi Shahan

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

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded