FS query help !

[Former Member]

Hi,

I had create a UDF (TEST03) in VPM2 (Outgoing Payments Row).

The query in TEST03 is as below:

SELECT OJDT.Ref3 from OJDT where OJDT.TransID = $[VPM2.DocEntry]

However, it will not bring the value that I key in in JE entry.

Can anyone help?

Thanks

[former_member212181 · Accepted solution]

HI Olga,

Please try below query and give your feedback.

SELECT OJDT.Ref3 from OJDT where OJDT.TransType = $[VPM2.InvType] and OJDT.TransID = $[VPM2.DocTransId]

Thanks

Unnikrishnan

[Former Member · Accepted solution]

Hi,

It doesn't work on my side.

Is it working on your side?

Thanks

[former_member212181 · Accepted solution]

Sorry,

I didn't tested that one.

Please try below one.

Its perfectly working in my system

SELECT T0.[Ref3]

FROM OJDT T0

WHERE T0.[TransType] = $[$20.45.Number]

and (T0.BaseRef = $[$20.1.Number] or T0.TransId =$[$20.1.Number] )

and  T0.[RefDate] =$[$20.21.Date]

All the best

Unnikrishnan

[Former Member · Accepted solution]

Hi,

Thank you, it works this time.

Really appreciate your help. ^^

Thanks

[Former Member]

Hello,

Try this,

SELECT OJDT.Ref3 from OJDT where OJDT.TransID = $[VPM2.DocTransId]

may be this will workout for you.

Thanks,

Harshal

[Former Member]

Hi,

It doesn't work on my side.

Is it working on your side?

Thanks

[kothandaraman_nagarajan]

Hi,

Because OJDT transid is not equal to VPM2 docentry. Try to find correct field to relate those tables.

Thanks.