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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Data Migration if cutover date is in between the year

(0) ShareShare
ReportReport
Posted on by 84
Hi Experts,
 

We have a client with a planned Go-Live on 1st May, and we are currently in the process of planning the data migration strategy from 1st January onwards.

We would like guidance on the most appropriate approach for this scenario:

  1. Should we migrate only opening balances as of 30th April, or should we also consider migrating detailed transactions (Jan–Apr)?
  2. If transactions are to be migrated, what would be the recommended approach for the following:
    • Purchase Orders
    • Purchase Invoices
    • Sales Invoices
    • General Ledger transactions
    • Item/Inventory balances
  3. In case of transaction-level migration:
    • How should the data be uploaded in Business Central (recommended sequence and tools)?
    • How can we ensure proper reconciliation between legacy system and Business Central?
  4. Specifically for inventory:
    • How should inventory balances (quantity and value) be brought into the system?
    • How should additional costs (freight, charges, adjustments) be handled during migration?
  5. What is the recommended approach for:
    • Open vs closed transactions
    • Ensuring accurate AR/AP aging
    • Matching trial balance and subledgers (GL vs Customer/Vendor vs Inventory)

From our understanding, one common approach is to migrate:

  • Master data
  • Opening balances
  • Open transactions (AR/AP/PO/SO)
    while keeping historical closed transactions in the legacy system, as full historical migration can be complex and time-consuming ()

However, we would like to understand:

  • In which scenarios detailed transaction migration (Jan–Apr) is recommended
  • And how to execute it correctly without reconciliation issues

It would be very helpful if someone could share a detailed, practical approach or real-life implementation experience, including examples or best practices followed during similar go-live scenarios.

Thanks in advance!

I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,028 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,121 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 669 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans