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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Can't Delete an It...
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member

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

 

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,668 Super User 2026 Season 1 on at

    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

  • Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    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.

  • Community Member Profile Picture
    Community Member on at

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

  • Community Member Profile Picture
    Community Member on at

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

  • Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    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.

  • Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

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

  • Community Member Profile Picture
    Community Member on at

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

  • Verified answer
    5400 Profile Picture
    5400 7,162 on at

    Hi,

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

    It should solve your problem.

  • Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    Yep those retail price groups :-)

  • Suggested answer
    Abhishek D Divekar Profile Picture
    Abhishek D Divekar on at

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

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

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans