How to delete multiple unposted sales invoice at the same time?

(0) Share

Report

Posted on by dkssudgktpdy

Hello,

I've imported several sales invoices to the system but need to delete them as they're no longer needed.

These invoices are only imported, not posted.

Is there a way to delete all of them at once?

There's about 200 invoices so it would be time-consuming to delete them one by one.

Any help would be appreciated!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Rafael Ruiz J 10 on at

Like (0)

Report

RE: How to delete multiple unposted sales invoice at the same time?

Hi Yun, I have used this option for delete records, but when i try it for deleting these records, I get the message:

"A DotNet variable has not been instantiated. Attempting to call Microsoft.Dynamics.Platform.Integration.Office.FilterCollectionNode.Collection in CodeUnit Edit in Excel Impl.: InsertDataIntoFilterCollectionNode"

I am using BC clod version.

any idea?

Thanks!

Was this reply helpful? Yes No
Verified answer

YUN ZHU 92,077 Super User 2025 Season 2 on at

Like (1)

Report

RE: How to delete multiple unposted sales invoice at the same time?

Hi, as Josh Anglesea mentioned, I think the easiest way is to use Configuration Package.

In addition, I think using Edit in Excel is also a good choice.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,217 Super User 2025 Season 2 on at

Like (1)

Report

RE: How to delete multiple unposted sales invoice at the same time?

What Josh mentioned is the perfect one just I will say go with Configuration Package I will say, trick it and its the simplest one.

Was this reply helpful? Yes No
Suggested answer

JAngle 117 on at

Like (1)

Report

RE: How to delete multiple unposted sales invoice at the same time?

Without development there are two ways you can try- providing this isn’t on premise.

Using Power automate. Create a flow where the trigger is a button. Add a step for the http connector. Go to the web services page and get a url for the sales invoices. You need the ID of the invoice - guid. Use that url in the http step. Add a new step using the BC connector and choose the delete record option. Choose the relevant table. Power Automate will add a loop. I have some blogs for working with Power Automate if this is a new area. Link on my profile

Depending on whether you use the sales header for other documents you could use a configuration package. There is an option to delete all before processing. Do a dummy import to trick the tables into having the data deleted.

Failing those there is a deletion tool but it’s development: github.com/.../Data-Deletion-Tool

Was this reply helpful? Yes No