Many of us rely on SmartList queries to get financial data out of Microsoft Dynamics GP and into our favorite tool – Microsoft Excel. You probably create a query and run it, but stop it once when you realize you need more than 1000 results. Sighing, you then modify the query to allow for more data and grab a coffee because you know how long it takes to display.
Now you no longer need to wait! Our team discovered a script on a Dynamics GP blog that we wanted to share with everyone. Close out of Dynamics GP and find the dex.ini file in the C:Program Files (x86)Microsoft DynamicsGP2013Data folder on your workstation. Open the dex.ini file and insert the following script at the bottom and save:
This magical script increases the speed of the SmartList export to Excel immensely. Try it! Of course, if you are using queries with thousands of records, you might want to consider another tool like PowerPivot in Excel or SmartView from eOne for faster access to records.
Written by Mary Lenehan, your Chicago Illinois RSM Dynamics Client Manager.