Does the NetSuite Connector support Saved Search Formula Fields?

Document created by anton_serbanescu Employee on Nov 1, 2016Last modified by Adam Arrowsmith on Jun 4, 2018
Version 4Show Document
  • View in full screen mode


Are Formula Fields defined within an existing Saved Search within NetSuite returned when retrieving the search through the NetSuite Connector? 




Formula fields in a NetSuite Saved search can either be used to filter the search data at a finer level, or manipulate it (like date to string) using different types of functions.




An example formula field that converts from character to date is as follows:

   TO_CHAR(\{custrecord_fullname.custrecord_startdate\}, 'YYYYMMDD')


 Note that saved search formula fields are different from Custom fields configured with a formula value.



Currently, as of version 2017.2, the NetSuite SuiteTalk web services API does not support returning saved search formula (nor summary) fields. If/when this is available in the API, Boomi will look to enhance the NetSuite Connector.


The approach at this time is to recreate the formula's logic using a Map Function within Boomi.

3 people found this helpful