Business Central Dimensions, Part 2: Posting Rules and Controls — Building Discipline Into Your Data

In Part 1 of our series, we explored the strategy behind dimensions in Business Central—what they are, how to design them, and common myths surrounding them.

Now we’re getting into the real-world mechanics of dimensions in Business Central: how to make sure your carefully planned dimensions don’t fall apart during day-to-day posting.

Because here’s the thing: just building your dimensions isn’t enough. You need to enforce them. Otherwise, your data turns sloppy fast—and once it does, your reporting goes with it.

OK, there’s a lot to cover here so let’s get to it.

Why Posting Control Matters (Even if You Think You Don’t Need It Yet)

Your team’s not trying to sabotage your reporting. But if they can skip a dimension—or fudge it—they probably will.

• A journal gets posted without a department.
• A sales invoice gets tagged to an old, invalid region.
• A vendor payment is coded to a restricted combination of dimensions.

Now you’ve got gaps in your reports, inconsistent financials, and hours lost trying to fix or work around it.

While you can correct your dimensions, the best fix is prevention. Business Central gives you the tools to set smart defaults, enforce rules, and block bad data before it hits your books. You just have to know how to use them.

Default vs Manual Dimensions Explained

When you post a transaction in Business Central—whether it’s a sales invoice, purchase journal, or inventory adjustment—the system needs to know which dimension values to apply. That’s how you track things like departments, cost centers, or customer groups in your reporting.

But how do those values actually get onto the transaction?

There are two main ways:

1. Default (Automatic) Dimensions in Business Central

These are dimensions that Business Central fills in for you. You assign them to master records—like customers, vendors, items, or G/L accounts. When the dimension defaults, every transaction that record uses will be automatically flagged with the right dimension. Easy peasy – that’s how we want it to work.

Example:
You assign Customer Group = Retail to a customer. When you create a sales order, invoice or credit memo for that customer, Business Central inserts that dimension and dimension value automatically—no user action needed.

This is the ideal scenario:

• It’s fast
• It’s consistent
• It reduces human error

The more you can rely on default dimensions, the cleaner your data will be. However, key to remember: blank dimensions in this scenario will skew your reporting and create distrust in the numbers. So if you are assigning customer groups to customers, all customer must have a customer group.

2. Manual Dimensions in Business Central

While dimensions in Business Central are powerful, sometimes, there’s no way to predefine the dimension value for a particular transaction. Maybe the value changes depending on the situation. Since AI hasn’t gotten to this part yet, you’re left relying on a human to decide the proper dimension value.

Example:
You’re posting a general journal entry for office expenses, and the department depends on who made the request. In this case, there’s no default that makes sense—so the user must select the right dimension value manually at the time of posting.

Manual dimensions rely on people getting it right. That means more training, more time, and more potential for mistakes.

Why This Matters

Default dimensions are ideal. But you won’t be able to automate every scenario. There will always be edge cases—especially in general journals or expense management—where users need to select a value manually.

Regardless of how the dimension value gets there, the key is control.

• If a dimension is critical to your reporting? Require it.
• If only one value is valid? Lock it down.
• If certain combinations don’t make sense? Block them.
• If only a subset of values should apply to a specific customer or item? Restrict them.

These aren’t just “nice to have” controls—they’re essential to maintaining reliable data and trustworthy reports.

Essential Tools to Enforce Dimensions in Business Central

Let’s walk through the features you’ll want to configure to keep your dimension data clean and consistent.

---

1. Setting Up Default Dimensions

As mentioned above, default dimensions live at the master data level: customers, vendors, items, G/L accounts, and so on. They’re used to prefill dimensions automatically when a transaction is posted.

Think of them as guardrails. Set them correctly, and you reduce the chance of someone forgetting (or inventing) a dimension value during data entry.

Where to Find Them

Open any master record, then go to Navigate > Dimensions > Default Dimensions.

Here you can assign:

• Dimension Code: Which dimension to use
• Dimension Value Code: The default value
• Value Posting: How strictly the system enforces this value

Let’s unpack that third one, because it’s where most of the real control happens.

---

Understanding Dimension Value Posting Options

The Value Posting setting defines how Business Central handles dimension data during posting. You get four options:

Option	What It Does	Best Used For
Blank	No enforcement. The value is optional.	Very rare! Blank dimensions will skew reporting so be consistent. If you need a specific dimension on one record, then you need that dimension on all.
Code Mandatory	A dimension must be present—but users can choose any value.	Required dimensions like Department, Project where the user can select the proper dimension value. You can also set only the allowed dimension values if not all values are valid.
Same Code	Only the specific default value is allowed.	When the dimension is fixed (e.g., vendor always = Admin). These are the easiest and cleanest.
No Code Allowed	The dimension must be blank. Posting fails if any value is entered.	When a dimension is explicitly not relevant. Rarely used.

---

Real-World Example: How Defaults Clean Up Your Data

Let’s say every purchase to your “Office Supplies” account should include a Department.

You assign:

• G/L Account 61000 → Default Dimension = Department: Admin
• Value Posting = Code Mandatory

Now when someone posts a vendor invoice to 61000, Business Central checks for a Department. If it’s missing? Error. If it’s wrong? Still error. And if they leave it as Admin? Good to go.

---

2. Account-Specific Dimension Rules

You can also define dimension rules by account type, especially on the G/L account level. This is ideal when different accounts need different controls.

For example:

• G/L 65100 (Office Supplies) → Department = Code Mandatory
• G/L 48000 (Sales Revenue) → Sales Channel = Same Code

These rules enforce consistency without requiring users to memorize dimension logic. The system becomes the enforcer—not your accounting team.

---

3. Default Dimension Priorities (Yes, Order Matters)

Sometimes, multiple default dimensions might apply to a transaction. For example, an item has a default department, but so does the G/L account tied to it. Which one wins?

That’s where Default Dimension Priorities come in.

You’ll find this page under Default Dimension Priorities in the search bar.

Set the source type (like SALES or PURCHASE), then rank which tables should take priority. For example:

1. G/L Account
2. Item
3. Customer

This way, if there’s ever a conflict, the system knows which value to apply.

---

4. Dimension Combinations (Allowed vs Blocked)

It’s not just about whether a dimension is present—it’s whether the combination of dimensions makes sense.

Let’s say you have:

• Department = Sales
• Project = Internal CapEx

That combo doesn’t make sense. Sales shouldn’t be booking internal CapEx.

In the Dimension Combinations page, you can define:

• Allowed Combinations (only these are valid)
• Blocked Combinations (these are not)
• Limited Combinations (only certain dimension value combinations are allowed)

Using limited combinations in Business Central gives you precise control over which specific pairs of dimension values are allowed or blocked. Start by setting the dimension combination to ‘Limited,’ then drill down to define exactly which value pairings are permitted and which should be restricted.

Business Central will stop any transaction that violates the rules.

---

Step-by-Step Example: Controlling Dimension Entry

Let’s say your goal is:

• Department is required on office supply purchases
• Only Admin and Finance are allowed
• No other dimension combinations are permitted

Here’s how to do it:

1. Open G/L Account 61000
2. Set Default Dimension = Department
3. Set Value Posting = Code Mandatory
4. On the same screen, define Allowed Values: Admin, Finance
5. Open Dimension Combinations and block invalid pairings (e.g., Department + Project)

With this setting, posting will not happen unless the right department is selected, and users can’t enter something that breaks your reporting logic.

---

Business Central Dimension Controls FAQ

➤ Can I override a default dimension?

Yes. If Value Posting is set to Blank or Code Mandatory, you can choose the proper dimension value. No, if it is set to the Same Code.

---

➤ What happens if I leave out a dimension?

If the dimension is required (Code Mandatory or Same Code), the system will block the transaction and prompt you to fix it.

---

➤ Can I fix a dimension after posting?

Yes—on G/L entries. Use the Correct Dimensions function to make adjustments. It won’t change posted documents, but it will update financial reporting and audit trails.
Search → Correct Dimensions – G/L Entries. A new blog post on this coming soon.

---

➤ Can I prevent bad dimension combinations?

Absolutely. Use the Dimension Combinations page to block values that don’t belong together.

---

➤ How do I limit which values can be used?

Use Allowed Dimension Values to restrict selections by customer, vendor, item, or other master records.

---

Final Thoughts: Consistency Creates Trust

Dimensions are one of Business Central’s most powerful tools—but only when they’re used consistently. With the right posting rules in place, you can stop errors before they happen and trust the data in your reports.

And trust? That’s what turns dimension data into business insight.

---

Up Next: Fixing Dimensions in Business Central

In Part 3, we’ll show you how to fix dimensions that are incorrect. Part 4 will start the Reporting on Dimensions in Business Central series.

Subscribe to the Dynamics Power Play blog to get Part 3 as soon as it drops. Or check out our past posts for more in-depth Business Central guides.