How to set up and use dimensions in Business Central

What dimensions in Business Central do

A dimension is a category, and its dimension values are the choices inside it. Department might hold Sales, Production and Admin. Say you post an invoice line with Department set to Sales. The general ledger, customer and item entries all carry that value. So one revenue account can be split by department in any report.

Because the tag travels with the entry, you do not need a separate account for each department and cost type. The chart of accounts stays short and says what was earned or spent. Dimensions say who, where or why. You can create as many dimensions as you need.

Global and shortcut dimensions in Business Central

General Ledger Setup lets you name two global dimensions and up to six more shortcut dimensions. Global dimensions are stored directly on ledger entries. So you can use them as filters on almost every list, report and financial report. Pick the two you slice by most often, commonly department and project.

Shortcut dimensions appear as their own columns on document and journal lines. Users can enter them without opening the Dimensions page. Other dimensions still work fully, but you enter them on that page. You can change the global dimensions later with the Change Global Dimensions page. Yet it rewrites many entries, so choose with care.

Default dimensions and posting rules for dimensions in Business Central

Open a customer, vendor, item, G/L account or salesperson and choose Dimensions to assign default values. Those values fill in automatically when the record is used on a document. The Value Posting field sets the rule. Code Mandatory forces a value, Same Code forces one specific value, and No Code forbids the dimension on that record.

Sometimes a line gets conflicting defaults, for example from the customer and the item. In that case, Default Dimension Priorities decide which source wins. Dimension Combinations let you block pairs that make no sense, such as a project with the wrong region. Also set Code Mandatory on income statement accounts, so nothing posts without a department.

Reporting with dimensions in Business Central

Financial Reports accept dimension filters and can show one column for each dimension value. That gives you an income statement by department from a single row definition. Account schedules built this way need no new accounts when a department is added. The Chart of Accounts page filters by global dimensions too.

For deeper analysis, set up Analysis Views. Each view summarizes general ledger entries by up to four dimensions. It feeds the Analysis by Dimensions page, where you pivot amounts across rows and columns. Power BI reads dimension data as well. And data analysis mode on list pages lets users group entries on screen without an export.

Common mistakes with dimensions in Business Central

The first mistake is creating too many. Every extra dimension is another field for users to get wrong. The second is using a dimension for something the system already tracks, such as customer or item. That adds effort and no new insight. The third is leaving values optional, which gives entries that fall outside every report.

You can fix entries posted with a wrong value using the Dimension Correction feature for general ledger entries. It keeps a record of each change. Still, prevention through defaults is better. If your current structure has grown untidy, our consultants can help you redesign it and move the history over in a sensible way.

Questions about dimensions in Business Central

How many dimensions can Business Central have?

There is no practical limit on the number of dimensions you define. Two can be global, and six more can be shortcut dimensions shown as columns on lines. You enter the extra ones through the Dimensions page on each document or journal line. So start with the few you report on, and add more only when a report needs them.

What is the difference between a global and a shortcut dimension?

Global dimensions are stored as fields on ledger entries, so they work as filters across reports and lists. Shortcut dimensions are a convenience for data entry on lines. The two global dimensions are also the first two of the eight shortcut dimensions. So you pick the two you use most for filters, and the rest stay quick to enter.

Can I correct a dimension after posting?

For general ledger entries, yes. The Dimension Correction feature lets an authorized user change values on posted entries and logs what changed. Analysis views are updated afterward. But it does not change subledger entries. So prevention is still the better control. Use default dimensions and Code Mandatory rules to keep wrong values out in the first place.

Should departments be accounts or dimensions?

Dimensions, in almost every case. If you keep departments out of the account number, one set of natural accounts serves the whole company. New departments need no new accounts. And the same report layout works for any slice you choose. That is the main reason to use dimensions in Business Central instead of a long segmented chart.

What happens to segmented accounts when we migrate from Dynamics GP?

The cloud migration tool for Dynamics GP brings the main account segment in as the G/L account. It turns the remaining segments into dimensions. So it is worth cleaning and renaming those segments before the migration. Then the resulting dimension values are meaningful from day one. We can help you plan that clean-up before you move.

Related guides for dimensions in Business Central

Dimensions in Business Central work hand in hand with the account structure and the reports built on it. These pages cover the chart of accounts, cost centers and our financial reporting services. Read them together, so your tags, your accounts and your statements fit one plan that your team can keep clean. For the product detail, see Work with dimensions on Microsoft Learn.