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

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

(0) Share

Report

Posted on by FJR

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?

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

YUN ZHU 90,557 Super User 2025 Season 2 on at

Like (0)

Report

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?

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

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.

No Card page:

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.

Was this reply helpful? Yes No
FJR 75 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
FJR 75 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,625 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 90,557 Super User 2025 Season 2 on at

Like (1)

Report

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.

No Card page:

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (1)

Report

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.

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 193 User Group Leader on at

Like (1)

Report

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

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

Was this reply helpful? Yes No
Suggested answer

Shathika Karunaratne on at

Like (1)

Report

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

Was this reply helpful? Yes No