Microsoft Dynamics AX (Archived)

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

(0) Share

Report

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)

All responses (10)

Answers (1)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

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

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

5400 7,162 on at

Like (2)

Report

Hi,

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

It should solve your problem.

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

Yep those retail price groups :-)

Was this reply helpful? Yes No
Suggested answer

Abhishek D Divekar on at

Like (0)

Report

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

Was this reply helpful? Yes No