Scenario
User creates a saved search and is copy-pasting the formula provided in SuiteAnswers. However, when the search is ran, it returns ERROR: Field Not Found for that column.
Solution
Normally, if a copy-pasted formula doesn't work, it means that there is something wrong (like incorrect spelling or symbol) or something missing (like parenthesis or comma).
Some might have encountered this before with the apostrophe and single quote symbols. If the formula was typed in MS Word wherein the ' symbol is treated as an apostrophe, and is considered invalid in SQL formula (single quote symbol works).
But if those were already ruled out, then there might be a hidden character in the formula, or something that can't be seen by the naked eye.
If ever you encounter this error, what you can do is to do quick online search for hidden character checker, and paste the formula that returns the error there. Most likely, there is a hidden character after the first { of the field ids.
If you encounter this behavior again, you can try to manually enter the formula using the field selector (Saved Transaction Search / Field / Item Fields... / Item Field list).
We also suggest leaving a feedback in the SuiteAnswers article so that this can be corrected.
-----
If you find this information useful, let us know by reacting or commenting on this post!