In this blog post will explore one of the learning paths for MB-820, the one that covers creation of a new company in Business Central.
What makes a up a company? For someone working with Dynamics NAV or Business Central, the question is about the pillars of how Business Central is designed. Maybe it is an easy answer, but let’s try to put ourselves into someone else’s shoes, someone that had nothing to do with Business Central in the past.
As a developer for numerous systems, I am going to attempt to explain it for developers.
If you ever dealt with Sql Server, other than managing Business Central or Dynamics NAV databases, you would have heard of Adventure Works database. This is the sample database shipped with SQL Server by Microsoft.
If we open the Tables for Adventure Works we see a bunch of tables grouped in schemas:
We notice above, dbo, HumanResources, Person, Production or Sales schemas.
Others, use all tables in one schema, dbo.
Since Navision, to today’s Business Central, Microsoft ERP organizes the tables in system tables and companies’ tables. Each company has the same set of tables. All companies share a set of system tables.
Each company has the same set of tables, to accommodate master data (customers, vendors, items) and setup tables, used in business logic (General Posting Setup, Manufacturing Setup, Inventory Setup …), as well as transactional data (Customer Ledger Entry, Vendor Ledger Entry, General Ledger Entry).
E.g. if we create two companies ABC and DEF we will find a Customer table in each company:
- dbo.ABC$Customer
- dbo.DEF$Customer
Both companies will share system tables, e.g. dbo.User.
Business Central allows users, through its web client, to create new companies.
About creating new companies using the web client and not only, in my latest YouTube video. If you haven’t done so, please subscribe!
— Buy my book —
https://leanpub.com/BCLedgerEntriesInsights
Download Book sample: svirlan.com/wp-content/uploads/2025/01/BCLedgerEntriesInsights-sample.pdf
One Response