FMS Help Needed

[Former Member]

Dear Expert,

Can anybody help me to get FMS query. Actually my requirement is like I want value from production order header to Receipt from production header level. We have one UDF in production order as U_Batch_No where we write Batch No and we want to fetch that value into receipt from production UDF.

I tried with 1 FMS query but it works at Row level only.

SELECT T0.[U_UDF FROM PRODUCTION WITH BATCH DETAILS] FROM OWOR T0 WHERE T0.[DocNum] = $[IGE1.BaseRef]

Please correct me and help.

Regards,

Harshal Makwana

[kothandaraman_nagarajan · Accepted solution]

Hi,

Why your UDF so descrptive?

SELECT T0.[U_UDF FROM PRODUCTION WITH BATCH DETAILS] FROM OWOR T0 WHERE T0.[DocNum] = $[$13.61.number]

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Dear Sir,

I tried with your query but gives message as internal error(3006) occurred.

Regards,

Harshal

[kothandaraman_nagarajan · Accepted solution]

Try:

SELECT T0.U_Batch_No FROM OWOR T0 WHERE T0.[DocNum] = $[$-13.61.number]

[Former Member · Accepted solution]

Dear Sir,

FMS is perfectly working fine just need one more help needed from you as is it possible to put auto refresh when production order changes so that batch no. automatically fetch without clicking on mirror icon. I have tried but unable to get desired result.

Please help.

Regards,

Harshal Makwana

[kothandaraman_nagarajan · Accepted solution]

There is no option auto refresh based on production order. you have to choose refresh regularly.

[Former Member]

Dear All,

Thanks for all your valuable response.

Regards,

Harshal

[Former Member]

Hi Harshal,

Production order in the receipt from production is in the row level. Do you always have only one production order to receipt?

Thanks,

Gordon

[Former Member]

Hello Sir,

Yes we always have one production order to receipt.

Regards,

Harshal Makwana

[Former Member]

Even you only have one line, the FMS may only be refreshed manually if there is any changes.

[former_member184146]

Hi,

     Try this

SELECT T0.[U_UDF FROM PRODUCTION WITH BATCH DETAILS] FROM OWOR T0 WHERE T0.[DocNum] = $[IGN1.BaseRef]

Regards,

Manish

[Former Member]

Hi Manish,

That works at row level only and at Header level it shows internal error.

Regards,

Harshal