Skip to main content

Notifications

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

Business Central - On-premises to SaaS Migration

Posted on by 90

One of our clients is migrating from on-premises version to SaaS version of BC and I want to upload opening balances.

Is there any way to generate inventoy report containing, bin wise, lot wise, expiration date wise stock in BC?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    RE: Business Central - On-premises to SaaS Migration

    Hi, Kaspars, unfortunately, there is no Bin in Item Ledger Entries, and Bin info is in Warehouse Ledger Entries. I think this is where BC/NAV is relatively weak. There is no perfect inventory list.

    pastedimage1677543478076v1.png

    So, I agree with Inge, physical inventory journal is a good way to go.

    Using Open in Excel can easily export all the content on the page.

    pastedimage1677543606006v2.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Business Central - On-premises to SaaS Migration
    [quote user="Vikas._646"]

    Thanks for reply.

    Can you please guide me how to export physical inventory journal with lot, expiration date details.

    I tried it through config pack but both data missing in downloaded excel sheet.

    [/quote]

    The easiest way is simply to use the open in Excel feature when you are in the physical inventory journal.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: Business Central - On-premises to SaaS Migration

    Item Ledger Entry page should have Bin, Lot No., Expiration Date fields visible. If You filter by Open=Yes, You should be able to get all entries.

    Here You also have the Cost Amount (Actual) to have the latest updated Inventory value.

    Exporting this to Excel, and copying values to configuration Package template - it can be imported right back in BC.

  • Vikas._646 Profile Picture
    Vikas._646 90 on at
    RE: Business Central - On-premises to SaaS Migration

    Thanks for reply.

    Can you please guide me how to export physical inventory journal with lot, expiration date details.

    I tried it through config pack but both data missing in downloaded excel sheet.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Business Central - On-premises to SaaS Migration

    hi

    you could perform a direct data migration from on prem to Saas

    danieleincalza.blogspot.com/.../business-central-migrate-on-premis-data.html

    check my reply if it was helpful, thanks

    DAniele

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Business Central - On-premises to SaaS Migration

    You can generate a physical inventory journal in on-prem, export it and import it to your online instance as an item journal.

    Remember to pay attention to the cost prices so you get them correct.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans