The Totals tab will list the transaction total and total outstanding total for each open item account. 



Accounts which contains unlinked (unmatched) transactions, will be listed in an orange font or row colour (if the "Show colours" option is selected).

Column headings

The columns is as follows:

1.Account - Account code. 

2.Description - Account name or account description.

3.Account type - Ledger (General ledger accounts, Bank accounts and Tax accounts), Debtors or Creditors. The account type values is as follows:

Account type:

1 - Debtor (customer / client) accounts (Open item account field selected (ticked) on the Accounting information tab in Debtors (Action ribbon).

2 - Creditor (supplier / vendor) accounts (Open item account field selected (ticked) on the Accounting information tab in Creditors (Action ribbon).

0 - General ledger (Open item account field set to Yes in Accounts (Action ribbon).

3 - Bank accounts (Open item account field set to Yes in Accounts (Action ribbon).

4 - Tax accounts (Open item account field set to Yes in Accounts (Action ribbon).

4.Transaction total - The total of the actual transactions in posted batches and documents.

5.Total outstanding - The outstanding total of outstanding transactions, which is not matched linked. If the totals in the "Transaction total" and "Total outstanding" columns matches;  or is displayed in the default system font, it means that all transactions are linked (matched).  In this example, the font colour of "ABC-Office-Supplies", is in an orange font colour. This indicates that there may be some transactions which is not linked (matched). 

You may also drag columns to the "Use your mouse to pull a column here to group on that column" row.  


Filter options:

1.Search by - Select any of the column headings and an operator (e.g. Like (default), =, <, >, <=, =>, or <> ) and enter a value. Click on the Filter button. Only those transactions matching your specified values will be listed. To clear the values, click on the Clear button.

2.Account type - Select (tick) or deselect (remove the tick) to list the accounts for the selected account type(s) (Ledger, Debtors or Creditors).

3.Show colours - If an account is in white or gray rows, the accounts have no outstanding or unlinked transactions. 

Accounts displayed in orange, indicates that there may be transactions which is not linked. These accounts may need some actions in the Open item link processing. 

4.Find invalid - Select (tick) and click on the Filter button to list those accounts and transactions which have incorrect links.

5.limitrows - Limit rows - 200 rows is the default number of rows or transactions to be listed. The number of rows may be specified (decreased or increased). 

6.Export - This button will allows you to save the file (matching your filter and search criteria).  

Export button - This will launch the "Save As" screen, on which you may select to save the export file as Text files (*.txt) (default file type); or as CSV files (*.csv) (Comma Separated Values) file type. This will automatically open (launch) the exported file in the program associated with the selected file type:

oText files e.g. (Export.txt) - This should automatically open the exported text file of your system's default text file program associated with Text file type (*.txt) file types (e.g. Notepad, etc). You need to close the exported text file and launch your spreadsheet program. In your spreadsheet program, Open the text file to launch the "Text Import" options.

oCSV files e.g. (Export.csv) - This should automatically open the "Text Import" options of your system's default spreadsheet program associated with Comma Separated Value file type (*.csv) file types (e.g. Microsoft Excel, Apache OpenOffice, LibreOffice, Ultra Office, etc.). 

Context menu

Right-click on a selected account on the list, to launch the context menu for the following processing options.