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... / Dimension Set / How to...
Small and medium business | Business Central, N...
Suggested Answer

Dimension Set / How to identify where a dimension set is used

(0) ShareShare
ReportReport
Posted on by chris197 50

Question:  We have a dimension that was added inadvertenly -- it should not have been added (on the Transaction Dimension Code 000).  In a period of a couple of hours something was associated with the dimension set id.  

How do I:

1.  Figure out where the dimension set ID was actually used? 

pastedimage1648305736042v1.png

2.  Delete it that use or DIM CORRECT?

3.  Allow me to delete the dimension value that was created

MSFT if you are listening I think this process should be easier!

Chris

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,379 Super User 2025 Season 2 on at

    Hi, A dimension set is a unique combination of dimension values. 

    You can find the records in table 480 "Dimension Set Entry".

    More details: https://docs.microsoft.com/en-us/dynamics365/business-central/design-details-dimension-set-entries-overview#:~:text=A%20dimension%20set%20is%20a,belongs%20to%20the%20dimension%20set.

    For example:

    1:
    Area 40

    pastedimage1648424401826v1.png

    3:

    Area 40

    CustomerGroup MEDIUM

    SALESPERSON JO

    pastedimage1648424453474v2.png

    For ease of understanding, let's look at a practical example.

    Create a new sales line. Set dimensions.

    pastedimage1648424566585v3.png

    Dimension Set ID is 20.

    pastedimage1648424593052v4.png

    The dimension set.

    pastedimage1648424666599v5.png

    As of now, you can only use the Correct Dimension feature on General Ledger Entries.

    pastedimage1648424740403v6.png

    Hope this will help.

    Thanks.

    ZHU

  • chris197 Profile Picture
    chris197 50 on at

    This is exceedingly helpful, Zhu. Thank you.

    One follow up question.  How do I actually access the dimension set entry?  I am not sure how to open it.  That may be a dumb question but I can't find it.

    Is there a permission setting involved?  

    Chris

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,379 Super User 2025 Season 2 on at

    Hi, Sorry I didn't explain clearly, this page cannot be opened directly.

    But you can force Business Central to run "Dimension Set Entry" table by adding the ?table=480 parameter to the URL, such as in the following example: 
    businesscentral.dynamics.com/.../Sandbox02?table=480

    pastedimage1648427886789v1.png

    pastedimage1648427918757v2.png

  • chris197 Profile Picture
    chris197 50 on at

    Got it! Excellent - 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…

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 2,990

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,028 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans