In the case of debtor (customer / client) accounts, debit transactions are processed in the sales batch or invoices (document entry). 

Once these debit transactions is updated (posted) to the ledger, and credit transactions are processed in the receipts batch, or credit notes in document entry) these credit transactions may be linked to the debit transactions.  

Once these debit transactions is linked to a credit transaction, only the outstanding transactions (unlinked) outstanding transactions should be listed.  

If all the transactions are not linked, it will be indicated on the Totals tab in a red or orange colour. This will help you to identify those accounts which may need open item processing.   

  1. Show colours - If this field is selected, this will show red or orange colours for those accounts and transactions, which have unlinked transactions. 
  2. Find invalid - Select (tick) and click on the Filter button to list those accounts and transactions, which have unlinked transactions. 

It is important to check that all batches and documents are updated to the ledger and that all transactions are linked, before sending out debtor statements. The Unposted batches tab of Open item link will only display the linked transactions which is already linked but not yet posted (updated) to the ledger. 

There may also be unposted documents and batches, which need to be linked, once these transactions and documents are posted (updated) to the ledger.  To view these, select in  Input →  Checking for unposted items on the Default ribbon).

Open item / Ageing reports for debtor (customer / client) accounts

In addition to the Age analysis icon on the Reports ribbon; or the Due tab of Open item link icon on the Default ribbon; the following reports is available to manage open item debtor (customer / client) accounts: 

Reports menu 

Transaction reports -

  • Transaction list - Open item - This report lists only those outstanding transactions in documents and batches which are posted (updated) to the ledger. It will list only those transactions with outstanding amounts. Any debit amounts, which are not linked to credit transactions, should be processed in Open item link (Default ribbon).
  • Transaction list - This report lists all the transactions in documents and batches which are posted (updated) to the ledger. All transactions will be listed irrespective of open item links.

Debtor statements - 

User reports menu 

Age analysis reports -

  • Age analysis - Balances detail - Displays the reference, date, amount and description for each transaction. The Total outstanding as at the Date of ageing is split to the number of days specified in up to 3 periods. 
  • Age analysis - Balances detail (open item) - This is similar to the "Balances detail" report, but it displays the outstanding amount and TransactionID.
  • Age analysis - Balances - This is a similar report as the "Balances detail" report. It will only list the balances for each ageing period.

To launch the Open item link screen for a debtor account:

Documents list screen - context menu - Others → Open item link option. 

On Default ribbon, select Documents (Documents list screen), select the Document type, e.g. Invoices, Credit notes or Quotes.

Right-click on a selected document. On the context menu, select the Others → Open item link option. 

This will launch the "Open item link" form for the debtor (customer / client) account;; associated with the selected document.
  1. Go to Open item link (Default ribbon). 
  2. On the list of accounts in the Totals or the Transactions tab, select the debtor (customer / client) account and double-click. 
  3. The "Open item link" screen for a selected debtor (customer / client) account is launched.  

If the transaction for Credit note CR000003 is not linked to Invoice IN000020, both Credit note CR000003 and Invoice IN000020, will be listed on the "Transaction list - Open item" report as well as the "Debtor statement - Outstanding".

You may need to process the links on the Open item link (Default ribbon).
  1. All the outstanding transactions which are not linked (matched), while processing transactions in batches and documents, will be listed.  Once all transactions for an open item debtor account, is correctly linked and processed, there should be no transactions in the "Credit" section of the screen:


Transactions tab - This list the posted transactions similar to the "Open item link" screen.

  • All not selected - This is the default option. Only those with outstanding amounts will be listed.
  • All option selected - All transactions will be listed. Those transactions, which are fully linked or settled, will display an 0.00 amount in the "Outstanding" column.


 Open item - processing options and filter options

See - Open item processing - Selected accounts.