Using Formulas in NetSuite Saved Search to Concatenate Fields

To concatenate two fields in Netsuite, for example the Order Number and Ship Method, you can use a formula(text) in a saved search. Here is an example of the formula you can use:

CONCAT({number}, ' (', {custcol_ship_method}, ')')

This formula combines the Order Number ({number}) and Ship Method ({custcol_rb_ship_method}) with parentheses and a space in between.

If you want to include a case statement or an if/else statement in your formula, you can modify it as follows:

CASE 
    WHEN {custcol_ship_method} = 'Sea' THEN CONCAT({number}, ' (', {custcol_ship_method}, ')')
    WHEN {custcol_ship_method} = 'Air' THEN CONCAT({number}, ' (', {custcol_ship_method}, ')')
    ELSE CONCAT({number}, ' (Other)')
END

In this modified formula, we use the CASE statement to check the value of the Ship Method field. If it matches 'Sea' or 'Air', we concatenate the Order Number with the Ship Method in parentheses.

Otherwise, we concatenate the Order Number with '(Other)'.

By using these formulas, you can achieve the desired result for your final order number.

For example, if your Order Number is 'PO-RBL-05964-1' and the Ship Method is 'Sea', the final order number will be 'PO-RBL-05964-1 (Sea)'.