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

copying entries between Tenants

(0) Share

Report

Posted on by Jihadha

Hello,

I have a question regarding the multitenant deployment.

Is it possible to export entries (journals entries, inventory entries....) from Tenant1 and import them in Tenant2.

Best regards,

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 81,789 Super User 2025 Season 1 on at

Like (0)

Report

RE: copying entries between Tenants

Hi, there is a solution, but I find it a bit complicated.

Export Database (bacpac file) from Business Central Admin Center -> Change the Business Central from an online deployment to an on-premises deployment -> Migrate On-Premises Data to Business Central Online (Other Tenant)

More details: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/tenant-admin-center-database-export#using-the-exported-data

Some related information:

https://yzhums.com/5010/

https://yzhums.com/6646/

Hope this helps.

Thanks.

ZHU
matthias_rabus 160 on at

Like (0)

Report

RE: copying entries between Tenants

You can try to use "Edit in Exel" feature. Export the posted entries to Excel in Tenant1, rearrange some columns/fields and copy the lines.

Then open the corresponding journal in "Edit in Excel" in Tenant2, insert the copied lines, do a little cleaning, send the data to BC and post it there.
Suggested answer

Inge M. Bruvik 1,021 Moderator on at

Like (0)

Report

RE: copying entries between Tenants

If it is for test and evaluation purpose you have some different options.

If you are running BC online you can copy your production tenant to a Sandbox. That is done in the admin center.

You can make a copy of the whole company from the Companies page. That works for both BC online and on prem.

If you are running Business Central on prem you can take a sql backup for your database and restore it to another tenant.
Jihadha 5 on at

Like (0)

Report

RE: copying entries between Tenants

Thank you so much for your reply.

But in your recommendation, I have to double book the entries in both tenants and it will cost us a lot of time.

I am looking to save time by Export and Import between the production tenant and evaluation tenant.

Do you have other suggestions?

Thanks in advance.
Suggested answer

Inge M. Bruvik 1,021 Moderator on at

Like (1)

Report

RE: copying entries between Tenants

It is not technically difficulties to export and import data between tenants.

You just have to chose the best technique depending on the amount of data and your business needs.

But i would not recommend that you export and import the entries tables like general ledger entries, item ledger entries, vendor ledger entries, customer ledger entries and so on.

Then i would recommend that you create journal lines and post the transactions in the other tenant so the entries tables are populated through posting.