NetSuite Tips & Tricks: Updating an Excel Web Query File

With the new NetSuite updates, it is important to make sure you revise your Excel Web Queries to the new format – or they may stop working! This can easily be done in just a few simple steps. Here we will show you how to determine the original report and then export it as an .iqy file.

How to Update a NetSuite Excel Web Query File for a Report

1. Determining the Original Report
   1. Open the .iqy file using a text editor and find the cr attribute. The ID of the original report will be the same as the cr attribute value.
   2. Click “Reports”, then “Reports Overview” and click on any report to open.
   3. Edit the web page address by including the .iqy file’s report ID in the cr attribute, then hit “Enter”.
   4. The original report for the .iqy should now be visible.
2. Exporting the .iqy File
   1. In the report footer, click the “Export to Excel Web Query” icon. If you do not see this icon, click “Customize”, then “Allow Web Query” in the “More Options” tab, then “Save”.
   2. The report will download as an .iqy file.

Are you taking full advantage of your NetSuite system? BCG Systems is a NetSuite Solutions Provider, contact one of our specialists to see how NetSuite can better benefit your business.

By: Tanya Weatherholt, Business Consultant, ERP/CRM Systems (NetSuite) at BCG Systems, Inc.