Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Incoming payments

Hi

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

Bishal

Former Member replied

HI Bishal,

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.

Thanks,

Gordon

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question