Hey guys, let’s say I have a few thousand lines of...
# general
y
Hey guys, let’s say I have a few thousand lines of Inventory Adjustment records in Netsuite, other than deleting them page by page like the screenshot attached, is there a quicker way to batch delete them in Netsuite? Thanks!
p
Choose the first record you you want to delete click in the memo column on that list (or any inline editable field), then control click or shift click into the memo column entry of other records you want to delete. This will multiple select adjustments in the list. Hit the delete key on your keyboard. wait.
More formal instructions can be found in SuiteAnswers. ID 26816
message has been deleted
y
Hey Patrick, thank you so much for the response. I knew I can delete them using the memo column. But each page has 50 records and we have 10k+ records, meaning we need to delete 200 times. Other than this method, do we have a quicker way to batch delete them?
s
switch the setting on "number of rows in list segment" from 50 to 200 in your personal preferences.
your only other option is to write a suitescript that searches for the transactions and deletes them
y
uh, how should I change the number of records on each page, Simon?
And, if I want to write a suitescript, which API should I use?
s
The setting I mention is in your personal preferences. A suitescript wouldn't use the API as it exists within NetSuite.
y
I believe you’re referring to this one. Once changed, will this change the other accounts’ preferences? The answer is no, I think?
s
it only changes that preference for you, no one else.
👍 1
y
appreciate. that, Simon.
Hi guyes, I got one follow-up question. I changed the preference to 1000 rows per page and perform deletion on these 1000 rows. I am more likely to get errors and ended up with unable to delete these records. Is that my personal issue or is it a common issue?
s
it's a common issue if a related transaction is blocking the deletion of a particular record. It could also be the number of records you're deleting in one go which is why I suggested you set it to 200 in the first place.
y
oh, that makes a lot sense. Thanks Simon