TBC Bank Integration

Within the system, there is the ability to export payments and import bank statement. The integration is fully implemented for TBC Bank. For full integration with TBC, it’s necessary to set up Bank Accounts, Vendor Bank Account, Vendor Card, Bank Account Details in the system, and the process of creating, exporting and importing payments should be done in the Bank Payment Journal.

Before setting up Business Central, there are procedures that should be performed outside the system:

• The Company Director requests the company's personal banker to open API user for production environment.
• Service user name and temporary password are given to the director in one of TBC branches; this temporary password has to be immediately changed by API* and later this new password will be used in all requests. At the same time Digipass device is also given for two step authorization. Then a transaction request asks for Digipass one-time code and/or archived DBI service authorisation certificate and archive password / certificate password by email (Authorization through certificate).
• Authorization certificate has to be installed on server instance where database is hosted. (Online bank has been having issues with web client and since it could not see certificate properly, certificate was added on TBC Bank account so that every request is also sending certificate credentials.) For this second method, no Digipass device and one-time code is needed.

---

Required Settings

• To create company bank accounts, Select the icon, enter Bank Accounts and fill out mandatory fields for integration and completing with the bank:

  Section - General

  Fields	Description
  No.	Specifies the number of the involved entry or record, according to the specified number series
  Bank Code	International code of the Bank - TBCBGE22
  Name	Specifies the name of the bank where you have the bank account
  Bank Account no.	Specifies the number used by the bank for the bank account
  Export Format	Options- XML/Individual TBC API/TBC Package. Individual - not more then 10 payments are exported, Package - less and more than 10 payments are exported
  Import Format	Option - TBC API
  Client Bank	Specifies the type of interaction with the client bank system for the bank account, the ability to import/export a bank statement or just import
  Bank Service	Specifies authentication credentials of internet bank, the card of credentials created for TBC should be selected

  Section - Communication

  Fields	Description
  Country/Region Code	It’s necessary to choose for foreign currencies transactions

  Section - Posting

  Fields	Description
  Currency Code	Specifies the relevant currency code for the bank account
  Bank Acc. Posting Group	Specifies a code for the bank account posting group for the bank account. The selected one should have filled G/L, Transit and Commissions Accounts

  Section - Transfer

  Fields	Description
  SWIFT Code	Specifies the international bank identifier code (SWIFT) of the bank where you have the account (TBCBGE22)
  IBAN	Specifies the bank account's international bank account number

• To specify bank exchange formats, go to Bank Services. Here you can add bank account code and approproate bank service, and from actiones "Setup" opens main integraiton tool page with fields:

  Fields	Description
  Base API URL	Specifies the URL for connecting via the API if the bank extract format is being configured for online banking. For TBC Integration https://dbi.tbconline.ge/dbi/dbiService
  API Login	Specifies the login for connecting via the API if the bank extract format is being configured for online banking
  API Password	Specifies the password for connecting via the API if the bank extract format is being configured for online banking
  Certificate File Name	Specifies the attached Certificate given by the bank
  Token	Specifies the Token for connecting via API
  Max Import Page	Specifies how many pages will be proceeded on import. Maximum 700 transactions can be imported per page

• Changing temporary password with API

On the Bank Account page, a new “Change Password” button has been added for changing passwords. First, add a token (one-time digipass code), then a new window opens where a new password is requested (password check and password policy is present); after successful change of the password, the password gets updated on the “Bank Extract Format” page in the “API Password” field.

• Bank Account Details defines the setting for recognizing specific operactions (such as transfers between own accounts, conversion, commisions...) by transaction codes . Select the icon, enter Bank Account Details and fill out the following mandatory fields:

  Fields	Description
  Code	Specifies the unique identification code associated with this bank account detail record
  VAT Registration No.	Specifies the Company's VAT registration No. from the company information
  Bank Account No.	Specifies the account number of the bank associated with this general ledger account bank operation
  Account Type	Specifies the type of account that the entry on the journal line will be posted to ( G/L Account/Vendor/Customer)
  Account No.	Specifies the Account No. to which the entry on the journal line will be posted to
  Bank BIC	Specifies the SWIFT BIC code of the recipient of the bank operation
  Document Type	Specifies the document type of the identifyed transaction by transaction code (Payment/Refund)
  IBAN	Specifies the bank account's international bank account number
  Transaction Code	Specifies the transaction code to which this bank information applies

The uniqueness of lines is checked by the following fields: Account Type, Account No., Currency Code, Transaction Code, Document Type, Payment Assignment.

If IBAN, Bank Account No. and Currency Code are empty -> the setup specified in bank account details work for all bank accounts without overlay filters for those fields, if any of the values are filled in -> it takes priority and use the indicated values as filters at the moment of checkup.

If in the Bank Account Details lines Shortcut Dimension 1 and Shortcut Dimension 2 are specified and the transaction in the buffer has been checked up from the setup in the bank account details -> the specified dimensions will be filled in the Bank Buffer accordingly.

• Vendor Bank Account card must be configured to export transactions. The following are the required fields for exporting payments in local and foreign currencies:

  Fields	Description
  Code	Specifies the unique identification code associated with this bank account detail record
  Bank Code	International code of the Bank
  Name	Specifies the name of the bank
  Adress	Specifies the adress of the Beneficiary Bank (for foreign payments)
  Country/Region Code	Specifies the country of the Beneficiary Bank
  City	Specifies the City of the Beneficiary Bank (for foreign payments)
  Currency Code	Specifies the relevant currency code for the bank account
  Bank Type	Specifies the Beneficiary Bank Type Vendor or Tax Authority (for treasure payments)
  SWIFT Code	Specifies the SWIFT code (international bank identifier code) of the beneficiary bank account. For treasure payments - TRESGE22
  IBAN	Specifies the bank account's international bank account number
  Intermediary Bank	Specifies the SWIFT code (international bank identifier code) of the intermediary bank
  SWIFT Intermediary Bank Name	Specifies the name of the intermediary bank

---

Functionality

Bank Payment Journal

In order to complete import/export of payments from bank payment journal, General Journal Batches should be set up. Select the icon, enter Bank Payment Journal, and from the Batch Name field, open General Journal Batches. There can be added batches for different bank accounts that company has. It is necessary to fill out Bal. Account Type, Bal. Account No., No.Series. and mark "Use Document No. from Batch No. Series" in order for Document No.s to always be unique in the bank payment journal.

After setting up the batches, choose one of them and begin the processes of bank payments.

For additional information about Templates and Batches, see the link.

Exporting Payments

TBC export formats:

• TBC XML - After filling out payment lines and clicking EXPORT PAYMENTS, an XML format file is downloaded to be manually imported into the internet bank. • Individual TBC API - payments are sent straight to internet bank's individual payments. • Package TBC API - payments are sent straight to internet bank's package payments.

For both export format types, TBC payments can be created in Bank Payment Journal and exported:

• To own TBC accounts, in national and foreign currency • To another bank account in national currency • To another bank account in foreign currency

• Bank Payment with the Vendor Account Type.

In order to export payments from the Bank Payment Journal to the Vendor, the following fields should be filled in:

Fields	Description
Posting Date	Specifies the posting date for the entry
Document Type	Specifies the type of document that the entry on the journal line is (Payment)
Document No	Specifies a document number for the journal line. Automaticaaly filled in from the No. Series of the batch
Account Type	Specifies the type of account that the entry on the journal line will be posted to (Vendor)
Account No.	Specifies the account no. that the entry on the journal line will be posted to (Vednor Account No.)
Description	Filled in with the name of the selected Account No
Currency Code	Specifies the code of the currency for the amounts on the journal line. Filled in automatically from the Bank Account No. of the selected Batch name
Amount	Specifies the total amount (including VAT) that should be exported
Recipient Bank Account	Specifies the bank account that the amount will be transferred to after it has been exported from the payment journal
Payment Assignment	Specifies the purpose of the payment
Payment Order Status	If export is required, select For Export from options
Expense Type	Specifies who is the payer of the charges and fees associated with the bank payment journal line (BEN/OUR/SHA)

Note. Refunding to Customer is filled out in the same way and can be exported.

Payment preparation can be done in the following ways:

• Manually
• By Suggest Vendor Payments. In the Payment Journal window, you can use the Suggest Vendor Payments batch job to suggest payment lines based on due date. For further information see the link.
• The Create Payment feature on the Open Documents subform. For further information:see the link

In case of exporting payment to Treasury (when Bank Type=Tax Authoirty), payment assignment value exports in additional description field in internet bank.

• Bank Payment with the G/L Account Account type

To export payments in the Bank Payment Journal from one company’s account to another, in Lines, select Account Type - G/L Account in Bank Payments Journal lines. The following fields should be filled out for exporting G/L Account payments:

Fields	Description
Posting Date	Specifies the posting date for the entry
Document Type	Specifies the type of document that the entry on the journal line is (Payment, Refund, Invoice, Credit Memo, Finance Charge Memo, Reminder)
Document No	Specifies a document number for the journal line
Account Type	Specifies the type of account that the entry on the journal line will be posted to (G/L Account)
Account No.	Specifies the account number that the entry on the journal line will be posted to. Only those accounts that are added for Bank Accounts in Bank Account Details should be indicated
Currency Code	Specifies the code of the currency for the amounts on the journal line
Amount	Specifies the total amount (including VAT) that the journal line consists of
Recipient Bank Account	Specifies the bank account that the amount will be transferred to after it has been exported from the payment journal
Payment Assignment	Specifies the purpose of the payment
Payment Order Status	If export is required, select For Export from options

After flling out the Lines in Bank Payment Journal and Changing Payment Order Status (with For Export), you can select Process-> Export Payments. The system will notify that export was successful, and Payment Order Status will change to Exported.

If any information is missing in the payment line, the system notifies about it. If there is incorrect information in a field, for example Recipient Bank Account is not valid, the Payment Order Status changes to ERROR, and an Error Message field is filled out with the reason of not exporting a payment.

Check Payment Status function allows you to check the status of exported payments (for individual and package payments):

1. Select the lines in the bank payment journal for which you want to check the status;
2. Actions -> Functions -> "Check Payment Status";
3. The status received from the bank will be filled in the "Transaction Status" field

Importing Payments

In Bank Payment Journal, click Import Bank Extract from the menu and choose the dates of payments you want to import. For the import to be completed, Bank Extract should be empty. If there are some lines in it, the system won’t import the payments.

After successful import, the payments will be imported in the Bank Extract Buffer window (Bank Extract -> Open Bank Extract):

Flow of the Checkup process of imported transactions in Bank Extract Buffer to identify transactions:

1. By Payment ID in case Checkup by Document No. is activeated for the Bank Account Card. When payments from the bank payment journal are exported successfully -> we received a "payment id" from the bank, wchich is unique and we also receive it when imporitng payments. The Account Type and Account No. will be filled from the identified transactions by paiment id from the bank payment journal.
2. According to the Bank Account Details which sets up rules for recognizing transactions by transaction codes
3. Customer/Vendor identification:
   • if the amount is positive (outgoing amount) the search is first performed in Vendors by Cor. Settlment Account, then by VAT Registration No., if not found: in Customers by Cor. Settlment Account, then by VAT Registration No.. If found, the Account Type and Account No. are filled in. If Account type=Vendor -> Document type=Payment, if Customer -> Document type=Refund.
   • if the amount is negative (ingoing amount), the search is first performed in Cusomers by Cor. Settlment Account, then by VAT Registration No., if not found: in Vendors by Cor. Settlment Account, then by VAT Registration No.. If found, the Account Type and Account No. are filled in. If Account type=Customer -> Document type=payment, if Vendor -> Document type=Refund.

By clicking the Check Up button you can update checking process.

-The lines colored in red are payments that the system doesn’t recognize by any of the Checkup Process. When clicking Import to Bank Payment Journal, red Payments stay in Bank Extract Buffer.

-The lines in black are payments which were recognized by the system and can be transferred into Bank Payment Journal by clicking Import to Bank Payment Journal on the ribbon of Bank Extract Buffer.

Process of checking for duplicate entries:

Imported Payments shouldn’t be duplicated in the system, so the Check Bank Extract for Duplicate Entries should be activated. When importing payments from Bank Extract Buffer to Bank Payment Journal, lines will be checked if the operation is already posted in General Ledger Entries or generated in Bank Payment Journals, this payment won’t be transferred to Bank Payment Journal.

• When checking in Bank Account Ledger Entries, the following parameters are checked: Bank Account No., External Document No.", Posting Date, Account No., Reversed=false, Amount
• When checking in Bank Payment Journal, the following parameters are checked: Account Type, BankAccount. No., Account No., External Document No., Posting Date, Amount

Matching Process of exported and the relevant imported transactions:

• The following fields must be matched to identify the exported transaction from the bank payment journal with the imported transaction in the bank extract buffer: payment order status must be exported, Account type, Account No, Document Type, Amount, Vat Registration No., Recipient Bank Account.
• Including all the above fields, you can additinally check transactions by document number where Document No (buffer)=Document No (bank payment journal) if the Compare Document No. function is activated on the Bank Account Card.
• Additionally, the matching process can only be performed by matching the Payment ID field only if the Matching by Document No for exp. transactions is activated on the Bank Account Card.

If all fields match -> Payment Order Status will change to Paid and update the posting date in journal from the Extract Date field (buffer). Matching transactions will not be duplicated in the bank payment journal.

Check Bank Account Details If you want to check if a Cor. Settlement Account exists for Customers/Vednors in the system, you can activate "Check Bank Account Details" function on the Bank Account Card. If such a cro. settlebemt account is not fund -> the system will notify you about the need to add Bank Account Card

Payment Сheckup logic for Credit Card transactions:

In order to match imported Credit Card Payments that may not have Cor Settlement Account/ Cor Vat Registration Account or both of them in the statement, it is mandatory to fill out the following settings:

In Bank Account Details setup:

• Account Tupe=Vendor/Customer, with Account No=empty

• Transaction Code= CCO,PLC (any codes provided in bank statement for payments that have Cor. Settlement account/Cor. VAT registration not empty in the bank extract)

• Type=None

• Payment Assignment=text1; text2; text3: "Search Name" randomtext:

• It is forbidden to add the line with the same values from fields above, including currency and IBAN.

In Vendor/Customer card setup: Search Name

Note. When Cor.settlement account=filled, Cor Vat Reg No=empty, after finding customer/vendor via Search, name filter system also looks for IBAN from the found vendor's/customer's bank account. Account No is assigned only if IBAN matches. If not, it remains empty.

Terminal Payments Import

Imported terminal payments can be splitted with commission amount according payment assignment and amount. In TBC bank service setup is added functionality for it. Select the icon, enter Bank Services , choose TBC bank setup and fill the fields to create new commission line with commision amount and assigned accounts:

Fields	Description
Allocate commissions of terminal payments	Specifies, if commission amount will be calculated and generated according to terminal payments in bank extract.
Allocate Transaction Code	Specifies transaction code of terminal payment, according which will be calculated and generated commission in bank extract.
Allocate Account Type	Indicates account type that needs to be assigned to terminal commission: Customer, Vendor, Bank Account, G/L account.
Allocate Account No.	Indicates account No. that needs to be assigned to terminal commission.

After Checkup of imported payment in Bank extract, system generates second payment line with amount "payment assingment amount- amount" and assignes appropriate account no for specific transaction code according TBC bank service setup.

Reverse posted transactions

The cancellation of the transactions must be performed from the Bank Account Ledger Enties using the action Reverse Transaction.

Web Request Logs

To create log of requests and returned responses, set up the following:

• Go to Bank Account Card,
• Open Bank Extract Format,
• Check Log Web Requests,
• Go to Bank Payment Journal,
• Create payment and send to onlines banking,
• Go to Web Request Log,
• Download the Requests/Response files.

In the Bank Extract Buffer, a new button called 'Fill Date' has been added. This button ensures that if the Extract Date is empty, its value is filled with the Document Date, and vice versa.