I have a UDF field in OIGE ,is it Possible to retrieve that field data in OIGN

[karthick_s8]

Hi,

I have a UDF field in OIGE ,is it Possible to retrieve that field data in  OIGN

udf field=U_IssPLayout in OIGE.i want that data Should come in U_IssPLayout in OIGN

Regards

Karthick

[kothandaraman_nagarajan · Accepted solution]

Hi,

Do you have any common fied between tables?

Thanks & Regards,

Nagarajan

[karthick_s8 · Accepted solution]

NO ,FOR THAT ONLY,THIS FIELD NEED

[kothandaraman_nagarajan · Accepted solution]

Try this method:

1.  Add OIGN document number in OIGE Ref2 field.

2. Use below FMS to get value from OIGN table.

SELECT T0.[U_WIPNO] FROM OIGN T0 WHERE T0.[DocNum]  = $[OIGE.Ref2]

Replace your own UDF name.

[Former Member]

Hi Karthick,

Because there is no link between 2 tables, you must add link first before you can use FMS to retrieve UDF field data in OIGN.

Thanks,

Gordon

[former_member184146]

Hi Karthick ,

to retrieve the udf field value of OIGE table in OIGN table you need to put the reference no i.e OIGE.docnum  in OIGN udf .

so first create a udf at header level in OIGN table i.e. U_GINumber 

then make your put your FMS like below

select OIGE.U_IssPLayout from OIGE where OIGE.docnum=$[OIGN.U_GINumber ]

Hope it help you.

--Manish