Supplier Age Analysis – Transactions
A transaction appears on the age analysis once its header status is an accounting status (a status with the accounting checkbox checked).
Supplier Age Analysis – Transactions shows more information than the Supplier Age Analysis and helps you identify the specific outstanding transactions if allocations are used. However, the date columns go up to 150+ days only.
Buttons Explained
| Button | Description |
|---|---|
| View | Shows the entries that match the selected filters. |
| Arrow on View Button | Reset Data Filter: Resets all the data filters. |
| Menu | Views
Settings |
Filters Explained
| Filter | Description |
|---|---|
| Set | Select a date option from the dropdown list:
|
| Navigational Arrows | Adjusts the date in the direction of the arrow. |
| Date … to … | Set your own dates (depending on the selection under Set). The To date defaults to today. |
| Supplier | Select a supplier from the dropdown list. If none is selected, the message “Please select a Supplier.” appears when you click View (button). |
| Entity | Select All or a specific entity from the dropdown list. |
| Totals | Select Debit or Credit to show only records with that balance, or All to show every record. |
| Local Currency | Checkbox. If checked, converts all the values to the local currency. |
| Outstanding | Checkbox. If checked, only outstanding transactions appear. |
Fields Explained
The duplicate columns Trans, No. and Trans No. are provided for grouping and filtering.
| Field | Description |
|---|---|
| ID | The system-generated number for the entry. |
| Status | The transaction’s status. |
| Trans | The Transaction Type’s code. |
| No. | The transaction’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 five months, calculated from the To date. |
| 150 days | Transactions that are between four and five months old, calculated from the To date. |
| 120 days | Transactions that are between three and four months old, calculated from the To date. |
| 90 days | Transactions that are between two and three months old, calculated from the To date. |
| 60 days | Transactions that are between one and two months old, calculated from the To date. |
| 30 days | Transactions that are older than one 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 payments that were not allocated to invoices, such as deposit payments). |
| Allocated | Transactions that are fully allocated. |
| Total | The total amount on the transaction. |
 | A context menu (also opened by right-clicking the entry) with the following options:
|
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. 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 | Fully allocated transactions. If the Outstanding filter checkbox is checked, these transactions are hidden. |
| Total | A running total of all the transactions. |