ANS-0025 · SAVED SEARCHES & FORMULAS
How to Resolve ‘Error’ in NetSuite Saved Search Custom Fields?
Custom fields displaying 'Error' in NetSuite saved searches often occur when a default value directly references another custom field that also has a default value calculation.
Short answer
To resolve 'Error' in NetSuite saved search custom fields, modify the default value calculation. Ensure that a custom field's default value does not directly call another custom field that also has its own default value calculation. Instead, reference the base fields or re-calculate the dependent value within the formula.
Scenario
When building a NetSuite saved search, a custom field may display 'Error' as a result. This issue typically arises when the custom field's default value calculation directly references another custom field that also contains its own default value calculation.
Solution
To fix this issue, the default value calculation must be changed so that it does not directly call another custom field which has a default value. Instead, the calculation should reference the base fields or re-calculate the intermediate value within the formula. Example of a problematic setup (will result in 'Error' in saved search):
Cust. field: Allotted Sick Days
Cust. field: Sick Days Taken This Year (hours)
Cust. field: Sick Days Taken This Year || Default value: {Sick Days Taken This Year (hours)} / 8
Cust. field: Remaining Sick Days || Default value: {Allotted Sick Days} - {Sick Days Taken This Year} Example to fix the error:
Cust. field: Allotted Sick Days
Cust. field: Sick Days Taken This Year (hours)
Cust. field: Sick Days Taken This Year || Default value: {Sick Days Taken This Year (hours)} / 8
Cust. field: Remaining Sick Days || Default value: {Allotted Sick Days} - ({Sick Days Taken This Year (hours)} / 8) In the corrected example, the default value of 'Remaining Sick Days' directly incorporates the calculation for 'Sick Days Taken This Year' rather than referencing the custom field itself.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support