In this release, we have made many enhancements to the Operational Finance -> Creditor -> Enquiry – Creditors Ageing screen.
We have added the following fields (with data pulled from the Customer Masterfile):
- On Account
- Account Balance
- Last Payment Date
We have added new fields:
- Average Payment Days
- Calculated as the average number of days to full pay an invoice for the creditor for the current financial year
- Average Post Days
- Calculated as the average number of days to post an invoice for the creditor for the current financial year
We have added an Age By field to the Creditor Ageing group. When set to ‘Invoice Date’, the outstanding invoices for the creditor are aged by the invoice date, when set to ‘Invoice Due Date’, the outstanding invoices for the creditor are aged by the invoice due date.
We have added more ageing fields to the screen:
- Total Outstanding
- Total Within Terms
- Total Overdue
- 1 days +
- 7 days +
- 14 days +
- 30 days +
- 60 days +
- 90 days +
- 120 days +
We have also added a table to the bottom of the screen, that divides the outstanding invoices for the creditor by currency. The table includes the following average columns:
- Average Payment Days
- Calculated as the average number of days to full pay an invoice for the creditor for the current financial year in the line currency
- Average Payment Amount
- Calculated as the average payment amount for full paid invoices for the creditor for the current financial year in the line currency
And the following ageing columns:
- Total Outstanding
- Total Within Terms
- Total Overdue
- 1 days +
- 7 days +
- 14 days +
- 30 days +
- 60 days +
- 90 days +
- 120 days +
