Purchase Ledger Help
Use the Payment Forecast Report command to produce a report showing the value of invoices due for payment by a future date. The report helps you to forecast the sums due for payment by a certain date. The way in which the application calculates the expected payment dates based on one of three options. You can choose between due date of the invoices, the average creditor days calculated for individual supplier accounts, or the company creditor days which is calculated overall for all suppliers.
To save this report as a Microsoft Excel spreadsheet, select Excel Report from the Report Layout box on the Publisher form.
Account and company creditor days are only available after three periods of transaction history exist (determined by running the period end procedure for the Purchase module).