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

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

DIMENSIONS BACKWARDS

(0) ShareShare
ReportReport
Posted on by

Hello! In "select columns" in GL, Purchase Invoice, Sales Invoice, etc, that 2 dimensions are switched.  For example, the values for Dimension 1 belong to Dimension 2 and vise versa.  When you select them under "lines" and "dimension" it's correct, but when you try to do the "column select" and put in the value that way, it's backwards.  Does anyone have a fix for that?  My consultant has never seen it and doesn't know what to do to fix it.   Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: DIMENSIONS BACKWARDS

    I suppose it is just the Captions of the fields are mixed, e.g. due to some translation or customization issue, or even they were incorrectly named in the setup. Go to ***/Departments/Administration/Application Setup/Financial Management/Dimensions, open dimension list and try to rename them as needed if they are mixed there - would it result in a correct display?

  • Community Member Profile Picture
    on at
    RE: DIMENSIONS BACKWARDS

    Thank you for your answer.  They are set up correctly.  The only place they are backwards is when I use them in "choose columns" setup.   The weird part is for example: Dimension "Dept" if you select the value through Cntrl+Shift+D on the line, you can select the correct value, and it even shows up on the line correctly.  But if you were to select it from the drop down under the column "Dept", it's not there.  All the values belong to Dimension "Area" (for example).  It's very strange.  Trying to work around it but it would have been easier if I could have just used it as a column.  I shouldn't have to "work around".  Seems like it's just a programming issue.  It's pointing to the wrong values.  My consultant's suggestion is to make up 2 new dimensions.

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: DIMENSIONS BACKWARDS

    Sounds strange. Check with your consultant what are the captions on those dimensions that are used in the page you refer to. Are they correct?

  • Community Member Profile Picture
    on at
    RE: DIMENSIONS BACKWARDS

    i'll forward this to him.  Thank you!

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans