Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Historic Data Migration from old ERP

(0) ShareShare
ReportReport
Posted on by 17

Hi All

Importing historic data into Business Central

Business Scenario is we want to migrate last 3 years of Sales Orders. Purchase Orders, etc into Business Central from the old ERP system.

Plus in flight items...

One scenario is - Sales team will want to view via D365 Sales to Biz Central and see customer history of Orders, deliveries, invoices, etc

Any discussion threads on this issue?

Assuming we use Biz Central templates - how are the previous records treated? 

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Historic Data Migration from old ERP

    There are several different ways you can achieve this.

    The obvious option is to import the old sales invoices and purchase invoices into the standard BC tables and you can use configuration packages for that.

    But if i should do this I would most likely create customized table to import the historical data into BC so I can separate the old data from the new orders created in BC.

    If you are integrating BC to D365 sales you also then have the choice of having your historical order data only in Dataverse instead of having them in Business Central at all.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans