Checking Supplier Balances

There are ways to easily check supplier balances.

Select relationships from the navigation menu

Select cards
On the tool bar above the cards list view select the view "supplier balances" as at the current date.
On the tool bar above the cards list view select the arrow below the "Export" button and click xlsx. You will have an excel spreadsheet showing all supplier balances.

Select reports from the navigation menu

Select "Form Reports"
On the Form reports list there are category headings. Find the category heading "Relationships" or just search for the report in the name description
Click on the report "F-019 Supplier Trial Balance Summary"
On the detail view to the right of the report list click on "Show Report Using Parameters"
Enter the Date
Leave the start and end suppliers blank if you wish to report on all suppliers or select a supplier cardid
Click on OK
Report will appear to screen.
The total on the report must line up to the General Ledger Trade creditors account as at the same date.

Log onto Financials>General Ledger>Accounts>List View
Click on and highlight the general ledger account for trade creditors eg 31005
In the top ribbon is a action button called 'Set Period Range'
Set the period range to be the same period as the end date of either the report or list view
In the detail area on the tab of Status, the Actual closing balance should equal the total on the supplier trial balance summary report and/or list view of the supplier open items.