Creating Formatted Search in Issue for Production Form

[Former Member]

Hi all SCN members,

I Have a question regarding creating FMS in SBO application. I have create a row UDF in Issue For Production Order based on this query :

SELECT (OITW.OnHand) FROM OITW

WHERE OITW.ItemCode = $[IGE1.ItemCode] AND OITW.WhsCode = $[IGE1.wareHouse]

and I have this FMS based on this criteria :

But when I entered a production order in Issue for production and choos the order no. the UDF field in the row doesn't show any results. Could you please tell me what I miss ? Thanks in advance.

Regards

[former_member186095 · Accepted solution]

Hi Ryan,

I am afraid your query is not correct.

here is the modified query:

SELECT (OITW.OnHand) FROM OITW

WHERE OITW.ItemCode = $[IGE1.ItemCode] AND OITW.WhsCode = $[IGE1.whscode]

here is the result:

you can try again. Smg berhasil (good luck)

JM

[Former Member · Accepted solution]

Hi Jimmy,

Big Thanks for your reply, coz your solution works perfectly man !!! thanks awesome. But there is one more thing I would like to ask. My FMS purpose is to display quantity info based on itemcode and warehouse code, so I have this item FG0005Z in the warehouse 03 and the qty is 2.2975 in item master data inventory data tab but when it was displayed in FMS it was displayed 2.30 not 2.2975, how can that be. I created the UDF for my FMS using the type of Units and Totals in the structure of Amount, so what's wrong ? why the qty. amount in the inventory data is different in the FMS, could you give one more solution. Thanks in advance.

Regards

[former_member186095 · Accepted solution]

You are welcome Ryan.

The FMS displayed 2.3 because it is probably rounded by the query FMS or caused by wrong structure of udf.

So, I suggest to create new udf with units and totals but the structure is quantity. Then assign the query FMS back

JM

[Former Member · Accepted solution]

Hi Jimmy,

Your solution works great man !!! awesome, I did change to the quantity structure and the result is the way I wanted, thanks a lot, problem solved, hopefully it can give a solution to anybody who have the same problem. Thank you all.

Regards

[Former Member]

Hi Ryan.....

If you manually click on Indicator Glass of FMS or Shift + F2 the does it display the result?

Else check with Refresh Regularly in spite of Display Saved Values.......

Or you may check Refresh Regularly on some other row level field change instead of Order No.

Regards,

Rahul

[Former Member]

Hi Rahul,

Thanks for the reply, about what you said that I should click on the indicator glass of FMS or Shift + F2 to display the result It gives me this error :

Internal Error(-1008)occured [Message 131-183]

And about your suggestion using refresh regulary or using some other row level field, I already tried using refresh regularly and it still didn't work, beside I'm kinda confused which to use other row field to trigger the FMS, maybe you have another suggestions or anybody ?

Thanks