NetSuite allows for prefixes and suffixes to be automatically added to transaction numbers. For example, invoice number 65321457 can have a prefix of "INV" resulting in invoice number INV65321457. As a result of this a global search for 65321457 will fail to find any matching records, even in the NetSuite UI.

Recommended Solution

To overcome this limitation admins can now enable a search prefix or suffix such as “%” that CloudExtend would use during the global search. Adding a wildcard prefix such as % to the search will surface the desired records. In the example above %65321457 will surface invoice INV65321457.

To do this a NetSuite admin should follow the steps below.

  1. Locate the Celigo Global Search deployment (Customization->Scripts->Script Deployments
    To make it easier to find filter on type = Restlet and API version = 2.0.

  2. Edit the deployment and select the parameters tab.

  3. Under search term template enter the desired wildcard. Always be sure that {term} is included. This will hold the data used in the global search. In the example above the % sign is the prefix and 65321457 is the term. CloudExtend will then initiate a global search with %65321457. If you wanted to add the % as a suffix you could enter {term}%.

Did this answer your question?