When processing transactions in batches and documents, the Open item link for a specific debtor (customer / client) account, may be launched to link and allocate or match transactions specific transactions for open item debtor (customer / client) accounts. Some of these options, is as follows:

1.Batch entry - Select transactions on the "Open item selection" screen when processing credit transactions for debtor accounts and match them to debit transactions, in the Receipt batches, Credit notes, etc.

2.Batch entry - Select from Select from account open item list context menu option.

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

The Transaction amount and the Due amount is listed on the following screens:

1.Transactions tab of Open item link. 

2.Documents - Transaction total amount of the Document and the Due (Outstanding) amount.

3.Transactions tab of selected debtor (customer / client) accounts - If the "All" option is not selected - Only those transactions with outstanding amounts will be listed.

The following Transaction list reports on the Reports Debtors Transactions menu may help to manage open item links:

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

2.Transaction list - Open item - This report lists only those outstanding transactions in documents and batches which are posted (updated) to the ledger. Any credit amounts, which are not linked to debit transactions, should be processed in Open item link. Only the transactions with outstanding balances (e.g. partial settlement) or outstanding Invoices will be listed. Payments for these outstanding Invoices is still receivable. In some cases an Invoice may be disputed.  


When processing transactions in batches and documents, the transactions can be linked or allocated to specific transactions. 

You may need to edit these links in the Open item link on the Action ribbon.  

The open item link for a specific debtor (customer / client) account may be opened with a double-click from the Totals tab or the Transactions tab on Open item link.

Example : Open item link - Linked Debtor transactions

An example where all credit transactions were linked to debit transactions of a selected debtor (customer / client) account, is as follows: 

open-item-debtor-linked

Context menu

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

open-item-selected-account-context-menu

Filter options

 You may apply the following options to filter transactions:

open-item-selected-account-filter-options

Example : Open item link - Unlinked Debtor transactions

An example where no (or not all) credit transactions were linked to debit transactions of a selected debtor (customer / client) account, is as follows: 

open-item-debtor-unlinked

Example : Open item link - Debtor - Statement view

The "Open item link - Statement" option displays the transactions of the selected account (i.e. debtor (customer / client) account in a Statement view. 

open-item-debtor-link-statement

Context menu 

Right-click on a selected transaction on the list to "Unlink" selected transactions from the context menu. 

The following Debtor ageing reports is available: 

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. 

Balances detail history (open item) - This is similar to the Balances detail report, but it displays the outstanding amount and TransactionID.

The following Debtor statements are available: 

Debtor statements - The statement will print all transactions. It does not use the Open item link feature.

Debtor statements - Outstanding - The statement will print only the outstanding transactions. Transactions linked in the Open item link feature, will not be listed.

The credit transactions which are linked to specific debit transactions of the same value, will not be displayed. If a transaction of a different amount is linked to a specific transaction, only the outstanding amount (difference) will be listed.

For example, an payment of 2000.00 is received from the debtor (customer / client) on 2021/03/16. The payment is linked as follows:

INV003 - 2021/03/10 - 1150.00 is fully settled (linked to the payment of 2000.00) - 

IN000001 - 2021/03/13 - 1150.00 - The remaining balance of 850.00 is linked to IN000001 as a partial settlement of IN000001. An outstanding amount of 300.00 will be printed on some reports. This amount is calculated as 1150.00 minus the partial settlement of 850.00 = 300.00 as the outstanding amount.  

As per this example - 

Invoice INV003 will not be printed on some reports and in other reports it will print 0.00 as the outstanding amount.  

Invoice IN000001 will print on some reports as 300.00 as the outstanding amount.

The following Transaction list reports on the Reports Debtors Transactions menu may help to manage open item links:

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

2.Transaction list - Open item - This report lists only those outstanding transactions in documents and batches which are posted (updated) to the ledger. Any credit amounts, which are not linked to debit transactions, should be processed in Open item link. Only the transactions with outstanding balances (e.g. partial settlement) or outstanding Invoices will be listed. Payments for these outstanding Invoices is still receivable. In some cases an Invoice may be disputed.