Checking Supplier Balances

There are ways to easily check supplier balances.

Usually if you run a report or list view as at the end of a month or a start and end period you will be able to balance it back to the general ledger quite easily.
 

Easy Method : Use the cards view  

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.

Run a report :

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.

Opem Items List View:

• Click on Relationships>Open Items
• From the top filter select 'All supplier Open Items'
• Filter and select the criteria of the date range 
• Right click at the top heading and select 'Show Report Footer'
• Then sum the column of 'Value'
  
  

General Ledger

• 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.