D365 FO Licences we can create multiple company ,and each company has Different Data base?:

(0) Share

Report

Posted on by arif imteyaz

375

D365 FO Licences we can create multiple company ,and each company has Different Data base?:

if create multiple company then Data base is different.

Exp : I create A,B,C,D company so Data Base will create A ,B,C,D

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (2)

Report

One D365FO system is always connected to exactly one database.

However it is possible to creaate multiple D365FO (prod) systems: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/implement-multiple-projects-aad-tenant

Every LCS Implementation project that runs on the same Azure AD tenant must satisfy the minimum licensing requirements. For example, if there are three LCS Implementation projects on the same Azure AD tenant, a customer must purchase no less than three times the minimum number of subscription licenses. Currently, the minimum license requirement is 20 full user licenses. Therefore, to run three LCS Implementation projects on the same Azure AD tenant, the customer must purchase at least 60 licenses.

Was this reply helpful? Yes No
arif imteyaz 375 on at

Like (0)

Report

we have 100 user assign licencee . if i create 5 company it will create 5 different data base.

means each company has own transaction not shared.

Was this reply helpful? Yes No
Verified answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

Transactions and database are different. As Nikolaos mentioned it's one DB. Multiple companies are maintained in the DB/tables. Each company name is different (DB field DataAreaId).

E.g. you have 5 companies and created customer in 5 companies.

So in DB you will see following @ CustTable.

CusAcct. DataAreaId

Cust1. LegalEntity1

Cust2. Legalentity1

Cust2. Legalentity2

And so on.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

You need to create 5 LCS Implementation projects (you need to request this from Microsoft). In each of them you create one prod system and one company in it.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

If you request for 5 different implementation projects, you have to buy 5 licenses with each the minimum number of users. Based on the number of users required for each company, it might be the case that you have to buy more than 100 users.

e.g.

Company A: 30 users

Company B: 30 users

Company C: 20 users

Company D: 10 users

Company E: 10 users

This makes 100 in total. However, for company D and E, you also have to buy 20 licenses if you decide to go for separate environments. In this example, it would require 120 licenses.

Also note that customizations needs to be deployed per environment which would be some more work in your project. Also configuring regression testing per environment. And there are more examples where this option would be less efficient and requires more work for your employees managing the application.

If you have it all in one environment, you can indeed separate by company. However, note that technically the ledger transactions are in a shared table, tagged with a ledger field to determine for which company the voucher is created. You have to define the security in a correct way to prevent having users read access on transactions from other companies. This would require some additional effort if you open up Odata capabilities on ledger transactions. It can be restricted using eXtensible Data Security.

Was this reply helpful? Yes No