Navigation:  Banking > Creditors Payment >

SETTLEMENT INQUIRY

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

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:

 

hmtoggle_plus0Supplier

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

 

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

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

hmtoggle_plus0Transactions From

This field defaults to today's date. Only bank transactions that occurred after or on the specified date will be displayed.

hmtoggle_plus0Bank 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

hmtoggle_plus0Base Settlement Amount

This field displays the total settlement amount in the base currency for the selected invoice lines including the fluctuation amount.

hmtoggle_plus0Base Transaction Amount

This field displays the total bank transaction amount in the base currency for the selected invoice lines.

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

hmtoggle_plus0Direction

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

hmtoggle_plus0Foreign Settlement Amount

This field displays the total settlement amount in the foreign currency for the selected invoice lines including the fluctuation amount.

hmtoggle_plus0Foreign Transaction Amount

This field displays the total bank transaction amount in the foreign currency for the selected invoice lines.

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

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

hmtoggle_plus0Reverse

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

hmtoggle_plus0Settlement Amount

Displays the sum of all the settlement amounts selected in the list box.

hmtoggle_plus0Show

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.

 

hmtoggle_plus0Total

This field displays the total settlement amount in the base currency for the selected invoice lines excluding the fluctuation amount.

hmtoggle_plus0Total Settlement Amount

This is a summation of all the settlement amounts selected in the grid . This is a read only field.

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

hmtoggle_plus1Settlement records Listview

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.

 

hmtoggle_plus1Fluctuation Records Listiview

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.