I am trying to find a report which I can see all the incoming payments along with payments .I saw cash flow report and it doesn't meet my requirement .Payments are made by check and Bank transfer
Does any one has created this kind of query or report ?
Thank you in advance
Gordon Du replied
You can try this query if you have 2005 version. For 2007, try to match the JE table you have:
Select T1.RefDate, T1.TransID, T4.CardCode, T4.CardName, T2.DocNum 'Incomming#', T0.Credit, T3.DocEntry, T3.SumApplied from JDT1 T0 Inner Join OJDT T1 ON T1.TransId = T0.TransId Left Join ORCT T2 ON T2.TransId = T1.TransId Left Join RCT2 T3 ON T3.Docnum = T2.DocEntry Inner Join OCRD T4 on T4.CardCode = T0.ShortName where T1.TransType = '24' and T1.RefDate > '[%0]' and T0.Credit > 0
Please note: If you have reversed some payment, you would better have a separate report.