FMS for balance due of the vendor in the UDF

[Former Member]

Hi Experts,

I have created a UDF at title level in the AP Invoices.i want  the debit balance due total in this field .

i tried below fms, could anyone check it?

SELECT sum(T1.[BalDueDeb]) FROM OJDT T0 INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId INNER JOIN OPCH T2 ON T0.TransId = T2.TransId WHERE T0.[TransType] =46 and T2.[CardType] ='S' and  T1.[shortname] =$[OPCH.cardcode]

thanks in advance,

Regards,

Dwarak

[Former Member · Accepted solution]

Hi!

Try this.

SELECT SUM(T1.[BalDueDeb]) FROM JDT1 T1 

WHERE T1.[TransType] = 46 and T1.[ShortName] = $[OPCH.CardCode]

Hope helps!

Regards,

[Former Member]

Hi Dwarakanath,

Try:

SELECT sum(T1.[BalDueDeb]) FROM OJDT T0 INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId  WHERE T1.[shortname] =$[OPCH.cardcode]

Thanks,

Gordon

[kothandaraman_nagarajan]

Hi,

Do you want display vendor balance at AP invoice?

Thanks & Regards,

Nagarajan