Last Updated: May 2026
It’s month-end and your CFO wants department profitability, location breakdown, and project-level detail — all from the same data. That shouldn’t take two days. But it does.
Somewhere between the GL export, the pivot tables, the copy-pasted spreadsheets, and the four separate workbooks your team built from scratch, the numbers stopped being current. The meeting starts in an hour. The analysis is already stale.
Here’s the reality: you’re not battling a data problem. You’re battling a structure problem. Your chart of accounts tells you what the money was spent on but it can’t tell you why, where, or for which project without creating thousands of accounts nobody could manage.
Business Central dimensions solve this. Here’s how.
What Dimensions Actually Are
Think of dimensions as tags you attach to every transaction. Sales order, journal entry, purchase invoice — each one gets labeled with the categories that matter to your business: department, location, project, product line, sales region.
Your chart of accounts tells you what. Dimensions tell you everything else.
The real power comes from combining them. Want to see Sales department revenue in the East region for Project Alpha? Done — without touching your GL structure.
Global vs. Shortcut Dimensions: Choose Wisely
Business Central gives you two Global Dimensions — your most critical reporting categories. These are stored directly in every transaction table, so they appear automatically across most pages and reporting runs fast. Most companies use Department + Project, or Location + Cost Center. The right choice is whichever two categories your team analyzes most frequently.
You only get two globals, so think carefully before you set them.
Beyond globals, you have six Shortcut Dimensions that supplement your reporting without slowing the system down. Everything beyond those eight still works for tagging and analysis — values just live in a separate dimension table.
Set this up in General Ledger Setup → Dimensions. Pick your two globals from the dropdown, select your six shortcuts, and you’re in business.
Default Dimensions: Where the Real Time Savings Live
Here’s what drives me crazy about dimension setups I see in the field: companies configure dimensions correctly, then skip default dimensions entirely. Then they wonder why month-end cleanup takes forever.
Default dimensions attach values to master records — customers, vendors, items, GL accounts. When someone creates a transaction referencing those records, Business Central fills in the dimensions automatically. No manual tagging, no forgotten entries, no cleanup.
Open any customer card, navigate to Dimensions, and set their defaults. A retail customer in the East gets Department: Sales, Region: East — automatically, on every sales order, every time.
Do the same for vendors. Your facilities vendor defaults to Department: Operations. Your marketing agency defaults to Department: Marketing. The system does the work.
One setting worth knowing: Business Central offers four behaviors for default dimensions:
- Blank — user can change or remove the dimension
- Code Mandatory — value required, but user can change it
- Same Code — locked to one specific value
- No Code — blocks that dimension entirely
Use Code Mandatory for most scenarios. It ensures transactions get tagged while still giving users flexibility.
Block Invalid Combinations Before They Cause Problems
Some dimension combinations make no sense for your business. The Retail project should never show Operations costs. Manufacturing locations shouldn’t carry Marketing expenses.
Navigate to Dimension Combinations to see a grid of all possible dimension pairs. Click any intersection to block or limit combinations. Blocked means those two dimensions can never appear together. Limited means you define which value pairs are valid.
This one setup step prevents a class of posting errors that are genuinely painful to untangle after the fact. Review your combinations quarterly — business changes, and your rules need to keep up.
The Reporting Payoff
This is why you do all of the above. Open Financial Reports (which replaced Account Schedules in recent BC versions), define rows for accounts, define columns for dimensions or time periods, and Business Central calculates the intersections automatically from your posted data.
Your CFO now gets department profitability, location breakdown, and project-level detail — pulled directly from live posted entries. Export to Excel for further analysis. The data is current every time because it pulls from what’s actually in the system.
No more rebuilding. No more stale spreadsheets. No more two-day month-end.
A Few Best Practices Worth Keeping
- Archive, don’t delete. When a project ends, block those dimension values for new transactions — but keep them active so historical reporting stays intact.
- Consistent naming matters. If one region is “Northeast,” don’t label another “SW.” Pick a pattern and stick with it. Inconsistency corrupts reports quietly over time.
- Audit monthly. Run a report showing transactions missing dimensions before you close the period. Build this into your month-end checklist.
- Don’t over-dimension. Dimensions work best for categories you slice across multiple accounts. If you’re tracking dozens of tiny subcategories, you may need more GL accounts instead.
Let’s Get This Set Up Right
We’ve helped organizations in all industries set up Business Central the right way, including dimension structures that give finance teams the reporting clarity they’ve been missing for years. With 40+ years of ERP experience and a long-standing Microsoft partnership, we know what works and what creates problems down the road.
If your team is still rebuilding the same reports manually every month, it’s time to fix that.
Contact CAL Business Solutions to talk through your reporting needs and get your dimensions built properly from the start.
