Business Central Dimensions Explained: Better Reports Without a Bigger Chart of Accounts

1. 01Your chart of accounts keeps growing: one travel account for every department, one sales account for every region.
2. 02A simple question, such as "how much did this project cost?", needs an Excel sheet and a few hours.
3. 03Two people tag the same kind of cost two different ways, so reports never quite match.
4. 04Budgets are built one way and actuals are recorded another, so comparing them takes manual work.
5. 05Leadership wants numbers by location, product line or customer type, and finance says it would need a new system.

1. 01Global dimensions: two at most. These work as filters across Business Central, including reports and batch jobs. Choose the two you rely on most.
2. 02Shortcut dimensions: up to eight. These appear as ready-to-fill fields on journal lines, document lines and ledger entries, so users can tag a transaction quickly. The two global dimensions are always the first two of the eight, which leaves up to six more.

1. 01Code Mandatory: you can require that a dimension has a value on specific accounts, so entries cannot be posted untagged. Use it where the data feeds real reports, such as income statement accounts.
2. 02Dimension combinations: you can block or limit pairs of values that should never appear together, for example a department that does not operate in a certain location. Everything else stays unrestricted.

1. 01A distributor analyzes margin by location, product category and customer type.
2. 02A professional services firm reports profitability by practice area, project manager and client industry.
3. 03A nonprofit tracks activity by fund, program, restriction and grant.
4. 04Any business can tag by department, project, region or salesperson to see costs and revenue where decisions are made.

1. 01Answers without Excel. Ask "how is this project, region or department doing?" and get an answer from Business Central.
2. 02A smaller, cleaner chart of accounts. One account plus a dimension replaces dozens of near-duplicate accounts.
3. 03Consistent tagging. Defaults and required values mean fewer entry errors.
4. 04Budgets that line up with actuals. When both use the same dimensions, comparisons work without manual reconciliation.
5. 05Room to grow. Add new departments, projects or regions as values, not as new accounts.
6. 06Better decisions, sooner. Leadership sees performance by the categories that matter to them.

1. 01Start with the questions. List the decisions your reports must support before touching the setup. Get finance, sales, operations and leadership to agree.
2. 02Keep "what" in accounts and "who, where, why" in dimensions. Do not use dimensions for things that belong in the chart of accounts.
3. 03Choose your two global dimensions carefully. Pick the highest-value, most stable categories, such as department, location, business unit or project.
4. 04Only track what you will actually report on. Rarely used or constantly changing attributes make poor dimensions.
5. 05Use defaults to cut errors. Assign default dimensions to customers, vendors, items, accounts and projects, and review them occasionally. If users override a default all the time, the design needs work.
6. 06Make values mandatory only where it matters. Too many required fields slow people down.
7. 07Use blocked or limited combinations for known bad pairings. Leave normal activity unrestricted.
8. 08Tag budgets and actuals the same way. It is what makes budget-to-actual reports reliable.
9. 09Plan the hierarchy before you build it. In a hierarchy, value codes should be in alphabetical order.
10. 10Assign an owner and write it down. Decide who can create, change, block or delete values, set naming conventions, and keep a short design document listing each dimension, its purpose and its allowed values.
11. 11Train your team. People should know why dimensions matter, which ones they own and how to fix a wrong value before posting.

1. 01Creating a new account for every department, location or project. This bloats the chart of accounts. Use a dimension.
2. 02Too many dimensions, or too many required ones. Data entry slows down and errors rise.
3. 03Overlapping values. If two values mean almost the same thing, reports split and confuse.
4. 04No naming standard or approval for new values. Reports become inconsistent.
5. 05Broad or outdated defaults. They spread mistakes at scale.
6. 06Budgets and actuals on different structures. Comparisons then need manual work.
7. 07Using the wrong posting rules on system-driven accounts. Microsoft advises against Code Mandatory on accounts used by certain automatic batch jobs, such as exchange rate adjustment and inventory cost posting, because those jobs cannot supply dimension codes.

1. 01List your reporting questions. What do leaders need to see, and by which categories?
2. 02Pick your dimensions. Usually department, location, project or business unit, plus any that your industry needs.
3. 03Choose global and shortcut dimensions. Two global, then up to six more for fields users enter often.
4. 04Define values and hierarchies. Keep them simple, clear and non-overlapping.
5. 05Set defaults, required values and combinations. Only where they help.
6. 06Test with real transactions. Post sales, purchases and journals in a safe test environment, then check the reports.
7. 07Train, go live and review. Check for missing or unusual values at each month end, and compare dimension reports to your financial statements.

1. 01What are dimensions in Business Central? Dimensions are labels, such as department, project or region, attached to transactions so you can filter and analyze them without creating extra general ledger accounts.
2. 02How many dimensions can I have? You can create as many dimensions as you need. Two can be global dimensions and up to eight, including the two global ones, can be shortcut dimensions that appear directly on lines and entries.
3. 03What is the difference between global and shortcut dimensions? Global dimensions work as filters across Business Central, including reports and batch jobs, and there can be only two. Shortcut dimensions are fields shown directly on journal lines, document lines and ledger entries, and there can be up to eight.
4. 04What is a default dimension? It is a value that fills in automatically when you enter a customer, vendor, item or account. Users can still change it on the line.
5. 05Can I change my dimensions later? Yes, but it is costly. Changing global or shortcut dimensions means updating posted entries, which can take time and lock tables. Plan carefully at the start.
6. 06Can I delete a dimension? Not once it has been used on any entry, even an unposted one. You can usually block values instead of deleting them.
7. 07What are analysis views? They are Business Central's way of analyzing entries by dimensions for recurring reports. The more consistently you use dimensions, the more useful they are.
8. 08Do small businesses need dimensions? Many do. Even a small company benefits from seeing results by product line, location or project without maintaining a long list of accounts.

If you tick two or more, a dimension review is likely to pay off:

1. 01Your chart of accounts has near-duplicate accounts for departments, regions or projects
2. 02Project, department or location reports need Excel to produce
3. 03The same cost is tagged differently by different people
4. 04Budget and actual reports do not line up
5. 05You are about to roll out Business Central, or you have outgrown your first setup