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

how to delete multiple items, which have no transactions

(0) Share

Report

Posted on by mbharodia

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)

All responses (5)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

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

navinsights.net/.../

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

divyeshchitte 968 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No