Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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 ?