Supplier Age Analysis and Ledger Tutorials

The Supplier Age Analysis, and when a transaction appears on it, are explained on Supplier Age Analysis and Remittance Advices.

💡These tutorials explain how to view the Supplier Age Analysis and supplier ledger, send remittance advices and add Work in Progress.

How to View a Supplier Age Analysis#

1. Navigate to the Supplier Age Analysis.
2. In the To date field, select the date for which you want to view the age analysis.
   • Note: This date defaults to today.
3. Select an entity from the dropdown list, or select All, if applicable.
4. Optional:
   • Check the Show All box to show accounts with zero balances.
   • Check the Local Currency box to convert all outstanding amounts to the local currency.
5. Click View (button).

How to Print, Preview or Email Remittance Advices#

1. Navigate to the Supplier Age Analysis.
2. In the first date field, select the date from which to include transactions.
3. In the To date field, select the date on which the transactions end.
4. Select an entity from the dropdown list (applies only if more than one entity is registered).
5. Click View (button).
6. Click the entries you want remittance advices for.
7. Click Output (button) and select one of these options:
   • Print > Remittance Advice: The remittance advice is printed to your default printer. If your default printer is a PDF printer, you are prompted to enter a file name.
   • Preview > Remittance Advice: The remittance advice appears on screen, where you can save or print it.
   • Email > Remittance Advice: The remittance advice is attached to an email in .pdf format, which opens so that you can check and send it.
     • Note: If Remittance Advice is the only template added, only the Print, Preview and Email options appear.

How to Email Remittance Advices to Several Suppliers#

1. Navigate to the Supplier Age Analysis.
2. In the To date field, select the date on which the transactions end.
3. Select an entity from the dropdown list (applies only if more than one entity is registered).
4. Click View (button).
5. Select the suppliers you want to send remittance advices to (Ctrl + left-click or Shift + left-click).
6. Click Output (button) and select Email > Remittance Advice.
   • Note: One email is created for each selected supplier, with the remittance advice attached as a PDF, and saved in the Outbox. The email edit window does not open.
7. Read the message, which shows how many emails were created and how many have no email address, and click OK (button).
   • Note: The Emails module opens on the Outbox.
8. Check the emails and fill in any missing email addresses.
9. Select the emails you want to send (Ctrl + left-click or Shift + left-click).
10. Click Send (button).
    • Note: With only one row selected, Send sends all the listed emails.

How to View a Supplier Ledger#

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

How to Add Work in Progress to the Supplier Age Analysis#

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 (that is, all transactions that post to the ledger), because they are counted twice.
3. Click Edit (button) on the top row.
4. Click Settings (tab) if it is not already open.
   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 is already added. In this case, go to Step 4e.
   3. Click Add/Update (button).
   4. Confirm the update.
   5. Close the settings popup.
5. Accounting > Sum Active Transactions to Work in Progress in Supplier Age Analysis = Check the box in the Value column.
6. Click Save (button).