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

Question/Issue

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

 

 

Details

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.

 

References

 

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.

 

Solution

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

Attachments

    Outcomes