Skip to main content

Notifications

Microsoft Dynamics AX forum
Answered

Can't Delete an Item due to dependent Price Groups in AX2012 R3

Posted on by Microsoft Employee

Hi,

I am trying to delete an Item incorrectly set up in AX2012 R3 & then recreate it correctly.

I am getting the following message.

'Items cannot be deleted while dependant Price group items exist. Delete dependant Price group items and try again.'

I have checked and there are no set ups for this Item in any Price Group and there have been no transactions done either.

Anyone come across this issue previously.

Rgds

Baxter

 

  • Suggested answer
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    My Same problem is solved from MCRPriceHistory table. I have deleted item from the MCRPriceHisotry table.

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    Yep those retail price groups :-)

  • Verified answer
    5400 Profile Picture
    5400 7,160 on at
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    Hi,

    you have to check MCRPriceDiscGroupItem table not PriceDiscTable table.  Please check any records exist in MCRPriceDiscGroupItem.

    It should solve your problem.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    Hi, yeah have been looking at the table in AOT alright.

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    I presume you are looking in the table, and not from the form - it maybe a corrupt entry and not visible from the form.

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    You will need to debug to get the specific table I am afraid. There is an entry in a related item in a table and it needs to be removed. Trying to search my email history to find the details, but no luck.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    Thanks for the 2 replies, But there was no records of this Item in the Retail Price Groups side either.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    Thanks for reply.  No there are no records for this Item there.

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    Go to the Retail module and look at the price groups there - I have a memory that it will write pricing to retail at item creation depending upon the configuration, you need to delete those elements first.

  • sohaibcheema Profile Picture
    sohaibcheema 46,594 User Group Leader on at
    RE: Can't Delete an Item due to dependent Price Groups in AX2012 R3

    the error message is showing as its a result of delete action.

    you can manually  verify by going into AOT>> Data Dictionary >> Tables >> PriceDiscTable

    check if there are records for sure item cannot be deleted in that case, unless records are removed.

    Note: checking records never means, delete from table. if you find records in table, delete those from appropriate forms

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans