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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Deleting A Dimension
Small and medium business | Business Central, N...
Answered

Deleting A Dimension

(0) ShareShare
ReportReport
Posted on by Talha Siddiqui 127

Hi,

Is there anyway to delete a Dimension completely from the system?
I have tried VLDM, Dimension Correction tools.. They only change or remove the Dimension value from a particular transaction.
I want a Dimension to be completely removed along with its values.





Thanks.

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 119 on at
    RE: Deleting A Dimension

    If all transactions have the trace of it removed does it still error when you try to delete from the dimensions page?

    Failing that you will need to use the blocking features. Try deleting again after a close income statement

  • Talha Siddiqui Profile Picture
    Talha Siddiqui 127 on at
    RE: Deleting A Dimension

    If being removed from all the transactions it will surely be deleted form the dimension's page easily. But one cannot go through all the transactions one by one to delete a particular Dimension. I am looking for an easy way to do it.

    Yeah Blocking is an only option I guess that remains valid. But the blocked dimensions remain visible. And that's surely not what I am looking for.

  • Suggested answer
    JAngle Profile Picture
    JAngle 119 on at
    RE: Deleting A Dimension

    Do you have “Dimension Corrections” available in your version? If so that is a method go through the data on mass. docs.microsoft.com/.../dimension-corrections-gl-entries

    Again if on the latest version for dimensions you can restrict selections: docs.microsoft.com/.../more-control-over-settings-default-dimensions

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,043 Moderator on at
    RE: Deleting A Dimension

    Just to add to what Josh i saying.

    You should be aware that the dimension correction tool only correct the dimensions on the G/L entries. If the dimension you want to delete is used on other transactions than G/L entries you will need another method.

  • Talha Siddiqui Profile Picture
    Talha Siddiqui 127 on at
    RE: Deleting A Dimension

    Hey Bruvik,

    Exactly, Have tried Dimension Correction. But that's surely not the solution for what I am looking for. Neither I want to erase Dimensions through each transaction entry.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,043 Moderator on at
    RE: Deleting A Dimension

    I don't think there is any other way than to write some code to delete the dimensions. But at the same time you will have to update all the references to the dimension set to keep your data consistent.  It is doable but it would require some good analysis of your data and how and where your dimension is used. And you would need to test it in a Sandbox of course before you can do it in production.

  • Talha Siddiqui Profile Picture
    Talha Siddiqui 127 on at
    RE: Deleting A Dimension

    Rightly Said. Is there a way to find out where a certain Dimension is been used?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,043 Moderator on at
    RE: Deleting A Dimension

    You can have a look in app source. There are some app's published there that might be able to do what you are looking for.

    appsource.microsoft.com/.../apps

    I think you should look at those who have functionality around dimension correction and see if any of those covers your need first.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,525 on at
    RE: Deleting A Dimension

    Hi

    We did it one time using the following method:

    1) Dimension Manager has a batch navigate change. You need to go the General Ledger Entries. Then filter for the dimension you need, select them all, then use the app (Actions -> VLDM ->Batch Navigate ..). It is important to use Batch Navigate to change all related documents. This way all dimensions for all documents change (invoice, Production order, etc) to new dimension.

    appsource.microsoft.com/.../PUBID.dynamicsnavaddon|AID.dimensionmanager|PAPPID.93678dd0-af16-46ec-a58b-a89808fba8f7

    2) Above action may take long time.

    3) After doing this you should be able to delete the dimension.

    Alternative you can develop a code to does the same method of above app. Basically to find related entries and update those as well.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,202

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,248

#3
Sumit Singh Profile Picture

Sumit Singh 2,893

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans