Using In-browser jQuery to Inactivate Items in a NetSuite List

There is currently no native function for a mass update, CSV import, or workflow to inactivate or activate more than one record at a time on a NetSuite item list.

This results in a substantial amount of time spent clicking checkboxes in the list view, which is particularly challenging when inactivating hundreds, or even thousands, of inventory items or tax codes. See Current Method to Inactivate Records.

Marty Zigman wrote an incredibly helpful article outlining a similar issue regarding a Bank Reconciliation Checkbox List jQuery. This tutorial uses similar logic to create a new jQuery line that checks the Inactive box on all list items.

Use the following guidelines to inactivate large quantities of items simultaneously, including:

• Tax codes
• Customer records
• Item records
• Vendor records
• Workflows

Inactivate a NetSuite Item List

Step 1: Access the list of items you want to inactivate or activate.

Step 2: Access the list, or create one through customizing the view with a filter. In this example, filtering for country yields all the UK tax codes.

Step 3: Set the Inactive filter opposite to the desired end result. Filter for all active relevant items, as the jQuery will click the checkbox regardless of whether it is already selected or not. This allows the user to inactivate all currently active items or activate all currently inactive items.

Step 4: Right-click the view and select Inspect at the bottom of the dropdown menu.

Step 5: Navigate to the Console Log section: 

Step 6: Paste the following jQuery line into the Console Log and hit Enter. This will click the checkbox on every line item on the page.

jQuery to copy:

jQuery('#div__body').find('input[type="checkbox"]').each(function() {
   jQuery(this).trigger('click');
});

Step 7: If there are multiple pages of items, navigate to the next page in NetSuite, hit the upward arrow in the Console Log, and press Enter. This will run the query on the second page.

Step 8: To increase records visible on a list, access Home > Set Preferences > Number of Rows in List Segments. Type 500 in the text box and Save.

Step 9: Submit the list once complete. This will save the edits on all the updated records.

Congratulations! You have just inactivated an entire list of items in NetSuite.