Navigation:  Banking > Bank Transaction >

Inquiry

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

The Transaction Inquiries tab is used to perform bank transaction inquiries.  The transaction direction can be specified as being "Into Bank" or "Out of Bank".  Other inquiry criteria such as the "Beneficiary" or "Received From" and the transaction "From" and "To" dates can also be selected as well as other more specific date criteria.  In "Out of Bank" mode, a transaction can be searched for by entering a cheque number, while in "Into Bank" mode, a transaction can be searched for by entering a receipt number.

 

The Transaction Results tab displays the bank transactions according to the criteria selected on the Transaction Inquiries tab. A selected bank transaction that is displayed in the "Inquiry Results" grid can conditionally be changed, reversed or reconciled with a bank statement via reference of the bank statement number and item.

 

hmtoggle_plus1Account

This field works in conjunction with the Employee, Organisation and Other Concern options where the mode is "Bank".

 

An account or accounts can be specified in the accounts grid.

It is populated with the account and description from the Accounts table where the Account Code application:

 

Bank To Account or

Account To Bank or

Bank To Employee or

Employee To Bank or

Bank To Organisation or

Organisation To Bank or

Bank To Other or

Other To Bank

 

is selected depending on the bank transaction "to" and "from" selection.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".

 

Journals referencing this account include the following:

 

Debtors Settlement Journal

Creditors Transfer Settlement Journal

hmtoggle_plus1Bank

When this option is selected, the drop down combo is populated with all the Banks from the Bank Internal table where the user has bank transaction access profiles linked to.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory for doing transactions).

hmtoggle_plus1Bank Statement

When the Bank Statement check box is checked, you can specify the bank statement number you wish to inquire on.  It is the bank statement number allocated by the Commercial Bank.

hmtoggle_plus1Bank Statement Dates

When the Bank statement Dates check box is checked you can specify the statement date from which you would like to view transactions as well as the statement date up to which you would like to view transactions.

 

When the Transaction Results tab is clicked, the grid is only populated with transactions between the specified dates.

hmtoggle_plus1Beneficiary

The beneficiary is the Employee, Account, Organisation, Bank or Other Concern receiving money from the bank.  When the transaction direction Into Bank is selected the caption changes to Received From .

 

EMPLOYEE

When the Employee option is selected, advance is not checked and the mode is "Bank", either an employee expense Requisition number or an Account number must be specified.

The drop down combo is populated with employees from the Employee Master table where the status is Active (A).

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

 

When the mode "Employee" is selected, an employee or account must be entered in the "Beneficiary" frame and a requisition number(s) or account(s) must be entered in the

accounts grid.

 

ACCOUNT

When "Account' is selected and mode is "Bank", you can specify only the account(s) in the accounts grid.  The combo box is populated with all active accounts the Accounts table where the application setting "Bank to Account" is set to '1' (yes) for the account code.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".  The bank will be debited and the selected account will be credited, or vice versa, depending on the direction of the arrow.

 

When "Account" is selected and the mode is "Employee", advance receipts can be acknowledged. You do not have to specify an account in the grid. This means the updating of the account/node on the employee expense requisition's  . If another account than the account/node on the employee expense need to be debited the 'allocate to other account' checkbox need to be checked to enable the account column in the grid. By selecting another account, that specific account will be debited with the amount transferred and it won't affect the actual value of the employee expense requisition.

 

The number of characters to be entered before the list is shown is governed by the value of populated length.

 

ORGANISATION

When "Organisation" is selected and the mode is "Bank", the combo box is populated with all organisations from the External Organisation table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".

 

The Organisation must be an External Organisation registered with your company i.e. as customer and/or supplier.  When "Organisation" is selected, the organisation's name, as well as an account(s) in the accounts grid must be specified, for example, trade debtors account,  This is used, for example: payment by debtors or payment for creditors.

 

BANK

When "Bank" is selected and the mode is "Bank", the combo box is populated with all banks from the Bank Internal table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".  This can be used to transfer money from your company's bank to an External bank, for example, Nedbank.

 

OTHER CONCERN

When in "Bank" mode and "Other Concern" is selected, a text box appears.  This text box together with the first line of "Other Concerns Address" field is mandatory.  Other Concern indicates organisations and persons not registered as an external organisation (supplier or customer) with your company.

 

When "Other Concern" is selected, both the names of the organisation, or person, and an account(s), must be entered.  This can be used when your company donates money to a charity organisation, sponsors a sports event, or pays the Receiver of Revenue.

 

GROUPING CODE

A Grouping code can be selected when processing bank transactions. The grouping code is populated from External Organisation Grouping Code function. The grouping code can be used for various reasons, one of them which maybe to extract related party transactions for IFRS purposes.  Grouping code can be allocated to all bank transactions.

hmtoggle_plus1Comments Like

If you want to inquire on bank transactions where you know part of the comments, you can enter the bit you know followed by a % as wildcard.

hmtoggle_plus1Effective Dates

When the Effective Dates check box is checked you can specify the effective date from which you would like to view transactions as well as the effective date up to which you would like to view transactions.

 

When the Transaction Results tab is clicked, the grid is only populated with transactions between the specified dates.

hmtoggle_plus1Grouping Code

If an entry is selected, only the bank transactions which have the same grouping code as selected will be shown.

This combo is populate from the External Organisation Grouping Code table.,

hmtoggle_plus1Include Employee Expense Transfer Transactions

By selecting this box the user will include all transactions where Employee Expense Transfers took place for the selected Transaction Dates.

hmtoggle_plus1Include To Bank Transactions

A new checkbox " Include to bank transactions" is added on the inquiry tab.

When inquiring on bank to bank transactions, and if this checkbox is checked then all bank transactions where the "from bank" (left hand bank selected on screen) exists as the "to Bank" will also be included in the results. These other transactions will also be applicable to any other criteria selected. e.g.

Transaction 1 - Transfer out of bank from Bank 01 to 02

Transaction 2 - Transfer out of bank from Bank 02 to 01

If the checkbox is unchecked and inquiring on bank 01 to bank 02 then only transaction 1 will display as results. If the checkbox is checked and inquiring on bank 01 to Bank 02 then transaction 1 and 2 will display.

hmtoggle_plus1Installation Generation Number

If an entry is selected, only bank transactions caused by the specific Electronic Funds Transfer run with this Installation Generation Number will be shown.  

hmtoggle_plus1Payment Method

When the Payment Method check box is checked, you can select the transaction, payment method type you wish to inquire on i.e.transfer cash, credit card or cheque type transactions.

 

When the Transaction Results tab is clicked, the Transaction Results grid will only populate with transactions for the selected payment method

hmtoggle_plus1Print Dates

When the Print Dates check box is checked you can specify the cheque/receipt print date from which you wish to view transactions. Depending on the transaction direction (into or out of) the results will either show cheque print date or receipt print dates.

 

When the Transaction Results tab is clicked, the grid is only populated with transactions falling between the specified dates.

hmtoggle_plus1Received From

The Beneficiary is an employee receiving money from an employee, account, organisation, bank, or other concern.

 

EMPLOYEE

When the Employee option is selected, the drop down combo is populated with employees from the Employee Master table where the status is Active (A).

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

 

ACCOUNT

When the Account option is selected the drop down combo is populated with all active accounts from the Accounts table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".

 

ORGANISATION

When the Organisation option is selected, the drop down combo is populated with organisations from the External Organisation table where the trading status is Active (A).

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".

 

The organisation must be an External Organisation (supplier and/or customer) registered with your company.

 

BANK

When the Bank option is selected, the combo box is populated with all banks from the Bank Internal table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".

 

OTHER CONCERN

When selected, a text box is displayed where the user can enter the name/address of the concern.  Other Concern indicates organisations and persons not registered as an external organisation with your company.

 

Examples of other concerns could be, "Company donating money to your company" or the "Receiver of Revenue".

hmtoggle_plus1Recon Dates

When the Recon Dates check box is checked you can specify the recon date from which you would like to view transactions as well as the recon date up to which you would like to view transactions.

 

When the Transaction Results tab is clicked, the grid is only populated with transactions between the specified dates.

hmtoggle_plus1Ref Number Like

If you want to inquire on bank transactions where you know part of the reference number, you can enter the bit you know followed by a % as wildcard.

hmtoggle_plus1Requisition

This field is enabled when the mode is "Employee".  When an employee is selected and Advance is checked, this field displays employee expense requisitions still available for the selected employee.  When doing a bank transaction between two employees,you cannot transfer from and to the same requisition.

 

It is populated with the requisition number and description from the Requisition and Employee expense Requisition tables where:

 

The employee selected is the indicated as the beneficiary on the cash advance requisition,

The direction is Out of Bank "O",

Advance is Yes "Y", and

The requisition status is Released "R" or In Process "I".

 

The number of characters to be entered before the list is shown is governed by the value of "populate length".

hmtoggle_plus1Sort By

By selecting one of the available options, the Transactions results will display the selected transactions sorted according to the selected option.

hmtoggle_plus1Transaction Cancel Dates

When the Transaction Cancel Dates check box is checked you can specify the transaction cancel date from which you would like to view transactions as well as the transaction cancel date

up to which you would like to view transactions.

 

When the Transaction Results tab is clicked, the grid is only populated with transactions between the dates specified.

hmtoggle_plus1Transaction Dates

When the Transaction Dates check box is checked you can specify the transaction date from which you wish to view transactions as well as the transaction date up to which you would like to view bank transactions.

 

When the Transaction Results tab is clicked, the grid is only populated with transactions falling between the specified dates.

hmtoggle_plus1User Generation Number

If an entry is selected, only the bank transactions caused by this specific User Generation Number of the Electronic Funds Transfer (EFT) run will be shown.  For an EFT, identified by a Installation Generation Number, there can be 1 or more User Generation Numbers.