Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Cannot Delete Items - At least one BOM Component Includes this Item

Posted on by 27
Hello,

I am currently experimenting with Business Central by routinely adding Items, creating BOMS, and then deleting all items and BOMs. 


Today I deleted some items as normal but then I received an error message for some. It appears that I deleted an assembly item but Business Central retained the BOM details in the BOM Components table (90).  How can I delete these entries from the BOM Component Table? The Parent Item no longer exists, I can't use configuration packages to update because I no longer have anything valid to upload (Can’t upload empty, can’t upload single item because parent doesn’t exist).



Is there a way to manually delete these entries?

Thank you in advance.


Summary for clarity:

- I cannot delete my remaining items.
- There is an item with an assembly BOM that has been deleted, however, I cannot delete the items in the assembly BOM. 
- The items that cannot be deleted are all present in the Component BOM table.
-I have tried using configuration packages to override the component BOM table but the import errors out due to Parent Item already have been deleted.


 
 
 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,822 Super User 2024 Season 2 on at
    Cannot Delete Items - At least one BOM Component Includes this Item
    FIY assembly boms are not sharable between item cards, unlike production boms which are. The bom itself also can't be deleted like a production bom can. The only thing that can be done is delete each line on the bom manually, or delete the finished good item itself. 
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    Cannot Delete Items - At least one BOM Component Includes this Item
    you could try to attach the assembly bom that has this item to another item, then try to delete the bom first before deleting the item.
    it seems the steps you took to delete items might not be following the steps BC like.
     
    Jun Wang
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,822 Super User 2024 Season 2 on at
    Cannot Delete Items - At least one BOM Component Includes this Item
    The method's Yun Zhu provided will work for you. But this is a strange issue, standard BC behavior should also delete the assembly BOM line(s) in table 90 when the assembly item itself is deleted. This is of course if the item is deleted regularly from the item card. Perhaps the item was deleted using configuration packages?
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    Cannot Delete Items - At least one BOM Component Includes this Item
    Hi, hope the following helps.
    4 WAYS TO DELETE RECORDS FROM A TABLE
     
     
    Thanks.
    ZHU

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans