Troubleshooting: Mismatch Headers

XLANS | Troubleshooting when getting mismatch headers error from CloudExtend

Updated yesterday

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 application 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.

Error Message

Mismatch in headers of saved search and Excel table


Reason of Error

  • User edited NetSuite Saved Search (remove, added, or renamed columns)

  • Two or more columns have the same name

πŸ‘‰ See other common errors encountered when downloading Saved Searches from NetSuite.

How to validate

  • Click preview and the screen is not loading

  • When the saved search is downloaded there is the same name with an added number to it


Resolution

Step 1: Update NetSuite Saved Search and use the custom label or summary label and make field names unique.

Step 2: Manually refresh the data in Excel to get the latest configuration of the saved search from NetSuite.

Did this answer your question?