+1 480 485 7373
Microsoft Teams
Global, shortcut and other Business Central dimensions side by side
Picking the right two global Business Central dimensions
Global dimensions matter because their values sit directly on ledger entries, which makes them available as filters on lists, reports and budgets throughout the system. Choose the two that the most people filter by most often. For many companies that means department or cost center in one slot, and location, region or business line in the other.
Project is a common temptation for a global slot. But if you use the Projects module (named Jobs in earlier versions), projects already have their own ledger and reporting. A dimension may just duplicate them. Think about who asks the questions. If the sales director and the plant manager both filter by region every day, region earns a global slot. If only the grants accountant needs a grant code, it can be a shortcut or an ordinary dimension.
You can change global dimensions later with the Change Global Dimensions action in General Ledger Setup. It updates the existing entries. It works, but on a large database it runs for a while and belongs outside business hours. Getting the choice right during design saves that effort and the testing that should follow it.
The four value posting rules for Business Central dimensions
Code Mandatory
Some value for this dimension must be present before the entry posts, but any value will do. Typical on revenue and expense accounts where every entry needs a department.
Same Code
The entry must carry exactly the value set as the default. Useful for a customer that always belongs to one region, so nobody posts it elsewhere by mistake.
No Code
The dimension must stay empty. Use it where a tag would mislead, such as a department on a bank or receivables control account.
No rule (blank)
The system suggests the default value, but users can change or remove it. Suitable where a sensible default exists but exceptions are normal day to day.
Default Business Central dimensions and how conflicts are settled
You set default dimensions on master records such as G/L accounts, customers, vendors, items, resources, fixed assets, bank accounts and employees. When a document line uses one of those records, the line picks up that record's defaults. Once someone has explained Business Central dimensions to your team, defaults do most of the tagging for them. A sales invoice might pick up a region from the customer, a product line from the item and a department from the revenue account, all without anyone typing a code.
When two sources suggest different values for the same dimension, Business Central settles it with default dimension priorities, which you set per source code. For sales documents, for instance, you can decide that the item's product line wins over the customer's. Setting priorities on purpose avoids results that depend on the order in which someone entered the lines.
Dimension combinations add another control. You can block certain pairs of dimensions or values from appearing together. Then nobody can post a cost center from one division with another division's code. Used sparingly, this catches mistakes that no single-dimension rule would.
Dimension sets: how every combination is stored
Explained simply, Business Central dimensions do not sit value by value on every entry. Instead, the system saves each unique combination of values once, as a dimension set with its own ID. Entries carry that ID. Two invoice lines tagged Department Sales and Region West, with no project, share the same dimension set ID.
This keeps ledger tables lean and lets you use as many dimensions as the business needs without widening every table. It is also why changing dimensions on posted entries is not a simple edit: the entry has to point at a different set. Business Central includes a dimension correction feature for posted general ledger entries. Still, limit it with permissions and use it deliberately, keeping a record of why each correction happened.
Building an analysis view from Business Central dimensions
- 1
Start from the question
An analysis view summarizes G/L entries, with budgets if you include them, by up to four dimensions. Begin with the report you need, such as margin by region and product line, and pick the dimensions that answer it.
- 2
Create the view and its filters
On the Analysis Views page, give the view a code, choose its dimensions, set an account filter and pick a date compression such as month to keep it small and quick.
- 3
Keep it updated
Run Update to build the summarized entries. Turn on Update on Posting only for small views, since it adds work to every posting; otherwise schedule updates through the job queue.
- 4
Use it in reports
Open Analysis by Dimensions to pivot the view, or reference it in financial reports so rows and columns filter by its dimensions. Power BI can read the same dimension values for dashboards.
Business Central dimensions questions we hear most
How many dimensions can Business Central have?
You can define as many dimensions as you need. Two can be global, and up to eight can be shortcut dimensions, including those two. Users enter the rest through the Dimensions page on a line or header. The real limit is what users will fill in correctly. Most mid-sized companies do well with a handful, each answering a regular reporting question. That is Business Central dimensions explained in practice: a few tags people fill in correctly.
Should department be a dimension or part of the account number?
Make it a dimension. Building department into the account number multiplies accounts and makes every new department a chart of accounts change. As a dimension, one expense account serves every department and reports filter or total by any value. It also works cleanly with budgets and analysis views.
Can we add dimensions after go-live?
Yes, you can create new dimensions at any time, and they appear on new entries once defaults or users supply them. Older entries will not carry the new dimension unless you correct them, so comparisons with earlier periods have limits. Changing which dimensions are global is also possible through Change Global Dimensions, but plan it for a quiet period.
More Business Central dimensions questions
What is the difference between a dimension and a posting group?
Posting groups decide which G/L accounts an entry posts to, while dimensions describe the entry for analysis. A customer's posting group sets its receivables account; its region dimension sets which regional report the sale lands in. Keep the two jobs separate. Using posting groups for analysis creates extra accounts, and dimensions cannot choose accounts.
Why do my dimension totals differ from the general ledger?
Usually because some entries posted without the dimension, or the analysis view is out of date. Check whether Code Mandatory is set on the relevant accounts, and update the view before comparing. A report filtered on a dimension value leaves out entries where that dimension is blank. Adding a blank filter often explains the whole gap.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.