web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

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? 

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,045 Moderator 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,828

#2
Sumit Singh Profile Picture

Sumit Singh 2,617

#3
YUN ZHU Profile Picture

YUN ZHU 1,861 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans