For mass updates that are General updates, you can update multiple fields per record. You select the fields to be updated on the Mass Update Fields subtab of the mass update page, by checking the Apply box. For each selected field, you can enter a static value to use for updating the field in all records, in the Value field. Or, if you want to update a field based on dynamic values, you can enter a SQL expression in the Formula field. You can enter SQL directly in the Formula field, or click the Set Formula button to display a popup formula builder.
Formula values are dynamically calculated at the time a mass update is performed. Formulas can include NetSuite field IDs for which field values are substituted, SQL functions, and mathematical operators. NetSuite field IDs should be formatted as follows: {field_name}.
Example mass update formula for Concatenate two item fields to a custom record field:
Go-to list->Mass update → Mass Updates-> General Update
select Product list item record
Apply the formula after selecting the sort option
CONCAT({custrecord_ns_pl_pli_item.department},{custrecord_ns_pl_pli_item.custitem_product_category})above Formula used for concatenating Two item fields
Click Preview to verify which records the custom mass update will apply to.
Click Perform Update to run the custom mass update.