goods issue

[Former Member]

hi friends,

   our user creating goods issue documents for scrap item . every goods issue documents having above 50 line item . so i plan to import these item through the DTW . but here my problem is before adding the goods issue this document will go for approval . now what i will do ??how do i solve it.?? any other way is there?

or other wise i need. or any possible is there below screen shot i have explained those things.

item           quantity       warehouse     instock   

Ma10001      20                ExScr          200

above item total qty in-stock is   200

Exsc  - scrap warehouse stock is 30 qty

so i need to visible only that 30 qty . why i need this . after getting approval the error came " quantity falls in negative " so i need to solve this issue

below scenario i need it . any possible to UDF with FMS ????

item           quantity       warehouse     instock     scrap warehouse in stock

Ma10001      20                ExScr          200                30

[Former Member · Accepted solution]

Hi Ramesh.......

You can anyway handle this by using UDF and FMS apply in it for getting Warehouse wise Instock.

Try this below FMS for getting run time instock for Item selected for the selected warehouse......

Select OnHand From OITW Where WhsCode=$[IGE1.WhsCode.0] And ItemCode=$[IGE1.ItemCode.0]

Regards,

Rahul

[Former Member · Accepted solution]

kindly tell how do i create a UDF , where i will go to create this is row level or title level this is first time for me . so tell step by step

[Former Member · Accepted solution]

Hi Ramesh........

Please go through this quick video to learn how to create UDF....

You have to create your UDF under Marketing Category for Row Level.....

http://www.youtube.com/watch?v=5OCvrOYW_rc

Regards,

Rahul

[Former Member]

Hi,

The UDF and FMS will update you the Exc Scrap stock in Goods Issue, but the Stock update on the UDF may not be actual instock of the warehouse during approval.

Example.

Item Code : A, Scrap Stock : 20 Qty

GI No :1, while adding, the UDF will capture Scrap Stock : 20 Qty

GI No : 2 , While adding, the UDF will capture Scrap Stock : 20 Qty (Because the GI 1 is not approved and Added yet)