Skip to main content

Notifications

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

Can I delete a bulk of items in the items list?

(0) ShareShare
ReportReport
Posted on by 75

There are around 100 items, in a list of about 1 million, that i would like to delete from the Items List in Business Central. Is there a way to delete these items as a chunk/group/selection, rather than deleting them one-by-one? Deleting 10 already takes a while. What if I needed to delete more than  100, like 1000?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at
    RE: Can I delete a bulk of items in the items list?

    Hi, Inge. Thank you very much for confirming, I tried your method in BC20.5, but only deleted the last one, maybe my test is incorrect?

    pastedimage1664083692667v2.png

    pastedimage1664083699874v3.png

    pastedimage1664083712120v4.png

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Can I delete a bulk of items in the items list?
    [quote user="ZHU YUN"]

    Hi, Inge, as far as I know, this kind of List page with Card page, if you select multiple lines, Delete will be grey out and cannot be selected.

    pastedimage1663718948538v1.png

    No Card page:

    pastedimage1663719029892v2.png

    So I personally recommend using Configuration Package.

    More details: 4 WAYS TO DELETE RECORDS FROM A TABLE

    https://navinsights.net/2020/10/27/4-ways-to-delete-records-from-a-table/

    Hope this helps.
    Thanks.

    ZHU

    [/quote]

     yzhums 

    It is greyed out in the ribbon but delete is available in the context menu that is shown when you select the 3 horizontal dots.

    So go to the context menu and chose select more the first time. When you have selected all you want to delete you go back to the same menu and chose delete.

    pastedimage1663880582853v1.png

  • FJR Profile Picture
    FJR 75 on at
    RE: Can I delete a bulk of items in the items list?

    Thank you, i will try from configuration package as mention from a few other as well in this post.

  • FJR Profile Picture
    FJR 75 on at
    RE: Can I delete a bulk of items in the items list?

    Yes, as Yun mentioned, I tried this way and the delete was greyed out after selecting multiple lines. Thank you though.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Can I delete a bulk of items in the items list?

    Hi,

    Adding more info.

    Yes you can delete those items if you dont have any Stock with any of those items.

    And as other mentioned you can go with Config. Package, or consult with your Developer to create a Batch report to do so.

    Thahnks.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at
    RE: Can I delete a bulk of items in the items list?

    Hi, Inge, as far as I know, this kind of List page with Card page, if you select multiple lines, Delete will be grey out and cannot be selected.

    pastedimage1663718948538v1.png

    No Card page:

    pastedimage1663719029892v2.png

    So I personally recommend using Configuration Package.

    More details: 4 WAYS TO DELETE RECORDS FROM A TABLE

    https://navinsights.net/2020/10/27/4-ways-to-delete-records-from-a-table/

    Hope this helps.
    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Can I delete a bulk of items in the items list?

    From the Item list you can chose select more and mark all the items you want to delete.  You do not have to go through configuration package to do this.

    pastedimage1663706025402v1.png

    If you try to delete items with transactions the system will stop you from doing that.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Can I delete a bulk of items in the items list?

    Be very, very careful. You must do your filters exactly correct.

  • Suggested answer
    RE: Can I delete a bulk of items in the items list?

    Yes you can do it by using the configuration packages in business central

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

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans