![]() ![]() Use Excel to Update NetSuite without CSV, ODBC or Web Services. ![]() Here are a few that may be relevant to you: We have produced a number of innovations around Excel and Google Sheets. How to Connect NetSuite to Excel Web Query (1:13) Accordingly, I present to you a 1:13 video produced by one of our senior consultants for how to set this little known advanced feature up. I suspect many Excel and NetSuite users have not seen this feature - and a little orientation will go a long way. This is where NetSuiteās Report Web Query technology is designed to assist. In this model, the key is to get the data out from NetSuite easily (and I mean no export to CSV and then import). However, it may be possible to have one sheet be your data and another sheet be your report output. Indeed, NetSuite offers little formatting capacities for its Excel report outputs. But then you wanted to get this outcome over and over again without reformatting the sheet every time. Here, the situation is that you exported a NetSuite report to Excel and then you formatted the information to your liking. Since serving the NetSuite community since 2008, and working to produce all kinds of options to work with data to and from spreadsheets, it sometimes becomes easy to forget there are built-in gem-like features offered native that are not utilized. This article is relevant if you are looking to connect Excel to NetSuite Background
0 Comments
Leave a Reply. |