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

Bank Deposit

159 Views

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