I sometimes issue Post Dated Cheques to suppliers when I buy material from them. I keep a track of the cheques issued by mentioning the date of the cheque as due date on the Purchase invoices - so i know when to have sufficient funds available in my account.
My question is: - Is there a way we can have a report that I can click on everyday - that shows the cheques due in the next 7 days along with the dates…and also the cheques which have already crossed their due…sometimes Suppliers dont cash the collected cheques immediately, so i need to know this cheque is due, and may clear any time.
Currently, I do see all the purchase invoices Due, but I have to scroll down a full list… and its not in order of when payments are due… as you can see the screenshot
For example, if you see below - there is one payment due tomorrow for Opal Computers, bu it comes between two other payments due in 3 days… so theres a chance I may not notice this.
A report to see cheques (Purchase Invoices) due in next 7 ( or customizable) days would simply be magnificent. Please let me know if this is possible.