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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Use of spaces in Dimen...
Small and medium business | Business Central, N...
Suggested Answer

Use of spaces in Dimension Code Names

(0) ShareShare
ReportReport
Posted on by Community Member

I assume you can't have a space in a dimension code? I have only just realised this when trying to upload budgets. We have been using 2 x dimensions for a number of years with the names PRODUCT GROUP and CUSTOMER GROUP and never experienced any issues until now when we come to upload budgets. I have searched online for confirmation of this spacing rule but can only find demos of setting up dimensions and can see that nobody uses spaces.

If this is the case, how do I fix the 2 x dimensions already in use on my system. Do I simply remove the space in the code and rename?

I have the same question (0)
  • Suggested answer
    ArturV Profile Picture
    ArturV 225 on at

    Basically once you rename the dimension it will automatically every field in every record where the dimension table is specified as TableRelation. This won't happen for the Dimension Filters in specific parts of the application because it has type of Text and no connection to the Dimension table. What the issue you experience when upload the budget? I'm curios if this can be fixed somehow.  

  • Community Member Profile Picture
    Community Member on at

    This is the error message I receive.

    The other thought I had is that the 2 x dimensions we have set up with spaces are our global dimensions.  Does that have something to do with the issue?

    ---------------------------

    Microsoft Dynamics NAV

    ---------------------------

    This message is for C/AL programmers:

    The call to member Add failed. Microsoft Excel returned the following message:

    The name that you entered is not valid.

    Reasons for this can include:

    -The name does not begin with a letter or an underscore

    -The name contains a space or other invalid characters

    -The name conflicts with an Excel built-in name or the name of another object in the workbook

    ---------------------------

    OK  

    ---------------------------

  • Suggested answer
    ArturV Profile Picture
    ArturV 225 on at

    That is actually even better. Use the "Change Global Dimensions" batch report from the General Ledger Setup and it will do the rename action.

  • Community Member Profile Picture
    Community Member on at

    Sorry Artur, I have 2009 version. I did Financial Management/General Ledger/Setup/General Ledger Setup. In the dimensions tab, all the dimensions are selected from a drop down list so I can't rename anything?

  • Suggested answer
    ArturV Profile Picture
    ArturV 225 on at

    Tthere is a button/action called "Change Global Dimensions" in the page/form General Ledger Setup

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans