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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Previous Transaction Data Import

(0) ShareShare
ReportReport
Posted on by 50

HI Team

Anyone knows how to Import Data From NAV to Business central which include previous 2 year transaction history. I Import the data through Package data has been imported but it previous transaction is not migrated. thanks in advance for your time.

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    133 on at

    Depends on the version of NAV check this first at least: docs.microsoft.com/.../migrate-data

    You will need consider the version though as it has limits: docs.microsoft.com/.../faq-intelligent-cloud

    Failing that you are looking at doing a lot of journal postings or creating a migration routine that takes posted entries and converts them to a journal before posting them as g/l entries again. To get the sub ledgers you will need full postings too.

  • JAngle Profile Picture
    133 on at

    Found that customers generally want historical data for reporting purposes. Potentially more cost/time effective to place the data in a data cube or in CDS.

  • Suggested answer
    Renni Profile Picture
    960 on at

    We found the best way to achieve this is to upgrade them to on premise first as it is easier to take the historical transactions.

    Then you can replicate to the cloud and eventually remove the on prem once out of synchronisation

  • Suggested answer
    JAngle Profile Picture
    133 on at

    Biggest thing to consider here is you have options. Each have varying time/cost implications. The main factor for the decision should be the UX come the end of it.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans