Outgoing Payment Query Updation

[former_member593234]

Hi All,

I want to add payment means field (Cash/Check/Bank Transfer/Cr.Card) and Total Amount Received for the below query.

Please help.

SELECT T0."DocNum",T0."DocDate", T0."DocType", T0."CardCode", T0."CardName",T0."UserSign" FROM OVPM T0 WHERE T0."DocDate" BETWEEN [%0] AND [%1]

[msundararaja_perumal · Accepted solution]

Hello,

You can add the fields CheckSum, CashSum, TrsfrSum, CreditSum from OVPM table. For Cheque, Cash, Bank Transfer, Credit Card

Thanks.

[former_member593234 · Accepted solution]

but it's not working.

SELECT T0."DocNum",T0."DocDate", T0."DocType", T0."CardCode", T0."CardName",T0."UserSign",T1."CheckSum", T1."CashSum", T1."TrsfrSum", T1."CreditSum" FROM OVPM T0 WHERE T0."DocDate" BETWEEN [%0] AND [%1]

This is correct??

[msundararaja_perumal · Accepted solution]

athulkm123 , Change all the T1 to T0, then it will work, thanks.

[former_member593234 · Accepted solution]

Thank You