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!
Search with 2 formulanumeric fields - nlapiSearchRecord
I have a search that has
2 formula numeric fields,
1 formula currency field and
1 formula text field.
When I try to get the data from the formulanumeric field, most of the times I get the value from the second formula numeric field and rarely I get the value from the first formula numeric field. It is not consistent.
Can I have 2 formulanumeric fields on a search and get the data consistently from both the fields?
Are Formula fields officially supported in Suite Script?
memo = searchResult.getValue('formulatext', null, 'group'); type = searchResult.getValue('type', null, null); fund1 = searchResult.getValue('formulanumeric', null, 'sum'); fund2 = searchResult.getValue('formulacurrency', null, 'sum');