View source | View content page | Page history | Printable version   

Projects:APR Migration Tool/Technical Documentation/Financial Account


Financial Account Migration


Each Bank Account defined in the application in Financial Management || Receivables & Payables || Setup || Bank || Bank >> Bank Account will create a new Financial Account of type Bank.

Default mapping for Bank type Financial Accounts:

Old Flow New Flow
Table Column Table Column
C_Bank name FIN_Financial_Account name
C_Bank -- FIN_Financial_Account Description ('Generated by Migration Tool')
C_Bank -- FIN_Financial_Account Type: Bank (B)
C_Bank c_location_id FIN_Financial_Account c_location_id
C_Bank swiftcode FIN_Financial_Account swiftcode
C_Bank codebank FIN_Financial_Account codebank
C_Bank routingno FIN_Financial_Account routingno
C_Bank codebranch FIN_Financial_Account codebranch
C_Bank digitcontrol FIN_Financial_Account bank_digitcontrol
C_Bank ine_number FIN_Financial_Account ine_number
C_Bank c_bpartner_id FIN_Financial_Account c_bpartner_id
C_BankAccount accountno FIN_Financial_Account accountno
C_BankAccount iban FIN_Financial_Account iban
C_BankAccount codeaccount FIN_Financial_Account codeaccount
C_BankAccount digitcontrol FIN_Financial_Account account_digitcontrol
C_BankAccount isdefault FIN_Financial_Account isdefault
C_BankAccount creditlimit FIN_Financial_Account creditlimit
C_BankAccount c_currency_id FIN_Financial_Account c_currency_id
C_BankAccount -- FIN_Financial_Account currentbalance: sum of all bank statements of the the C_BankAccount.
C_BankAccount -- FIN_Financial_Account fin_matching_algorithm_id: null


Each CashBook defined Financial Management || Receivables & Payables || Setup || Cashbook || Cashbook will create a new Financial Account of Cash type.

Default mapping for Cash type Financial Accounts:

Old Flow New Flow
Table Column Table Column
C_CashBook name FIN_Financial_Account name
C_CashBook Description FIN_Financial_Account Description + 'Generated by Migration Tool'
C_CashBook -- FIN_Financial_Account Type: Cash (C)
C_CashBook c_currency_id FIN_Financial_Account c_currency_id
C_CashBook -- FIN_Financial_Account currentbalance: 0
C_CashBook -- FIN_Financial_Account creditlimit: 0
The rest of columns are left as null

Financial Account and Payment Method association

All the Payment Methods created in the payment method migration process will be associated to each Financial Account using as default the configuration of the payment method definition.

The affected table is fin_finacc_paymentmethod

How to identify a migrated Financial Account

New column em_aprmt_financial_account_id in c_bankaccount table will contain the reference to the corresponding Financial Account.

New column em_aprmt_financial_account_id in c_cashbook table will contain the reference to the corresponding Financial Account.

Retrieved from ""

This page has been accessed 2,251 times. This page was last modified on 8 June 2012, at 05:26. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.