Email this post as a PDFTips and tricks · 20 October 2026 · 1 min read

Tip 28: Dimension combinations: block the nonsense

A sales department on a purchase cost centre, or a project on an account that is never project-related: dimension combinations stop them at entry.

Tell Me: Dimension Combinations. The matrix of dimension pairs: set a pair to Blocked (those two dimensions can never both be on an entry) or Limited, then open the pair and block specific value combinations (Department SALES with Cost Centre WAREHOUSE). The error appears when a user tries, with the dimensions named, not at month-end in a report.

Most businesses need a handful: project only with the departments that run projects; region only with sales accounts. Over-constrain and users work around it; under-constrain and finance reclassifies for a day each month.

Email this post as a PDF
A branded PDF of this post, sent to your inbox to keep, print or share. Copy in colleagues if you like.
We only use these addresses to send this PDF. Nobody is added to a mailing list. Mike at Business Boxed receives a copy. See our privacy notice.
Email this post
Talk to us
Want this done in your Business Central?
Book a 30 minute callGet the monthly newsletter

Related posts