The Supplier Age Analysis provides an overview of amounts that are outstanding to Suppliers and can be viewed at the current date or as at any prior date. It provides a time-based analysis with reference to due date to determine either how much time is left until due date or how much time has passed since due date.

A Supplier Statement can also be printed from this module.

Discover Supplier Age Analysis

• Get Started
• Supplier Age Analysis Interface

Get Started

The Supplier Age Analysis module is a fixed module that needs to be added to the Main Menu or/and to the Tile menu using Main Menu > Setup > Menu Manager.

User Access needs to be granted in Main Menu > Setup > Settings > Users > Accounting > Supplier Age Analysis - Access Allowed.

Supplier Age Analysis Interface

Navigation

Main Menu > Accounting > Supplier Age Analysis > View

1. Set / Date - This field allows you to filter the records displayed in the data grid by date.
2. Periods - If checked, the date filter searches on the Period Date. By default this is unchecked.
3. All Accounts - If checked, this will display all active Accounts in the database. If not, only accounts with amounts outstanding/owing will display.
4. Use Allocations - If checked, the ageing is calculated based on how receipts and credits were allocated to Invoices. If unchecked, the calculation is based on allocating receipts and credits to the oldest outstanding Invoices.
5. Data Grid - This shows the Customer Age Analysis information. The following fields are explained below:
   • Account - This is the Supplier name.
   • Credit Limit - This shows what Credit Limit, if any, has been extended to the Customer. The field will show red when the Credit Limit is exceeded, and will issue a warning in the Sales Order module should the Customer wish to place more orders.
   • Overdrawn - This shows by how much the Credit Limit has been exceeded.
   • W.I.P - This shows the value of work that is in production for the client.
   • Total + WIP - This shows the total outstanding amount plus work in progress.
   • 120 days - Current - This displays outstanding invoices based on their ageing.
   • Unallocated - This shows receipts or credits that have not been allocated to invoices.
   • Total - This shows the total outstanding amount per account.
6. The following functionality becomes available when right-clicking on a record.
   • Open Supplier - This will open the selected Supplier's Setups.
   • View Supplier Summary - This will open the Supplier Summary side-panel.
   • View Detailed Ledger - This will open the Detailed Ledger of the selected Account.
7. Menu - Functionality is included to Reset Data Filter, Export, Save and Restore the data grid.