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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!