Supplier Detailed Ledger
The Supplier Age Analysis (CAA), 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.
Credit limits are shown on the age analysis and there is a setting to allow Work in Progress to be shown.
A transaction appears on the age analysis once the Header Status is in an accounting status (the accounting checkbox is checked for that status).
Navigation: Main Menu > Accounting > Supplier Age Analysis
Buttons Explained
| Button | Description |
|---|---|
| View | Generates a list of entries as per the selected data filters. |
| Arrow on View Button | Arrow on View Button > Reset Data Filter. |
| Output | Prints, previews or emails reports if Output Templates are created. Supplier Remittance Advices are normally one of the templates and are emailed from this interface. Lists the same options that are available under Supplier Age Analysis. |
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 forwards or backwards. |
| Date … to … | Allows users to set their own Dates (based on the selection under Set). |
| Entity | A dropdown list of Entities to select All or a specific Entity. |
| Local Currency | Checkbox. If checked converts all the values to local currency. |
Fields Explained
| Field | Description |
|---|---|
| Field Chooser (*) | Allows users to add or remove columns. |
| TransID | The system-generated number for the transaction. |
| Status | The Status of the transaction. |
| Trans | The transaction type’s code (e.g. SI for Supplier Invoice). |
| No. | The transaction number. |
| Date | The date of the transaction. |
| Reference | The reference entered on the transaction. |
| Currency | The currency in which the transaction is. |
| Debit | The amount that was debited for the specific line item. |
| Credit | The amount that was credited for the specific line item. |
| Balance | The running total (balance) on the account. |
| Widget | A submenu that can be accessed by right clicking the line: – Open Transaction: Opens the original transaction. |
Footer Explained
| Field | Description |
|---|---|
| Opening | The opening balance at the start of the selected period. |
| Movement | The movement during the selected period. |
| Closing | The closing balance at the end of the selected period. |
