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

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

how to delete multiple items, which have no transactions

(0) ShareShare
ReportReport
Posted on by

What's best to way delete the multiple items? I have used Excel to upload the data but it looks like that the items need to be done again. There are no transactions added to any item. I can remove the items one by one but need a way to remove them in bulk to save time.

Thanks in advance for your help!

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,565 on at

    Hi

    Please see this article that describe all possible method (without development) 

    navinsights.net/.../

  • Suggested answer
    Nitin Verma Profile Picture
    21,748 Moderator on at

    Hi,

    Please use the Configuration Package functionality to define the table ID 27 and then delete them, please follow the below link

    community.dynamics.com/.../price-list-sales

  • Suggested answer
    YUN ZHU Profile Picture
    97,433 Super User 2026 Season 1 on at

    As far as I know it is not possible to delete part of the data using Edit in Excel and Configuration Package, this may need to be customized.
    Hope other experts can give you better advice.

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    divyeshchitte Profile Picture
    968 on at

    You have to add Code to delete Multiple Item base on condition

    Below is the code, you can add some more filters based upon your conditions

    CLEAR(Item);

    Item.RESET();

    Item.SETRANGE(Inventory,0);

    IF Item.FINDSET THEN BEGIN

     ItemLedgerEntry.RESET();

     ItemLedgerEntry.SETRANGE(ItemLedgerEntry."Item No.",Item."No.");

     IF NOT ItemLedgerEntry.FINDFIRST THEN

       Item.DELETE(TRUE);

    END;

    Name DataType Subtype Length

    Item Record Item

    ItemLedgerEntry Record Item Ledger Entry

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,153 Moderator on at

    By using the show more options in the item list, you can chose select more. Mark all items you want to delete and then delete them in bulk.

    Definitely the simplest way.

    pastedimage1659655682562v2.png

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,029 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,044 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,026 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans