Question

Mass deleting records

  • 14 July 2021
  • 2 replies
  • 59 views

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!


2 replies

Userlevel 6
Badge +9

Hi @jsalmont Below article may help you on mass deletion of records. please find the link below

https://nexvue.com/acumatica-tips-tricks-how-to-enable-mass-delete-records/

Hey @jsalmont

 @Naveen B  “ your method is concerned by deleting records by pages”

In @jsalmont ‘s case with 10.000 records or mine with more than 44.000 records, you need to go throw an import scénario.

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 :

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved