How to Fix “The Record Could not be Deleted Because of an Association” Microsoft Dynamics 365 for Sales Delete Price List Error
How to Fix “The Record Could not be Deleted Because of an Association” Microsoft Dynamics 365 for Sales Delete Price List Error
Find and remove price list associations
This week in Microsoft Dynamics Support, I will show you how to fix a common delete price list error in Microsoft Dynamics 365 for Sales CRM.
Sometimes, when you try to delete a price list, there’s an error saying, “The record could not be deleted because of an association.” The error prevents you from deleting a price list that is in use.
If you see this error and weren’t expecting to, you will need to find where the price list is associated so you can remove any associations and delete the list.
See below for video and instructions:
“The record could not be deleted because of an association.”
If you look at the example above, you will see there’s a price list called “test.” I want to delete this price list, but when I try to delete it I get this error: The record could not be deleted because of an association.
But if you look at this particular record right now, there’s no association for products under Price List Items, and I don’t see any relationship in terms of Territory Relationships. Also, as you can see, the status says “Active.” Usually, active price lists are deletable. So to me, this list seems like it should be deletable.
To fix this particular problem, we need to find out if there’s any other associations and remove the price list from those records.
Find other associations
1.) Go into Advanced Find and set Look for to Price Lists.
From here, you can search the main related entities for the price list: Accounts, Quotes, and Orders. Those are the main entities. Usually, you can find an association in one of them. You can check other entities as well if you don’t find any results.
2a.) Select Accounts and then click on Results.
2b.) Select Quotes and then click on Results.
2c.) Select Orders and then click on Results.
Remove price list from associated records
Once you find your price list associated with an entity, then you need to find the records associated with your price list and change them.
3.) Go into Advanced Find and set Look for to [entity], with Price List equals [price list name].
4.) Click on the record(s) you find there and change the Price list to a different, valid price list.
5.) Save the record.
Once all associated records have been changed, you can come back and delete the price list successfully next time.
Our OnTrack CRM Success System helps you get the most from your CRM investment with support services including:
- unlimited diagnostic support
- unlimited answers to “How do I …?” questions
- annual system audits
- regular progress calls from a dedicated account manager
- + additional valuable services!
We offer OnTrack in both month-to-month or annual subscriptions, and because we stand behind what we do, we offer a 100% money-back guarantee and you can cancel your plan at any time!
Microsoft Dynamics 365 Old Interface is Going Away – Are You Ready?
What does the new Unified Interface mean for you?
Optimize CRM during a Slowdown with These 6 Tips
It’s time to clean your digital house.
3 Simple CRM Strategies to Optimize Your Remote Office During COVID-19
It’s time to reframe what it means to work together.
How to Assign a Security Role to a User in Microsoft Dynamics 365
Assign or change security roles in 6 simple steps
An Easier Way to Boost CRM Value
Introducing Boosters for Microsoft Dynamics 365 and Sage CRM!
How to Avoid Getting Burned with Your CRM Project
No time to burn.
Azamba Consulting Group Announces Gold Sponsorship of Empower Customer Conference 2020
Founder and president Peter Wolf to speak on thriving in the customer experience economy.
How to Create a Dynamics 365 Follow-up Task from an Outlook Email
Never fail to follow up!
Not Ready for the Microsoft Unified Interface?
Reschedule your Dynamics 365 upgrade.
How to Export a List of Contacts and Email Addresses from Sage CRM
A step-by-step guide.
Dinesh Joseph is a Microsoft Dynamics and Sage CRM technical consultant at Azamba. He trains, supports, and consults for both new and experienced Dynamics 365 and Sage CRM users. He also provides analysis and customization for both systems and their integrations.
His goal is to help his customers run their CRM systems smoothly and efficiently.
Related articles:

Microsoft Dynamics 365 Old Interface is Going Away – Are You Ready?
What does the new Unified Interface mean for you?

How to Create a System View in Microsoft Dynamics 365 for Sales
Create an optimal experience for CRM users!

How to Create a Dynamics 365 Contact Record from Outlook Using the Dynamics 365 App for Outlook
Enter new contacts without disrupting your workflow!