Skip to Content
0
Sep 18, 2020 at 09:03 AM

Outgoing Payment Query Updation

38 Views

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]