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!
NSC | Resolve Error: "Field Not Found" when Copy-Pasting formula from SuiteAnswers
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