Discussions
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Using ODBC with MSFT Excel Query Builder
I have a report that recently began timing out. Support suggested I use ODBC since there are no timeout restrictions. Yesterday I purchased the ODBC package (Enterprise Reporting) and I'm trying to duplicate the report that was timing out.
The report was a cusomization of the sales by item detail report that included EVERY line of all transactions over a date range. The output columns included 2 fields from about 10 different custom records.
When I use Microsoft Query Builder in Excel to add in the Transactions Transactions_Lines table I can get all my records.
The problem occurs when I need a better decription of my custom record than simply the record's ID. I figured the best way to do this would be to add in the custom record table and link the ID from the Transaction_Lines table to the ID in the custom record table and then add the fields from my custom record table to the output for better descriptions.