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

Shathika Karunaratne 6 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 229 User Group Leader on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,165 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Nitin Verma 21,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
FJR 81 on at

Like (1)

Report
Copy link

Link copied!

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
FJR 81 on at

Like (1)

Report
Copy link

Link copied!

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

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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