How to TRUELY mass delete records?

You can set up an Import Scenario to delete records.

Hello, here is an example of an import scenario to delete non-stock. Sorry, I don’t have one for stock items handy, but this is quite similar.

laura01 wrote:

Hello, here is an example of an import scenario to delete non-stock. Sorry, I don’t have one for stock items handy, but this is quite similar.

 

Thanks, I can’t seem to find “Non Stock” in Provider, what am I missing?

jamesl wrote:

laura01 wrote:

Hello, here is an example of an import scenario to delete non-stock. Sorry, I don’t have one for stock items handy, but this is quite similar.

 

Thanks, I can’t seem to find “Non Stock” in Provider, what am I missing?

I presume I need to define the provider? What type should I choose?

You can make a provider out of the stock item GI

Hello,

This morning I created a Data Provider and Import Scenario for you, to delete Stock Items.

You will need to import the attached XML in the Import Scenario, remove my file from the related Data Provider, and attach your own Excel file to the Data Provider.  Your Excel needs only one column labeled Inventory ID,  containing your list of 300,000 items to be deleted.

YouTube and Acumatica Open University have videos you can watch to learn about using import scenarios, if you are new.  Good luck!

Hi @jamesl 

here are some screen shots that should help you create the provider:

Hello,

This morning I created a Data Provider and Import Scenario for you, to delete Stock Items.

You will need to import the attached XML in the Import Scenario, remove my file from the related Data Provider, and attach your own Excel file to the Data Provider.  Your Excel needs only one column labeled Inventory ID,  containing your list of 300,000 items to be deleted.

YouTube and Acumatica Open University have videos you can watch to learn about using import scenarios, if you are new.  Good luck!