Skip to main content

Notifications

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

How to apply entries after data has been migrated

(0) ShareShare
ReportReport
Posted on by 323

Hello, 

We are going to use Journals to migrate all the data from the old system into Business Central. I'm talking about thousands of transactions on vendor/customer accounts. Once it's done, is there a quick way to match all the vendor/customer ledger entries?

Thanks

Alejandra

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: How to apply entries after data has been migrated

    Hi,

    My idea is according to the standard system.

    If entries store in different table, then you cannot do analysis on the historical data by using standard reports like Vendor Aging, Customer Aging. for that analysis you have to develop new reports.

    From this solution Client implementation cost increase.

    Regards

    Amit Sharma

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at
    RE: How to apply entries after data has been migrated

    First of all, the capacity of BC SaaS is limited. I agree with the above experts. It is recommended to import only Opening Balance.

    If you still want to do it, try the methods discussed below.

       

    Hope this helps.

    Thanks.

    ZHU

  • SonnyPawchuk Profile Picture
    SonnyPawchuk 114 on at
    RE: How to apply entries after data has been migrated

    Kim's answer is best.

    Doing a project right now to load seven years of detailed transaction history from GP after running the migration tool.  Loading that information with out affecting historical balances is hard enough without having to worry about matching the the customer/vendor.

    Best to load into separate tables and write a report to access/merge the historical data with the current data.

    See you all at Dynamics summit 2022.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How to apply entries after data has been migrated

    What i normally do is to import all the applied entries first. And when i do that i use the apply to oldest method.

    Once all appliced entries are imported i switch to apply manually when i import entries that are open at the time of migration.

    The apply to oldest will usually not match 100% the application that was done in the old system but at least only open entries from the old system will be open in Business Central.

    Another strategy is to simply skip all old entries and just migrate the open entries.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: How to apply entries after data has been migrated

    This is not a good idea. You will spend a tremendous amount of time on this and the client will not be happy with the cost.

    Put in separate tables and don't worry about application.

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: How to apply entries after data has been migrated

    Hi,

    If you transfer Vendor and Customer entries document wise then application of entries possible. Second there is no batch available in standard system to applies entries in one go. So for achieving this  create one Batch report and call the Application function to applies entries in on go.

    Regards

    Amit Sharma

    www.erpconsultors.com

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

News and Announcements

Announcing Category Subscriptions!

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,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans