Hey there,
We’re working on migrating to Acumatica. We uploaded our stock items, but the move to new system has been delayed, and the data is outdated. I’d like to just mass delete the records, and do a fresh upload, rather than go and update 100’s of products.
How do I mass delete records? Deleting 10,000 products one at a time would take a long time.
Thank you!
Best answer by nassim
Hey
In
Here are all steps:
1- Export records to be deleted ( in my case stock items IN2025PL)
2- Upload it in a data provider ( type excel provider)
3- go on import scenario screen SM206025 and create a new one with your new data provider file
Bilding scenario:
in my case
stock item summery=>inventory ID=> Inventory ID
stock item summery=> <Action: Delete >
stock item summery=> <Dialog answer> => ‘OK’
Then go to import by scenario screen, select your scenario, prepare and import .
here are some screenshots :
+19Hi
https://nexvue.com/acumatica-tips-tricks-how-to-enable-mass-delete-records/
Hey
In
Here are all steps:
1- Export records to be deleted ( in my case stock items IN2025PL)
2- Upload it in a data provider ( type excel provider)
3- go on import scenario screen SM206025 and create a new one with your new data provider file
Bilding scenario:
in my case
stock item summery=>inventory ID=> Inventory ID
stock item summery=> <Action: Delete >
stock item summery=> <Dialog answer> => ‘OK’
Then go to import by scenario screen, select your scenario, prepare and import .
here are some screenshots :
I used this import scenario where I have similar 10k records to be deleted.
I kept running this the whole night it managed to delete only around 900 records.
I saw this link where we can edit the generic enquiry to enable mass delete. Although it is manual I found it quick to do.
Would there be a faster way of doing it by manipulating the generic enquiry?
If not happy using import scenario, I just tested this option, but probably for fewer items:
I realize this is 3 years old and I want to make a recommendation of a best practice. Since stock items are not actually “deleted” from the database when you delete them, I suggest doing a Change ID on each one to a random ID that’ll you’ll never use. I would export the stock items as suggested, create a new column and name is New Inventory ID or something similar. Then delete. What we’ve run into is if you re-create the inventory item with a delete ID it creates problems.
Use this Excel function to create a random alpha-numeric inventory ID.
=TEXTJOIN("", TRUE,
MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789", RANDBETWEEN(1,62), 1),
MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789", RANDBETWEEN(1,62), 1),
MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789", RANDBETWEEN(1,62), 1),
For each MID() function, that’s a character. So if you want to do a 30 character random, create 30 lines of those MID’s. The example above gives you 3-character random inventory ID.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
