Need Ap invoice owner name on JE ref 3 field

[vinayak_chavan]

Need AP Invoice owner name on JE ref 3 field.

thx in advance.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Already replied to you...please check your previous post.

[vinayak_chavan · Accepted solution]

not working refrence field link not working

[kothandaraman_nagarajan · Accepted solution]

How did you assign the FMS for Ref 3 field?

[vinayak_chavan · Accepted solution]

i have used fms but asking for updation everytime on JE, i need to display automatically in JE ref3

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please assgin FMS  as per below screen shot:

[vinayak_chavan · Accepted solution]

DECLARE @DOCNUM AS INT
SET @DOCNUM=(SELECT $[OJDT.NUMBER.INT])

SELECT DISTINCT T2.[lastName]+' '+T2.[firstName] AS 'NAME' FROM OJDT T0  INNER JOIN OPCH T1 ON T0.TransId = T1.TransId INNER JOIN OHEM T2 ON T1.OwnerCode = T2.empID WHERE @DOCNUM= T1.[DocNum]

it gives me a owner name but asking update on JE. and that i dont want

[vinayak_chavan · Accepted solution]

pls give your query to get owner name

[kothandaraman_nagarajan · Accepted solution]

SELECT T1.[U_NAME] FROM OPCH T0  INNER JOIN OUSR T1 ON T0.UserSign = T1.USERID WHERE T0.[DocNum] =

$[OJDT.Baseref.0]

[vinayak_chavan · Accepted solution]

Nagan Raja

any leads,

it gives error  incorrect syntax near $[OJDT.Baseref.0]

[kothandaraman_nagarajan · Accepted solution]

Hi,

Save above query in query manager. then assign this query in ref 3 field..

If you run without opening journal entry, it will give error message like above.

[vinayak_chavan · Accepted solution]

yes dear

i have applied same but while applying query to ref2 by open save query it shows error .incorrect syntax near $[OJDT.Baseref.0]

not taking query...

[kothandaraman_nagarajan · Accepted solution]

Try this:

SELECT T1.[U_NAME] FROM OPCH T0  INNER JOIN OUSR T1 ON T0.UserSign = T1.USERID WHERE T0.[DocNum] =$[OJDT.Baseref.0]

Please refer below screen shot above query result:

[KennedyT21 · Accepted solution]

Hi VINAYAK CHAVAN ..

If you write Fms In journal also you required to update manually as the journal is posted automatic ...

If you want the owner code information in the journal level try this try to save the owner code in the journal remarks  which will automatically post in journal while you post ap invoice..

Try with FMS query and auto refresh with doc total field...

DECLARE @DOCNUM AS INT
SET @DOCNUM=(SELECT $[OPCH.DocNum.INT])

SELECT DISTINCT T2.[lastName]+' '+T2.[firstName] AS 'NAME' FROM OJDT T0  INNER JOIN OPCH T1 ON T0.TransId = T1.TransId INNER JOIN OHEM T2 ON T1.OwnerCode = T2.empID WHERE @DOCNUM= T1.[DocNum]

Hope Helpful

Regards

Kennedy

[kothandaraman_nagarajan]

Hi,

If you got the answer, please close the thread by marking correct/helpful answer.

Thanks & Regards,

Nagarajan