Skip to main content

Hi. I accidentally uploaded 4,000 invoices when I just needed 1. For each line the invoice number had 1 added on to it when I dragged down formula for 4,000 lines, therefore creating 4,000 separate invoices. Is there a way to mass cancel all of them without doing it one by one? Thank you

Hi, 

It kind of depends on the stage where you found the problem. 

If you found the issue within the external supplier invoice process (before the final step create invoices) then simply delete. 

If found after the invoice was created and posted, not so easy.  I have not seen a user function that will allow the canceling of the 4,000 invoices in just a few clicks.  I’ve heard of custom routines clients have created to do this in mass.  

What is the current state (status) of the invoices? 

One thing to consider is to review the external supplier invoice parameters (or basic data) where a load type is defined and the processing options assigned. Maybe don’t automatically create the invoices for this use case. Create a different load type for invoices we can simply load, test and create all automatically for some flavor of invoices, and use a different load type when we really need to stop and review.  This does not help with the 4K invoices, but maybe it will help, some future load. 

Best regards, 

Thomas


Thank you Thomas. The invoices were created and are in preliminary status, not posted. It seems I just need to hire an army to manually delete all these which shouldn’t be too bad just time consuming. I am using I believe a custom upload link (it’s like a blank website where I just drag the file to) and it doesn’t do any checks. It was a careless error by me and once I dragged in the file, the beast couldn’t be stopped.


Reply