View and Generate Vendor Ageing Reports

Viewing and generating vendor ageing reports in SapphireOne is vital for monitoring outstanding payables and managing overdue accounts. This process ensures that all ageing reports are accurately generated and utilised for effective payables management. The process is as follows:

  1. Navigate to Accounts > Payables > Report and select the Balances item. SapphireOne will display the Vendor Balances Reports print dialogue alert. From this print alert, the user may make the following selections:
    • Share Destination menu – Select one of the following options as required: Printer, Custom Report, Quick Report, or CSV. If CSV is selected, the default spreadsheet application on your operating platform will open automatically.
    • Report Type menu – This drop-down menu contains a wide range of report types, from Standard Balances through to FX Balances. Select the Report Type that best suits your requirements.
    • Report Sort Order – Use this menu to define how the report will be sorted. Options range from by ID to by Department, with a total of 13 sorting options currently available.
    • Report Selection – This is a very important item when making your selections. For the options listed under this menu there are a total of three drop down menus where the user can select from a single Vendor, through to a group of Vendors as required. A number of other options are included in these drop down menus as well.
  2. Checking – Review and verify each selection made from the drop-down menus above to ensure the report is configured correctly.
  3. Report Generation – Click the Process button to generate the report. Depending on the selected Share Destination option selected, SapphireOne will either display your operating platform’s print dialogue or launch the spreadsheet application with the requested data.
  4. Record List – Optionally, click the Record List button to view the Vendor Aged Balance Report immediately on screen.

The Custom Report and Quick Report print destination options provide advanced reporting capabilities that will be implemented in consultation with SapphireOne.

For more detailed guidance, refer to the Accounts > Payables > Balances Report, article.

Was this helpful?