Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Migrating data between third party apps

Subscribe

Get notified when there's activity on this post

This question has been flagged
2 Replies
3086 Views
Avatar
sonthaibui

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.

0
Avatar
Discard
Altela

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

Avatar
Rock Jonn
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.


0
Avatar
Discard
Avatar
Mily Shajan
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


0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now