Conversion
In the system, it’s possible to export conversions via the Currency Conversion document and match the imported Conversion payments with existing released and posted payments. The conversion functionality works the same way for both TBC bank and Bank of Georgia.
Required Settings
- To set up bank accounts for conversion transactions, use required setups tab from the following link: https://sadocs.smartcloud.com.ua/en-us/localization/ge-local/financial-management/tbc-integration.html
Additionaly, fill out the following on the Bank Account Card:
| Fields | Description |
|---|---|
| Currency Conversion Transaction Filter | Specifies the value of the Currency Conversion Transaction Filter that can include several transaction codes and should be used in Bank Account details. |
Currency Conversion Export
In order to export conversion from the Currency Conversion document, select the 
icon, enter Currency Conversion and open the page.
• Bank Account Sender - Account from where money should be converted.
• Bank Account Receiver - Account where the converted money should be received.
• Amount to Send - Amount that should be converted in a different currency.
• Conversion Rate - In both cases, for conversion from GEL or to GEL, the Rate with the “2.4676” format should be indicated.
• IF Bank Account Sender/ Bank Account Receiver has Currency=empty, it is the LCY currency. After filling those fields on Currency Conversion, the following fields are filled out automatically with GEL:
Currency Code to Send / Currency Code to Receive.
• After filling out the Conversion Rate:
-
If Bank Account Sender has Currency Code to send=GEL, then Operation Currency Rate is calculated according to the following formula: 1/Conversion Rate.
-
If Bank account Sender doesn’t have Currency Code to Send=GEL, then Operation Currency Rate is filled out with the same value as Currency Rate.
• According to Operation Currency Rate, the system calculates Amount to Receive.
• New fields in the General tab of Currency Conversion are editable and transferred to lines after using the Create Lines button:
| Fields | Description |
|---|---|
| Payment Assignment | Is a required field for bank to receive assignment for the conversion. |
| External Document No. | Specifies External Document No. |
| Payment Order Status | Specifies Payment Order Status, options: for export, exported, imported, paid, error. |
For Exporting Conversion, the “Export Conversion” button is used, but by the time of clicking this button system requires:
• Exporting Bank Accounts should have indicated integration details in Bank Services:Base API URL, API Login, API Password
• Payment Order status=For export; in another case, the system won’t export the conversion.
• Lines creation using the “Create Lines” button; the Created lines calculate gain/loss amount calculated according to the Operation Currency Rate and NBG Currency Rate.
Before posting the conversion, the document status can be changed into "Released/Reopened" using the appropriate buttons: Release, Reopen.
Importing Conversion
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, the Bank Extract should be empty; if there are some lines in it, the system won’t import the payments.
After successful importing, a new window of Bank Extract appears and the imported payments are filled in the lines. The payment is matched as conversion if its Transaction Code is also indicated in Currency Conversion Transaction Filter of Bank Account.
Imported Payments shouldn’t be duplicated in the system, so they are checked by External Document No. field in posted entries of Bank Account Ledger Entries.
- If the imported Conversion is already in the system, Operation Type=Conversion, Status=Released Payment, Order Status=Exported, it is checked in Currency Operation List. By the time of clicking Import to Bank Payment journal from Bank Extract, the system notifies about the duplicate and doesn’t let the payment be transferred to the journal.
- If the imported Conversion is already posted in system, it is checked in Bank Account ledger entries. By the time of clicking Import to Bank Payment journal from Bank Extract, the system notifies about the duplicate and doesn’t let the payment be transferred to the journal.
Recognized imported conversions fill in the following fields in the Bank Extract Buffer:
**Journal Template Name, Journal Batch Name, Line No, Document Type, External Document No., Document Date, Extract Date, Payment Assignment, Amount, Settlement Account, Account Type, Account No., Cor. Name.,Transaction Code. Unrecognized Payments leave Document Type, Account No. fields empty. The reason for not recognizing payment is generated in the Error Code and Error Description fields.
After transferring recognized payments to Bank Payment Journal, it's possible to post them, and posted entries will be added to the relevant Bank Account Ledger Entry.