Production Order -FMS

[Former Member]

Dear Experts,

In Production order Transaction, Sales order reference need to populated. Could you please help me.

SO FIELD NAME :U_IntRef

PRODUCTION ORDER : U_INREF

Actually FMS written as,

SELECT T1.U_IntRef from OWOR T0 inner join ORDR T1 on T0.OriginNum = T1.DocNum

Above FMS displayed all the references from sale order.

Actually my requirement, Sales order against Production order executes through procurement conformation wizard. Respective reference need to populated in PROD Order.

Further information please check screenshot.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Set Auto Refresh When Field Changes-->Production origin number.

Thank you.

[former_member211473]

Hii Yousuf

Try this ,

SELECT T1.U_intref from OWOR T0 inner join ORDR T1 on T0.OriginNum = T1.DocNum where t1.docnum = $[owor.originnum]

Regards

Ranu

[Former Member]

Hai Ranu,

Its working fine, but all the time by default production updation required.

Please find the attachment.

[former_member211473]

hii yousuf

apply auto refresh on customer code and select 'display saved user defined value'.

it won't give update option.

thanks

ranu

[Former Member]

Auto refresh by customer code, Same thing to carryout.

Please provide alternate solution

[former_member211473]

hii yousuf,

once i had the same issue, I removed auto refresh and tried manually everything was fine.

thanks

Ranu

[Former Member]

Hai,

Mannual Also facing same kind of thing.

[former_member212181]

Hi Yousuf,

Please try below query for FMS

SELECT T1.U_IntRef

FROM [dbo].[OWOR]  T0

Inner Join ORDR T1 on T0.OriginAbs = T1.DocEntry

Inner Join OFPR T2 on T0.PostDate >= T2.F_RefDate and T0.PostDate <=T2.T_RefDate

Inner Join OACP T3 on T2.[Category] = T3.[PeriodCat]

WHERE T0.[DocNum] = $[$18.0.Number]

    and T3.Year = Year($[$24.0.Date])

Thanks

Unnikrishnan

Message was edited by: Unnikrishnan Balan

[Former Member]

Dear Unnikrishnan Balan,

Thanks for the reply.But unfortunately Not working

[former_member212181]

Hi Yousuf,

Its working in my system,
May i know the error message please??

Thanks

Unnikrishnan

[Former Member]

Dear Unni,

Nothing response shown in screen. Simply blank

[Former Member]

Dear experts,

Any update, Its urgent. Please help me