web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Best way to make dimension mandatory system wide

(0) ShareShare
ReportReport
Posted on by 1,165

Hi All,

We are using dimensions and use department dimension to run trial balance for each department. What's the best way to ensure that all transactions capture department code? If you are going through chart of accounts and then making dimension required then the end users may not get correct warning as some transactions have background postings and error messages maybe confusing to end users

Thanks

I have the same question (0)
  • Suggested answer
    Rani Shoura Profile Picture
    200 on at

    The thread here gives you how to assign dimensions for previous entries
    https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/147923/dimension-to-posted-entries

  • Verified answer
    Community Member Profile Picture
    on at

    Anita75,

    To make a Dimension mandatory, during ANY transaction posted, I would setup the Chart of Accounts, mainly Income Statement accounts, whereby the Dimension = Department is Code Mandatory. Then I would make sure for Customers, Vendors, Items the Department Dimension has a value, if known so this Dimension is filled in during entry. If no value is present, a User will receive a Warning stating the Dimension = Department cannot be blank. They will need to populate before posting.

    Did I answer your question?

    Thanks,

    Steve

  • Verified answer
    Dirk Profile Picture
    on at

    Please be aware that there are some scenarios where the dimension check is not performed as you might expect.

    Situation is: you have the dimension check enbaled to realized currency exchange raate differences (or for payment discount / payment tolerance)

    For example when posting a currency payment and only "applying" the payment to an invoice manually later.

    The point is that at the "manual /indirect apply" (after the payment has been posted without applying the open entry directly) the user has no chance to set a dimension (and the dimension is also not taken from the realized gains or losses accounts automatically, even if the dimension code has been specified for that account).

    So a decision had to be made by the Product Team between ...

    - requesting the user to reverse the payment and then post the payment again, this time with the needed dimensions and

    - do not block the user from posting the apply (without the dimension)

    Here it has been decided to not block the user (and accept the situation that the dimension setting is not checked)

    As a workaround the user can use the account schedule to find out the total net change for a period that has been posted without a dimension code and do a manual correction posting, for example once a month.

    But there is no automatic solution available yet.

    The dimension check should work fine however when you apply the open entry directly in the payment journal or cash receipt journal.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,226

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,047 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,257 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans