Skip to Content
Jan 03, 2014 at 01:48 AM

Bank Deposit


Hi All

Please help if you know how to enhance this Query to show Bank Deposits of Incoming Payments with Credit Cards and Cash Payment Means.

SELECT T0.[DocNum], T0.[DocDate], T0.[CheckSum], T2.[DocNum], T2.[CardCode], T2.[CardName], T4.[DeposNum], T4.[DeposDate] FROM ORCT T0 INNER JOIN RCT2 T1 ON T0.DocEntry = T1.DocNum left join OINV T2 on t2.docentry = t1.docentry INNER JOIN OCHH T3 ON T0.DocEntry = T3.RcptNum INNER JOIN ODPS T4 ON T3.DpstAbs = T4.DeposId WHERE T0.[DocDate] between [%0] and [%1]

Kedalene Chong