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!
How to resolve Error: "Field Not Found" when referencing Item fields in Saved Searches?
Hello,
I'm trying to follow SuiteAnswers Article ID 37706. It suggests the following formula:
case when {item.inventorylocation} = 'THM - DC' then {item.locationquantityavailable} else null end
But the Saved Search returns ERROR: Field Not Found for that column.
When creating the formula, these fields were selected from the Saved Transaction Search / Field / Item Fields... / Item Field list.
Not sure why the fields are selectable to insert into a formula but then not found when used?