Overview

Supplier trial balance (summary) provides you with details on what each of your suppliers owe you, showing current, 30 days, 60 days, 90 days, 120 day and the overall total. 

Image of report result

Running the report

1. In the Navigation panel, go to Reports then Form Reports.
2. In the list of reports find the category Cards and then select Supplier Trial Balance (Summary)

3. Select a parameter some options may be as per image

    Show me

   

4. Select the parameter 

5. Click on Show Report Using Parameters, screen as per below will appear

    Show me

   

6. Enter the date that your require. 
7. Start Supplier and End Supplier fields
   1. If you require all Suppliers leave both fields blank
   2. If you require 1 Supplier key in same Supplier id into both fields
   3. If you require specific range of Suppliers based on Supplier id enter start Supplier and end Supplier for that range. 
8. Click OK and report runs
9. Result appears as above image.

Use Case

Its end of month and your accounts staff want to check the accounts that are overdue by 60 days or more, run the above report for these results and highlight the ones you want chased up.