The Transactions tab will list all transactions for each open item account. It will also list the outstanding amount (due amount) for each transaction. 

Open item link - Transactions tab - All transactions 

All transactions, including those accounts, which are linked (matched) and does not have any outstanding (due) amounts, will be listed.   

If a transaction is partially settled, or credit notes / supplier returns is not posted (updated to the ledger), it will list the outstanding amount (due amount) for that transaction.

open-item-transactions-tab

Open item link - Transactions tab - Open transactions only 

Only the transactions with outstanding (due) amounts will be listed.  

All transactions which are linked (matched) and does not have any outstanding (due) amounts will not be listed.   

open-item-link-transactions-tab-open-only

Open item link - Transactions tab - Columns

The columns is as follows:

1.Account - Account code. 

2.Description - Account name or account description.

3.Reference - The reference as entered in the "Reference" column for each transaction in "Batch entry" screens. In the case of Documents, the document number will be listed.

4.Batch entry - The description as entered in the "Description" column for each transaction in "Batch entry" screens. In the case of Documents, the document type and reference as entered in the "Your reference" field of the document header section of the "Document entry" screen will be listed.

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

6.Due - The due amount lists the total of outstanding for transactions, which is not matched linked. If the totals in the "Transaction total" and "Due" 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). 

7.Due date -  The Due date is the number of days added to the actual date of the transaction. The number of days is on the Accounting information tab of debtor (customer / client) accounts and on the Accounting information tab of creditor (supplier / vendor) accounts.

8.Date - The actual date of the transaction in documents and batches.

9.Account type - Ledger (General ledger accounts, Bank accounts and Tax accounts), Debtors or Creditors.

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

tip

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

Open item link - Transactions tab - Filter options

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.Open transactions only - By default, this option is not selected and will list all transactions, including those with a 0.00 balance. If this field is ticked, it will list only those transactions with a value of more than 0.00 in the "Due" column. 

tip

The Transactions tab of a selected debtor (customer / client) account, will by default, only list the  transactions with outstanding amounts. You may select the "All" option to view all the transactions, including those linked (matched) transactions.   

The Transactions tab of a selected creditor (supplier / vendor) account, will by default, only list the  transactions with outstanding amounts. You may select the "All" option to view all the transactions, including those linked (matched) transactions.   

4.group - Click on the group button to group the transactions on the list by "Month, From today, By date" and "By year".

tip

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

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