-
Inventory On Hand Report - Excel Web Query
I want to get some NS reports into Excel for external use using the Excel Web Query option. For some reports this works fine, but I have one report for Inventory On Hand by location that has several columns for locations. When I open the web query in Excel the format of this report is different. The columns in NS are…
-
Power Query: Unable to Connect message when accessing a NetSuite Web Query from Excel
I am encountering an issue when trying to use Excel Power Query using the web link from a NetSuite report Web Query. I am able to get several other Web Queries to load properly in Power Query. The correct email address and cr report number are in the URL. I wonder if the file size causes a possible time out error? I am…
-
Why Web Query Report for Inventory does not work?
Hi! A user would like to use MS Web Query to build reports for my inventory but this does not work with item numbers with leading zeros. It works only when they do the Excel save out. Are there any workarounds for this? Thank you!
-
How to Connect Financial Report to Excel and Auto Refresh?
We would like to get the real-time updated income statement report data to an excel sheet in our system. Web Query is not an option for these report Is it possible through an ODBC connection? If we set up the ODBC connection in NetSuite, can we get the updated income statement report details dynamically to our excel? As…
-
How to retrieve reports which have the web query option enabled?
Hello wonderful people, Please let me know whether is possible to retrieve the list of the reports that have the web query option enabled. Many thanks, Have a great day, Edo Aroni