Skip to Content
0

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

Jul 06, 2017 at 06:58 AM

25

avatar image
Shahan Shams

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
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
Balaji Selvaraj Answered Jul 06, 2017 at 07:09 AM
0

Hi Shahan

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

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users