Entering Formulas for a Mass Update
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}. Most common SQL functions and operators are available.
The following are example mass update formulas:
-
To increase customer credit limits by 25%, do a Customer general update, check the Apply box for Credit Limit, and enter this formula: {creditlimit} * 1.25.
-
To set inventory items' preferred stock level to twice the reorder point, do an Inventory Item general update, check the Apply box for Preferred Stock Level, and enter this formula: {reorderpoint} * 2.
Knowledge of SQL will help you to fully leverage the flexibility and power of SQL functions to define complex formulas. For more details, refer to SQL Expressions . Also, you can refer to SuiteScript Supported Records for tables of NetSuite field IDs.