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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / What is the best metho...
Small and medium business | Business Central, N...
Suggested Answer

What is the best method to delete multiple (over 1000) stockkeeping unit?

(0) ShareShare
ReportReport
Posted on by MahGah 15,529

Hi

We are in SaaS BC 18.3 

We have created many stockkeeping units by mistake. Now we need to delete them all (we need to keep some but delete the majority of them).

What is the best method to delete them all at once? These are method that I have tried: 

1) I tried to use "Select More" then delete which only delete the first one. 

2) Using Configuration Package. I took out table 5700 then deleted all the lines that I did not need. Then selected "Delete Table Records Before Processing" and upload the package. But I got the following error for those parts that I needed to keep " You cannot change Unit Cost because there are one or more ledger entries for this SKU." 

Thanks for your help 

pastedimage1628086654591v1.png

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    MahGah,

    If you have posted any transactions to the Item SKU, you cannot delete the SKU. This will restrict you from Delete Table Records before Processing. Since you have such a large volume to delete, I would consider asking your partner to help you write a one-time utility to delete those SKU's, from a spreadsheet, as long as they do not have postings.

    Thanks,

    Steve

  • MahGah Profile Picture
    MahGah 15,529 on at

    Hi Steve

    Thanks for your help. For some reason I thought if we have Item Card then create SKU for specific location from Item Card we can delete the SKU. Can you please let me know if this is correct or not?

    Based on info you provided I assume the only way is to ask our partner to design a page that we can access table 5700 and multiple delete from table 5700 ?

    Thanks

  • Suggested answer
    KAHUJA Profile Picture
    KAHUJA 44 on at

    Try just Uploading excel on the package with only one line from an item whose unit cost is not impacting. This will let you delete all records and then you can import fresh records after that.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 on at

    Hi all

    Thank you for your help.

    After trying the following (and failed) we ended up asking our partner to design a page that we can access the table and delete the records we do not need. 

    1) Upload stock keeping with 1 item caused lots of inventory-location issue with items that we had in different locations. 

    2) Cannot upload only stockkeeping items we need and delete rest because of "cost" issue

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans