Skip to Content
Menu
This question has been flagged
2 Replies
2486 Views

I am currently use the Accounting app of Odoo mate. In order to install the Dynamic financial report app from Cybrosys I must use their accounting app also.  Is there any solution that I can migrate my data from old accounting app to new app?

Best regards,

Son.

Avatar
Discard

Hi, you might want to migrate it using import-export through excel file or creating a record through SQL queries

Best Answer

To migrate data from Odoo's accounting module to Cybrosys accounting, you'll need to follow a few steps:

  1. Export Data from Odoo: In Odoo, export the accounting data you want to migrate. This typically involves exporting data in CSV or Excel format. Ensure that you export all relevant information such as chart of accounts, journal entries, invoices, payments, and any other necessary data.

  2. Prepare Data for Import: Review the exported data and ensure it is in a compatible format for importing into Cybrosys accounting. If needed, reformat or reorganize the data to match Cybrosys' data structure or file format requirements.

  3. Import Data into Cybrosys: Access Cybrosys accounting and navigate to the data import or migration feature. Follow the instructions provided by Cybrosys to import the data you exported from Odoo. This may involve mapping fields from the exported file to corresponding fields in Cybrosys accounting.

  4. Validate and Verify Data: Once the data is imported into Cybrosys, review the migrated data to ensure accuracy. Check that account balances, transactions, and other information match your expectations. Perform any necessary reconciliation or validation processes to ensure data integrity.

  5. Run Tests and Adjustments: It's advisable to run tests and verify that the migrated data behaves as expected within Cybrosys accounting. Make any adjustments or corrections if inconsistencies or errors are identified.

  6. Go Live: Once you are confident in the accuracy and integrity of the migrated data, you can begin using Cybrosys accounting for your ongoing financial management.

It's worth noting that the specific steps and procedures may vary based on the versions of Odoo and Cybrosys accounting you are using, as well as any additional requirements or customization involved. Therefore, it's recommended to consult the documentation or support resources provided by Cybrosys for detailed instructions tailored to their accounting system.


Avatar
Discard
Best Answer

Hi 

You need to run some sql_queries for data mapping.

Some Examples of Queries are Below

UPDATE ir_model_data

SET module = ‘om_account_accountant’

where module = ‘base_accounting_kit’

Also, move the models 

ALTER TABLE table_name_base_accounting_kit

RENAME TO table_name_om_account_accountant


Regards


Avatar
Discard