Supplier Age Analysis – Transactions
The Supplier Age Analysis (SAA), also known as Creditors Age Analysis, is used by organisations to manage collections. The age analysis has columns that are divided into date ranges of current, 30, 60, 90, 120, and 180+ days. These date ranges are based on the calendar month and not necessarily the number of days in the month.
A transaction appears on the age analysis once the Header Status is in an accounting status (the accounting checkbox is checked for that status).
Supplier Age Analysis – Transactions displays more information than the Supplier Age Analysis and helps to identify the specific outstanding transactions if allocations are used. However, the date columns only go up to 150+ days.
Navigation Example: Main Menu > Accounting > Supplier Age Analysis > Menu (button) > Transactions
Buttons Explained
| Button | Description |
|---|---|
| View | Generates a list of entries as per the selected data filters. |
| Arrow on View Button | Reset Data Filter: Resets all the data filters. |
| Menu | Views – Age Analysis – Detailed Ledger – Transactions Settings – User Access Layout |
Filters Explained
| Filter | Description |
|---|---|
| Set | Allows users to select a date from the dropdown list (e.g. No Date, Today, This year). |
| Navigational Arrows | Adjusts the date in the direction of the arrow. |
| Date … to … | Allows users to set their own Dates (based on the selection under Set). The To date defaults to today. |
| Supplier | A dropdown list of suppliers to select one. |
| Entity | A dropdown list of Entities to select All or a specific Entity. |
| Totals | A dropdown list to only display record with Debit or Credit balances or to display All records. |
| Local Currency | Checkbox. If checked converts all the values to the local currency. |
| Outstanding | Checkbox. If checked only outstanding transactions are displayed. |
Fields Explained
The duplicate columns Trans, No. and Trans No. are provided to allow for various grouping and filtering options.
| Field | Description |
|---|---|
| ID | The system-generated number for the entry. |
| Status | The transaction’s status. |
| Trans | The transaction type’s code. |
| No. | The transaction type’s number. |
| Trans No. | The transaction type’s code and number. |
| Date | The transaction’s date. |
| Reference | The transaction’s reference. |
| Currency | The transaction’s currency. |
| Entity (Reg) | The Registered Entity that the transaction is allocated to. |
| Entity | The entity selected for the transaction which can be a registered entity, till, or branch. |
| 150+ days | Transactions that are older than 5 months calculated from the To date. |
| 150 days | Transactions that are between 4 and 5 months old calculated from the To date. |
| 120 days | Transactions that are between 3 and 4 months old calculated from the To date. |
| 90 days | Transactions that are between 2 and 3 months old calculated from the To date. |
| 60 days | Transactions that are between 1 and 2 months old calculated from the To date. |
| 30 days | Transactions that are older than 1 month calculated from the To date. |
| Current | Transactions that happened in the current month of the To date. |
| Outstanding | Transactions that are not allocated (e.g. unpaid invoices, or receipts that were not allocated to invoices like deposit payments). |
| Allocated | Transactions that are fully allocated. |
| Total | The total amount on the transaction. |
| Widget | A submenu that can also be accessed by right clicking the entry: – Open Transactions: Opens the actual transaction. |
Footer Explained
| Field | Description |
|---|---|
| 30-150+ day columns | The total of the transactions that appear in those columns. |
| Current | The total of transactions that are current. |
| Outstanding | The unallocated transactions. This is the amount that is owed to the supplier or if negative, that is owed by the supplier (e.g. an overpayment or deposit payment). |
| Allocated | Transactions that have been fully allocated. If the Outstanding filter checkbox is checked, these transactions are hidden. |
| Total | A running total of all the transactions. |