Hi all, I have a customer who is looking for a report that shows how an incoming payment is applied wether it goes into past due or current status. For instance if a large payment is recieved which the report would show how it was spread out?
Suda Sampath replied
As you would understand the Forum members could only provide guidelines on how you can approach the scenario to get a solution.
For this question, We would like to see a report that will show by date the deposits posted to our cash accounts and how the deposit was broken out and applied to the invoices..............you could use the ODPS and OCHH table to create your own custom report
For this we would like a report that could forecast the amount of deposits to come in on a weekly basis based upon our aged a/r.....I don't think there is any way to project what you should expect............the cash flow report could tell you what you due dates for the Invoices and Payments are .................this is pretty much what you can get from the system