Supplier Age Analysis and Ledger Tutorials

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 Example: Main Menu > Accounting > Supplier Age Analysis

These tutorials explain how to display a Supplier Age Analysis and use the context menu functions.

---

How to Display a Supplier Age Analysis

• The Local Currency checkbox converts all amounts to local currency. With this option, accounts in foreign currency might show outstanding balances because of currency conversions.
• An Entity filter is only displayed if there is more than one registered entity.

1. Navigate to the Supplier Age Analysis.
   • Note: The navigation depends on where the age analysis is added on your menu.
2. Select the date for which you want to view the age analysis in the To date field. This date defaults to today.
3. Select an Entity from the dropdown list or select All if applicable.
4. Click the Show All checkbox to show accounts with zero balances (optional).
5. Click the Local Currency checkbox to convert all outstanding amounts to the local currency (optional).
6. Click View (button). 

---

How to Print, Preview or Email Remittance Advices

1. Navigate to the Supplier Age Analysis.
2. Select the date from which transactions should be included in the first date field.
3. Select the date for on which the transactions should end in the To date field.
4. Select an Entity from the dropdown list (only applicable if there is more than one registered entity).
5. Click View (button).
6. Click the entry you want the remittance advice for.
7. Click Output (button) and select one of these options:
   1. Print > Remittance Advice: The remittance advice is printed to your default printer. If your default printer is a PDF printer, you are prompted to type a file name.
   2. Preview > Remittance Advice: The remittance advice is displayed on screen from where you can save or print it.
   3. Email > Remittance Advice: The remittance advice is attached to an email in .pdf format and placed in your outbox from where you view and send it.
      • Note: If Remittance Advice is the only template added, only the options to Print, Preview, and Email are displayed.

---

How to Display a Supplier Ledger

1. Navigate to the Supplier Age Analysis.
2. Click Menu (button) > Detailed Ledger.
3. Set any of the filters (e.g. Date, Entity, or Supplier).
4. Click View (button). 

---

How to Add Work in Progress to the Supplier Age Analysis

• You can add work-in-progress transactions to the age analysis to check if you will exceed your credit limit.
• You need Setup access for Transaction Types to enable this feature.

1. Navigate to Transaction Types setup (e.g. Main Menu > Setup > Transaction Types).
2. Double-click the Transaction Type you want to add (e.g. Purchase Orders).
   • Note: Do not add this setting to transactions that appear on the age analysis (e.g. invoices, debit notes) because they will be counted twice.
3. Click Edit (button) on the top row.
4. Click Settings (tab) (it should be open by default).
   1. Click Settings (button) next to Add.
   2. Click the setting: Accounting > Sum Active Transactions to Work in Progress in Supplier Age Analysis.
      • Note: If the setting is not on the list, it has already been added. In this case, proceed with Step 5
   3. Click Add/Update (button).
   4. Confirm the update.
   5. Close the settings popup.
5. Navigate to the setting: Accounting > Sum Active Transactions to Work in Progress in Supplier Age Analysis and check the checkbox in the Value column.
6. Click Save (button). 

---