# Delete master data

**URL:** <https://www.dynamicsuser.net/t/delete-master-data/51269>\
**Category:** User Forum\
**Created:** [March 4, 2014, 6:13pm UTC](https://www.dynamicsuser.net/t/delete-master-data/51269 "2014-03-04T18:13:24Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![lally](https://avatars.discourse-cdn.com/v4/letter/l/e8c25b/32.png) [@lally](https://www.dynamicsuser.net/u/lally)\
**Post date:** [March 4, 2014, 6:13pm UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/1 "2014-03-04T18:13:24Z")

</div>

Hi All ,

AX 2012 R2

End user created a new main account / vendor / Customer / FA/ bank . Assume that using these data created some financial journals , but not posted . Now end user came to know that the data which had created was wrong . So tried to delete those master data.

An error occur: “A financial dimension value is based on the 1100 record and has been used on a transaction. You cannot delete the 1100 record”

I’ve deleted all Not posted journals those main accounts/vendors / Customers and financial dimensions and all account structures, but still the same error.

Until and unless go to the back end tables , end user can not delete those wrongly created master records.

**Seems to be MS forgot the some basic concepts .**

Just think in a End user point of view , how can user delete the main account / vendor account /Customer account with out going to back end table level as mentioned above ?

Share your experience.

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [March 4, 2014, 7:29pm UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/2 "2014-03-04T19:29:24Z")

</div>

The table structure of AX and the inter-related setup means that you cannot delete all records once you have started.

“When you add new records to financial dimension entities (Main account, Department, Cost center, etc.), they are merely available for use and can be immediately deleted. However, as soon as they are actually used, additional records are created in tables such as DimensionAttributeValue, DimensionAttributeValueCombination, DimensionAttributeLabelValue, and many others. Even if you then delete the journal line that referenced the new Main account, the fact that you have ever used it means that these records will exist forever. AX provides no mechanism for deleting these records. The only method would be with direct SQL, and the schema behind those tables is rather complicated.”

At the point you start creating these records you have taken a forward step, you would need to remove the supporting tables NOT from the UI - it is not a simple job and you need to understand all related tables which is why it needs to be done very carefully.

MS have not forgotten basic concepts here, they are enforcing them, not allowing deletion when supporting table entries exist. Whilst I understand this is an issue from your perspective and they could arguably have coded this better you work with what is there, so now you need to remove the supporting entries by code before deleting those records.

Quote reference: [https://community.dynamics.com/ax/f/33/t/112739.aspx](https://community.dynamics.com/ax/f/33/t/112739.aspx)

---

<div class="post-metadata">

**Author:** ![lally](https://avatars.discourse-cdn.com/v4/letter/l/e8c25b/32.png) [@lally](https://www.dynamicsuser.net/u/lally)\
**Post date:** [March 5, 2014, 5:06am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/3 "2014-03-05T05:06:01Z")

</div>

Thank you steven for the reply,

> [@](#):
>
> so now you need to remove the supporting entries by code before deleting those records.

I am did not understand the above sentence.

Just think in the end user point of view , how can user delete those records without touching the tables ?

As you know that End user does not have the access of AOT to view the tables and delete the records .

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![khan123](https://avatars.discourse-cdn.com/v4/letter/k/f1d935/32.png) [@khan123](https://www.dynamicsuser.net/u/khan123)\
**Post date:** [March 5, 2014, 5:38am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/4 "2014-03-05T05:38:03Z")

</div>

When you add new records to financial dimension entities (Main account, Department, Cost center, etc.), they are merely available for use and can be immediately deleted. However, as soon as they are actually used, additional records are created in tables such as DimensionAttributeValue, DimensionAttributeValueCombination, DimensionAttributeLabelValue, and many others. Even if you then delete the journal line (presumably) that referenced the new Main account, the fact that you have ever used it means that these records will exist forever. AX provides no mechanism for deleting these records. The only method would be with direct SQL, and the schema behind those tables is rather complicated.

---

<div class="post-metadata">

**Author:** ![khan123](https://avatars.discourse-cdn.com/v4/letter/k/f1d935/32.png) [@khan123](https://www.dynamicsuser.net/u/khan123)\
**Post date:** [March 5, 2014, 5:40am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/5 "2014-03-05T05:40:16Z")

</div>

Who is the end user. you mean admin?

---

<div class="post-metadata">

**Author:** ![lally](https://avatars.discourse-cdn.com/v4/letter/l/e8c25b/32.png) [@lally](https://www.dynamicsuser.net/u/lally)\
**Post date:** [March 5, 2014, 7:37am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/6 "2014-03-05T07:37:31Z")

</div>

> [@](#):
>
> Who is the end user. you mean admin?

Hi Faiz ,

Your label shows as E-soltutions **EXPERTS** , but you do not know the who is end user ? Bit funny .

Why did you copy the content of Mr. Steven and posted again ?

---

<div class="post-metadata">

**Author:** ![khan123](https://avatars.discourse-cdn.com/v4/letter/k/f1d935/32.png) [@khan123](https://www.dynamicsuser.net/u/khan123)\
**Post date:** [March 6, 2014, 6:44am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/7 "2014-03-06T06:44:56Z")

</div>

you have to make a utility for this.

---

<div class="post-metadata">

**Author:** ![khan123](https://avatars.discourse-cdn.com/v4/letter/k/f1d935/32.png) [@khan123](https://www.dynamicsuser.net/u/khan123)\
**Post date:** [March 6, 2014, 7:12am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/8 "2014-03-06T07:12:06Z")

</div>

The solution mr . Steven provided you is perfect . In dynamics ax even admin rights also restricted. it is totally depending on how you do setups.

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [March 7, 2014, 7:26am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/9 "2014-03-07T07:26:50Z")

</div>

“Just think of it from the end user point of view” - the answer simply means they cannot do it. The table structure means once created you have gone too far and cannot back out, you need to get people in to remove the entries from the tables.

---

<div class="post-metadata">

**Author:** ![khan123](https://avatars.discourse-cdn.com/v4/letter/k/f1d935/32.png) [@khan123](https://www.dynamicsuser.net/u/khan123)\
**Post date:** [March 8, 2014, 12:45pm UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/10 "2014-03-08T12:45:20Z")

</div>

May i know your build number? join me on skype "faiz\_fais

---

<div class="post-metadata">

**Author:** ![khan123](https://avatars.discourse-cdn.com/v4/letter/k/f1d935/32.png) [@khan123](https://www.dynamicsuser.net/u/khan123)\
**Post date:** [March 9, 2014, 6:14pm UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/11 "2014-03-09T18:14:19Z")

</div>

hi, check your build version. if you want to get rid of this issue, you have to update your build version to this one " #6.2.1000.4051" . for more information read this KB 2885603.

---

<div class="post-metadata">

**Author:** ![lally](https://avatars.discourse-cdn.com/v4/letter/l/e8c25b/32.png) [@lally](https://www.dynamicsuser.net/u/lally)\
**Post date:** [March 19, 2014, 5:01am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/12 "2014-03-19T05:01:21Z")

</div>

HI Faiz,

Thank you for the updates.

Could you share me the link ?

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [March 19, 2014, 2:38pm UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/13 "2014-03-19T14:38:02Z")

</div>

The reference is CU7, can be found here: [https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?WTNTZSMNWUKNTMMYVWQXNRNXTVKNSKYVROSSKZPSPPVYZUQN](https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?WTNTZSMNWUKNTMMYVWQXNRNXTVKNSKYVROSSKZPSPPVYZUQN)

I am not saying it resolves your issue however 🙂

---

<div class="post-metadata">

**Author:** ![lally](https://avatars.discourse-cdn.com/v4/letter/l/e8c25b/32.png) [@lally](https://www.dynamicsuser.net/u/lally)\
**Post date:** [May 8, 2014, 4:20am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/14 "2014-05-08T04:20:41Z")

</div>

Thanks Adam ,

It is not showing any link regarding the master data deletion.

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [May 8, 2014, 8:22am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/15 "2014-05-08T08:22:39Z")

</div>

Faiz said it did, I just pasted the link to the KB [:D] That is the KB he says resolved the issue, I did not read it I just did the search work for you because you could not find the link despite him giving you the KB reference. I would suggest you look at the issue search in lifecycle services, it is very simple to use.

---

<div class="post-metadata">

**Author:** ![erp.jaleel](https://avatars.discourse-cdn.com/v4/letter/e/e5b9ba/32.png) [@erp.jaleel](https://www.dynamicsuser.net/u/erp.jaleel)\
**Post date:** [May 8, 2014, 3:56pm UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/16 "2014-05-08T15:56:48Z")

</div>

Hope it will work if you restor in sql the blank DB with out changing baseline and model store, try this in virtual so that it will be new DB to work.

Hope it works, I have not tested this yet.

---

<div class="post-metadata">

**Author:** ![lally](https://avatars.discourse-cdn.com/v4/letter/l/e8c25b/32.png) [@lally](https://www.dynamicsuser.net/u/lally)\
**Post date:** [May 8, 2014, 6:19pm UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/17 "2014-05-08T18:19:52Z")

</div>

Hi Faiz ,

I have searched for the KB , but did not find .

Could you share the KB URL or hot fix ?

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [May 8, 2014, 11:45pm UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/18 "2014-05-08T23:45:46Z")

</div>

The link I gave you was for the one he mentioned - type it into LCS issue search and it will return it.

---

<div class="post-metadata">

**Author:** ![lally](https://avatars.discourse-cdn.com/v4/letter/l/e8c25b/32.png) [@lally](https://www.dynamicsuser.net/u/lally)\
**Post date:** [May 9, 2014, 3:53am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/19 "2014-05-09T03:53:18Z")

</div>

Thanks Steven ,

I searched the same in LCS , but did not find that KB.

If you find , could you share the link ?

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [May 9, 2014, 7:52am UTC](https://www.dynamicsuser.net/t/delete-master-data/51269/20 "2014-05-09T07:52:27Z")

</div>

I shared it earlier in this post, click on it. The reference is CU7, so Faiz is saying you need to be on CU7 then you will not have the issue. I have not tested this, but you need to. Faiz also said you could contact him by skype in the post, so I suggest you do that if you want any more information from him on this matter.
