CloudExtend Excel Analytics runs your NetSuite searches using SuiteScript. SuiteScript supports the vast majority of searches created in the UI with a few exceptions we have uncovered.

Open Issues

Criteria with null values

There is a NetSuite bug that prevents criteria such as Name/ID starts with " " from to fail when call via a NetSuite API. It will result in an error message similar to "An nlobjSearchFilter contains an invalid operator, or is not in proper syntax". The workaround is to remove this line from your saved search.

Criteria based on summary formulas

This is not a bug per se, but something you should be aware of. If you're using the Summary Criteria in your NetSuite saved search the field in your formula must also exist in the results. For example, the formula below references the transaction date from the from the fulfilling transaction. That same field must be added to your results set or you will receive a NetSuite error "An nlobjSearchFilter contains an invalid summary type: formulanumeric: SUM."

Sum 'Percent' formulas cause 'Unexpected Error'

There is a NetSuite bug that causes searches that use Formula (Percent) to fail when called via a NetSuite API. The workaround is to change the formula to numeric.

Adding / Removing / Renaming Columns causes scheduled searches to fail

Log files show "Mismatch in headers of saved search and Excel table"

Note, if you have a search running on a schedule and you subsequently add/remove or rename columns in the search (via NetSuite UI) your searches will fail until you manually rerun them in the app at least one time. This is required in order to ensure that formulas are not broken by a scheduled search and that the user has an opportunity to fix them prior to the next scheduled run.

Resolved Issues

The issues below were reported by beta customers and resolved.

Formulas

Formulas that reference the tables created are currently wiped out when the table refreshes (this does not affect pivot tables). We have a fix for this planned were a table will only be recreated if new columns have been added.

Update June 10, 2021 - RESOLVED by removing data from table and then updating it. If users subsequently add or rename columns in the NetSuite search then the entire table does need to be recreated and formulas may be impacted. In such a scenario the user is warned prior to the replacement of the table.

Storage Locations

In order to run your searches on a schedule, the files must be accessible online, either on SharePoint or on OneDrive for Business. At present only OneDrive for Business is supported.

Update April 20, 2021 - RESOLVED (support for SharePoint 'sites' added)

Sandbox

The app is not yet working in sandbox accounts.
Update - April 8, 2021 - RESOLVED

Deleting searches

The app does not yet support removing searches from the add-in.

Update April 20, 2021 - RESOLVED

Long search names and names with special characters issue 1

CloudExtend names the worksheet in your workbook using the name of your saved search. Excel has a limit of 30 characters and at present those searches are failing without warning because the sheet cannot be added.

Update April 20, 2021 - RESOLVED

Long search names and names with special characters issue 2

Searches with certain special characters such as / are also failing when we attempt to create the worksheet using the special character as part of the name.

Update April 20, 2021 - RESOLVED

Did this answer your question?