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

Business Central - On-premises to SaaS Migration

(0) Share

Report

Posted on by Vikas._646

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?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Vikas._646 90 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
KasparsSemjonovs 4,748 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,305 Super User 2025 Season 2 on at

Like (0)

Report

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.

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.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No