...
...
| Table of Contents | ||
|---|---|---|
|
Principles
Using bank accounts in Business Central is used to keep track of your banking transactions. Accounts can be denominated in local currency or foreign currency. The set currency on the bank account cannot be changed after the first transaction has been posted!
...
The numbering of bank account cards depends on the setting in the General Ledger Setup table in the Bank Account Numbering field.
MS regularly updates the documentation for this setting area. Documentation valid for BC22 is available at the following link:
...
There is no description of the settings for SEPA payments.
Dependencies and assumptions
The numbering of bank account cards depends on the setting in the General Ledger Setup table in the Bank Account Numbering field.
Description of the documented area
Bank Account Setup
A bank account can be opened in the overview Banks or in the overview Bank Accounts using the New button. After pressing the New button, a new Bank Account Card will be created, in which it is necessary to set up some fields for the correct posting of bank transactions and the creation of bank orders and bank statements.
IB Card Setup – General Tab
Description of field settings:
No. field
is created based on the number sequence setup that is set up in the General Ledger Setup table. The number sequence can be set as automatic numbering of new cards or it can be set for manual number entry according to your own logic.
Name field
A text description of the bank account according to your own requirements.
Bank Account No. field
Set up a bank account number, including a bank code.
Field Closed
If you close your bank account, you can also close your bank account card so that it can no longer be charged.
Disable Automatic Payment Matching field
Specifies whether automatic payment matching should be disabled for this bank account after bank transactions are imported.
Match Tolerance Type field
Specifies the tolerance with which the automatic payment application function will apply the Matched Amount Incl. Tolerance field to this bank account. The Amount option is set.
Match Tolerance Value field
Specifies whether the Apply automatically function will apply the Number of items found within amount tolerance rule for this bank account by percentage or amount. The value is set to 1.
...
Bank Account Card Setup – Posting Tab
Description of field settings:
Currency Code Field
Set the code of the currency in which the account is kept outside the local currency, it is not set. After the first entry is posted, the currency code cannot be changed.
Bank Account Posting Group Field
Select a posting group from the Bank Account Posting Group table. The selected posting group determines which G/L account bank account transactions will be posted to. Setting up the posting group of a bank account is described in the chapter below.
...
IB Card Setup – Transfer Tab
Description of field settings:
SWIFT Code field
This field is set primarily if the account is used for foreign payments. By selecting from the SWIFT Codes code list, you will enter the corresponding SWIFT code of the bank in which you have your account.
IBAN Field
This field is set primarily if the account is used for foreign payments. Enter the international bank account number for the bank account.
For the Bank Statement Import Format, Payment Export Format, and Foreign Payment Export Format fields
only if you are going to export foreign payments from the bank account, select the code from the Bank Export/Import Settings table. Codes are only set up if you want to download statements and create payment orders. The settings of the table from which the codes are selected (Bank Export/Import Settings) are described in the https://iao.atlassian.net/wiki/spaces/OCDOC/pages/20480297/Nastaven+Bank#Nastaven%C3%AD-exportu%2Fimportu-banky .
Payment Import Format field
is set up only if you want to use accumulated payments.
...
Bank Account Card Setup – Payment Journal Tab
Description of field settings:
Variable S. to Description
Specifies the copying of the variable symbol for payment to items.
Variabilní s. do variabilního symbolu (Variable S. to Variable S.)
Specifies to copy the payment variable symbol into the Variable symbol field in the payment reconciliation journal.
Variable S. to Description to External Document No. (Variable S. to Ext. Doc.No.)
Specifies to copy the payment variable symbol into the External Document No. field in the payment reconciliation journal.
Dimension from Apply Entry
Specifies the transfer of Dimensions from the applied (paired) entry (document) to the payment line.
Post Per Line
specifies whether the Bank Account will be used as the balance sheet account number on each line, if this option is not enabled, the system will post to the balance sheet account of the bank in turnover.
Search Rule Code
Non Associated Payment Account
Specifies the account for unlinked payments. By selecting an account from the chart of accounts, unpaired payments will be set up here. In the payment reconciliation journal, such entries can then be manually matched or the account for posting can be changed.
Bank Account Card Setup – Payment Orders and Bank Statements Tab
Description of field settings:
Domestic Payment Order ID and Foreign Payment Order ID
It is used to select a print report.
Payment Partial Suggestion
Allows loading an item that already has a payment paired, but is not fully settled.
Foreign Payment Orders
It allows you to create payment orders in a currency other than the local one for domestic bank accounts. For a foreign currency bank account, this field must always be checked.
Check Czech Format on Issue
Specifies whether the Czech format of the domestic bank account should be checked when issuing a domestic payment order.
Payment Jnl. Template Name
Select a template from the General Journal Template List code list that will be used for posting your bank statement
Payment Jnl. Batch Name
Select a template sheet from the General Journal Batches code list that will be used for posting the bank statement
Check External No. by Current Year
Specifies whether to check external document numbers in the current year when the bank statement is issued.
Bank Account Card Setup – Numbering Tab
Description of field settings:
Field Command Numbers (Payment Order Nos.) and Statement Numbers (Bank Statement Nos.)
are set by selecting from the No. Series code list and specify the code of the number series that will be used for assigning payment order numbers and for assigning numbers to bank statements.
Field Issued Order Numbers (Issued Payment Order Nos.) and Issued Statement Numbers (Issued Bank Statement Nos.)
are set by selecting from the Number Sequences code list and specify the code of the number series that will be used for assigning numbers to issued payment orders and for assigning numbers to issued bank statements.
...
In the table settings, the objects provided by MS will be used according to the specific requirements from the client.
For OCsOC CZ, new fields Default Folder Path and Archive Folder Path have been added, where the paths to the network folder paths for automatic processing of bank statements are set.
Set up
...
Search Rules
Search rules are used to automatically apply bank statement entries when they are created Payment Journal from a given bank statement for version BC20 and above. They can significantly speed up the process of processing a bank statement in the system and make it easier for users to identify individual payments.
...
Identification part of the rule
Description of field settings:
Description
It can contain a detailed description of the rule for better orientation.
Bank Transaction Type
Here you can define a restriction on the type of bank transaction. The values can be Credit, Debit, or Both (indiscriminate – default value). For example, if the rule is set to Debit, this line will only be applied to lines in the bank statement that have a positive amount.
The search scope determines which logical part of a row is valid. The possible choices will be:
Balance
searching in items of customer, supplier, employee, "old" backups Base application
Customer
search in customer items and "old" sales advances Base application
Supplier
search in vendor items and "old" purchase advances Base application
Employee
Searching in Employee Entries
Advances
The option is complemented by the application of new CZ advances (Advance Payments Localization for Czech) and allows you to search in "new" purchase and sale advances
Account Mapping
This option specifies that the filtering part will be used instead of the search part of the rule.
...
Bank Account No.
If the field is checked, the system will search for the given range (customer, supplier, employee entry) by bank account number. For a given bank statement row, the customer/vendor's bank accounts are always searched for and the bank account is searched for in the employee table. If exactly one customer or supplier or employee account is found, a filter is automatically applied to the customer/supplier/employee number in the items in addition to the given filters.
Amount
If the field is checked, the system will search by amount with a currency code in the given range (customer, supplier, employee, advance payment). The system will work with the payment match tolerance defined on the bank account card (the Match Tolerance Type and Match Tolerance Value fields).
Variable Symbol
If the field is activated, the system will search for the given range (customer, supplier, employee, advances) according to the variable symbol.
Constant Symbol
analogous to the Variable symbol field.
Specific Symbol
analogous to the Variable symbol field.
Multiple Result
The field specifies which item the system should suggest for settlement if more than one item matches the specified search rule criteria. Possible field values are:
First Item Created –
The system selects the oldest item
Last Created Item –
The system selects the most recent item
Nearest due date – Due Date
The system selects the item that has the oldest due date. If the due date values match, it selects the first item from them
Last due date – Due Date
The system selects the item that has the youngest due date. If the due date values match, it selects the first item from them
Nearest Next Posting Date –
The system selects the item that has the oldest posting date. When the values are matched, the date selects the first item from them
Last posting date – Posting Date
The system selects the item that has the youngest posting date. When the values are matched, the date selects the first item from them
Smallest remaining amount – Amount Remaining
The system selects the item that has the smallest value in the Remaining Amount (LCY) field. When the balance amount values are matched, it selects the first item from them
Largest Remaining Amount –
The system selects the
item that has the largest value in the
Remainder (LCY) field. When the balance amount values are matched, it selects the first item from them
Continue –
With this option, the system does not select any item and continues the pairing with the next search rule
.
Filtering part of the rule
...
In this table, the vendor sets up the appropriate procedure for direct collection.
...
Bank Account Card
Open Bank Account Cardto which your company will receive collected payments.
...
Exp. Format. SEPA Direct Debit
Select Code SEPADD (SEPA Direct Debit).
The appropriate procedure is already set up under this code
Creditor No.
In the Creditor No. field, enter the CID (Creditor Identifier) of the company (client).
The CID is a unique identifier of the direct debit recipient and is a mandatory part of SEPA direct debit orders
The CID consists of the ISO code of the respective country, check digits, any specification of the beneficiary's business activities, and up to 28 digits reserved for the beneficiary's national identifier
...
On Customer Card Next, open the Direct Debit Authorization (Customer Card > Related > Customer > Direct Debit Authorization):
SEPA Direct Debit Authorization
...