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!

All responses (5)

Answers (0)

Suggested answer

Inge M. Bruvik 1,011 Moderator on at

Like (0)

Report

RE: how to delete multiple items, which have no transactions

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.
Suggested answer

divyeshchitte 950 on at

Like (0)

Report

RE: how to delete multiple items, which have no transactions

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

YUN ZHU 81,217 Super User 2025 Season 1 on at

Like (0)

Report

RE: how to delete multiple items, which have no transactions

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

Nitin Verma 21,544 Moderator on at

Like (0)

Report

RE: how to delete multiple items, which have no transactions

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

MahGah 15,437 on at

Like (0)

Report

RE: how to delete multiple items, which have no transactions

Hi

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

navinsights.net/.../