Zentriq Agent is live on Microsoft AppSourceInstall it free →Microsoft AppSourceInstall it free →

"The Dimension Value Code must be ADM for Dimension Code DEPARTMENT for Customer 10000. Currently it's SALES."

Dimension value locked to one code by Value Posting

A default dimension on the record named in the message, here customer 10000, uses Value Posting = Same Code with a fixed value, so every line for that record must carry exactly that value. The line carries a different one, so Business Central refuses to post it. Set the dimension value on the line to the value named in the message, or have an administrator change the Value Posting rule on that default dimension if the restriction is out of date.

Why Business Central raises this error

Each default dimension on a master record has a Value Posting field with four options: blank means anything is allowed, Code Mandatory means some value must be present, No Code means the dimension must stay empty, and Same Code means only the value stored in the default dimension is accepted. When Same Code is combined with a Dimension Value Code, that value becomes the only legal one for every document line touching the record. Newer Business Central versions state the conflict explicitly, naming the required value and the value currently on the line, where older NAV and Business Central builds only said "Select Dimension Value Code ... for the Dimension Code ...".

  • The customer, vendor, item or G/L account named in the message has a default dimension with Value Posting = Same Code and a fixed Dimension Value Code.
  • The line inherited a different value from another record involved in the document, or a user overrode the value manually on the line.
  • Two master records on the same line each impose a value for the same dimension, and the conflict is resolved in favour of the one you did not expect.

How to fix it

  1. Read the message carefully: it names the dimension code, the record the rule is attached to (Customer 10000 in the example), the value that is required (ADM) and the value currently on the line (SALES).
  2. On the failing document or journal line, open the dimensions with Shift+Ctrl+D and set the Dimension Value Code for that dimension to the required value.
  3. If the required value looks wrong, open the record named in the message and choose Dimensions from its actions to list its default dimensions.
  4. Find the row for that dimension code and check Value Posting. Same Code with a value allows only that value, Code Mandatory allows any non-blank value, No Code allows none, and a blank Value Posting allows anything.
  5. Correct the Dimension Value Code or the Value Posting on that row if the restriction no longer reflects how the business works. Default dimensions on master data are normally reserved to administrators, so ask yours if the fields are not editable for you.
  6. If several records fight over the same dimension, review Default Dimension Priorities for the source code involved so that the intended record wins, then re-open the document so the dimensions are recalculated.

How to avoid it in the future

Use Same Code only where the value is truly invariant for that record, for instance a customer that must always be reported under one department, and prefer Code Mandatory with a default value everywhere else, because it still guarantees an entry without forbidding legitimate exceptions. When the fixed value changes, update the default dimension and the documents that are already open, since they were created under the previous rule. Where two records both impose a value, decide the winner once through Default Dimension Priorities rather than letting each user resolve the conflict by hand.

Frequently asked questions

What is the difference between Code Mandatory and Same Code?

Code Mandatory means the dimension must have some value, any valid one. Same Code means it must have exactly the value stored in the default dimension. Same Code with an empty value means no value at all is accepted.

Can I just remove the dimension from the line?

No. With Value Posting = Same Code and a fixed value, an empty dimension is refused just like a wrong one. The line must carry the value named in the message unless the rule itself is changed.

Related reading

Other Business Central errors