All settled invoices settled with the selected bank transaction/credit link are displayed here. The Invoice Number, Line Number, Capture Date, Settlement Amount, Amount Outstanding, Type Of Link, Bank Code, Cheque Number, Bank Transaction Date, Settle Invoice Number, Settle Line Number, Settle Capture Date are displayed.
On this tab the following fields can be viewed:
![]() | Supplier |
It defaults to the selected Supplier. It is populated with the name, trading status and organisation code from the External Organisation table where a valid Creditors account exists.
The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory). |
![]() | Bank Code |
It populates with banks from the Bank Transaction Access table where the current login user has a profile of Bank To Organisation and a To Date greater than or equal to today's date. |
![]() | Transaction Supplier |
It defaults to the selected Supplier. It is populated with the name, trading status and organisation code from the External Organisation table where a valid Creditors account exists.
The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory). This is the bank transaction's beneficiary external organisation. |
![]() | Transactions From |
This field defaults to today's date. Only bank transactions that occurred after or on the specified date will be displayed. |
![]() | Bank Transaction |
It is populated with the transaction date time, (amount + tax amount), account, division code, account description, bank statement, bank statement item, and available amount calculated as the (amount + tax amount) - (the settlement amount) from the Bank Transaction Account, Account, Account Codes and Creditor Settlement tables where:
The status on the Account Codes table is Active "A", the transaction supplier is equal to the beneficiary on the bank transaction, the transaction date time is greater than or equal to the from date entered, and The cancel date is equal to spaces. The direction on the Bank Transaction table is Out of Bank "O" (when "Out of Bank" is selected), or the direction on the Bank Transaction table is Into Bank "I" (when "Into Bank" is selected).
The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).
RELATED TOPIC: Bank Transaction |
![]() | Base Settlement Amount |
This field displays the total settlement amount in the base currency for the selected invoice lines including the fluctuation amount. |
![]() | Base Transaction Amount |
This field displays the total bank transaction amount in the base currency for the selected invoice lines. |
![]() | Cheque Number |
If the method is "Cheque"for the selected bank transaction the cheque number will be displayed, else the field will be blank and disabled. |
![]() | Direction |
One of the Direction options, either "Into Bank" or "Out of Bank" must be selected.
These options govern the population of the "Bank Transaction" field. The default is "Out of Bank". |
![]() | Foreign Settlement Amount |
This field displays the total settlement amount in the foreign currency for the selected invoice lines including the fluctuation amount. |
![]() | Foreign Transaction Amount |
This field displays the total bank transaction amount in the foreign currency for the selected invoice lines. |
![]() | Invoice Number |
Displays all invoices for the selected supplier which were used for settlements as a source invoice number (Where invoices were used to settle other invoices)
Only active invoice line links where the type of link equals Credit "C" will be displayed. |
![]() | Reprint Remittance |
The "Print/Preview" button is only enabled when selecting a bank code or credit link and after displaying the invoices that have been settled with it.
When the "Remittance" button is clicked, and the "Print"/"Preview" option is selected, a list of the invoice lines settled by the relevant bank transaction/credit link can be printed or previewed.
If no default printer is set, the Print Library User Defaults function will open. Set a printer and the number of copies before clicking "Remittance" again. |
![]() | Reverse |
The "Reverse" button is enabled when invoices are selected in the list box. When clicked, the settled invoice line links are unsettled.
Reverse journal(s) will be written and the available amount of the Bank Transaction will be updated.
When reversing an invoice settlement, a new record with the date settled as today's date and the amount as negative is entered in the Creditor Settlement table |
![]() | Settlement Amount |
Displays the sum of all the settlement amounts selected in the list box. |
![]() | Show |
The "Show" button is enabled when a supplier and bank transaction/credit link details have been selected.
When this button is clicked, all the invoices settled with the bank transaction/credit link will be displayed in the list box. |
![]() | Total |
This field displays the total settlement amount in the base currency for the selected invoice lines excluding the fluctuation amount. |
![]() | Total Settlement Amount |
This is a summation of all the settlement amounts selected in the grid . This is a read only field. |
![]() | Total Base Fluctuation Amount |
This field displays the total fluctuation amount in the base currency for the selected invoice lines. This amount is calculated as the difference between the original invoice and the current exchange rate selected or changed. |
When clicking the show button - this listview will show all invoice records as per settlement criteria. If the records are selected it can also be reversed by clicking on the REVERSE button. |
Ths istview will show if there were any fluctuation settlement records for the settled invoices. If a records is reversed then the system will ensure that the fluctuation records are also reversed. |