Skip to Content
Former Member
Dec 12, 2011 at 01:42 PM

Regarding FMS query to get the account name and get it in the report


Dear all,

I have created a FMS query to pick the G/L account name in the payment voucher,But the name which i got through the FMS in an UDF is not coming properly.It comes only if am manually entering Shift+F2 in that field.

Pls give me a suggestion for that.

The FMS query is.

SELECT T1.[AcctName] FROM VPM1 T0 INNER JOIN OACT T1 ON T0.CheckAct = T1.AcctCode INNER JOIN OVPM T2 ON T0.DocNum = T2.DocEntry WHERE T2.[DocNum] = $[ovpm.docnum]