Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Problem using a formula in a transaction saved search
Hello Everyone,
I'd like to use "REPLACE" formula in a sales order saved search on the Customer Part number field, to basically get rid of "_" characters.
To achieve that I tried on the result tab of the saved search to add the following formula(text): REPLACE({custcol_scm_customerpartnumber},'_','').
It does not give an error but the result is an empty cell.
To make sure this formula would work I tried on a Customer PArt Number record saved search (instead of transaction), and it worked :
Can anyone guess what the problem could be? Is that because the formula is requested on a transaction line when it fails and on a record when it works ?
0