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

"Select a Dimension Value Code for the Dimension Code DEPARTMENT for G/L Account 6110."

Mandatory dimension value missing on a line

A master record used by the line, here G/L account 6110, has DEPARTMENT set as a mandatory dimension, and the line being posted carries no department value. Business Central blocks the posting until a value is supplied. Enter a DEPARTMENT value on the line, or, if the dimension should not be mandatory for that account, have the default dimension setup changed.

Why Business Central raises this error

Dimensions can be made compulsory per master record through default dimensions. When a default dimension line is set to code mandatory, every entry that touches that account, customer, vendor, item or job must carry a value for the dimension in question, and the posting routine checks each line before it creates entries. The message names both the dimension code and the record that demands it, so it points straight at the source of the requirement. The rule is inherited rather than typed: document lines take dimensions from the header and from the master records they use, and automatically generated lines such as rounding, discount or charge postings have to satisfy it too, which is why the message sometimes appears on a line nobody entered by hand.

  • A default dimension on G/L account 6110 has value posting set to code mandatory, and the line carries no DEPARTMENT value.
  • The document header has no DEPARTMENT value, so lines created under it inherited nothing to post with.
  • The failing line was generated automatically, for example a rounding, discount or charge line that posts to an account requiring the dimension.

How to fix it

  1. Open the journal or document that fails, select the line named in the error and choose the Dimensions action to see the dimension values the line would post with.
  2. Enter a value for DEPARTMENT on that line and post again. If every line needs the same value, set it on the document header dimensions first so new lines inherit it.
  3. To see where the requirement comes from, search for Chart of Accounts (Alt+Q), open account 6110 and open its default dimensions: the DEPARTMENT line will show value posting set to code mandatory.
  4. Check the default dimensions on the other records involved as well, such as the customer, vendor, item or job on the line, because each of them can impose its own mandatory dimension.
  5. If the account should genuinely not require a department, an administrator can change value posting on that default dimension line or remove the line. Do not remove it only to clear the message: reporting by department depends on it.
  6. For records used every day, fill the dimension value code on the default dimension line so the value defaults in automatically instead of being typed on every entry.

How to avoid it in the future

Make a dimension mandatory only where the reports really need it, and pair every code mandatory rule with a sensible default value on the master records that use the account, so ordinary entries carry the dimension without anyone thinking about it. Review the default dimensions whenever a new account or a new dimension value is created, and check the accounts used by automatic postings such as rounding, discounts and charges, since those lines cannot be corrected by hand at posting time.

Frequently asked questions

Where does DEPARTMENT become mandatory?

On a default dimension line of a master record, with value posting set to code mandatory. The message names the record that carries the rule, here G/L account 6110.

Can I post a blank department instead?

Not while value posting is code mandatory, because that setting requires an actual dimension value code. Only a change to the setup would allow a blank value, and that change needs administrator rights.

Related reading

Other Business Central errors