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.
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 |
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). |
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. |
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. |
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. |
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. |
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. |
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., |
By selecting this box the user will include all transactions where Employee Expense Transfers took place for the selected Transaction Dates. |
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. |
If an entry is selected, only bank transactions caused by the specific Electronic Funds Transfer run with this Installation Generation Number will be shown. |
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 |
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. |
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". |
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. |
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. |
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". |
By selecting one of the available options, the Transactions results will display the selected transactions sorted according to the selected option. |
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. |
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. |
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. |