One of Collins Computing’s consultants favorite
Smartlist tips from Microsoft Dynamics GP version 2010 and 10 was the trick
that if you wanted to speed up your Smartlist “Export” to excel, just add the
“undocumented” line shown below to your DEX.INI file in the Dynamics “Data”
directory. In fact, my Account Transaction Report with 22,000 records ran
in only 20 seconds AFTER I added the line for a Smartlist that took 7 min 33
seconds to export prior to adding the line.
But in Microsoft Dynamics GP version 2013, the Smartlist processing speed has been improved, and with or without the line, Smartlist exports run much quicker. So, WHY am I still using the DEX.INI line in GP 2013? Well, it turns out that to speed up the export for smartlist processing, the formatting of the exports has been limited. Therefore, my excel exports now always show results up to five decimal places, and for most of the amount fields, our users want to see the results rounded to two decimal places. If I put this same line in the Dex.ini file, the system will format the export, and continue to report in two decimal places!
GP 2013 without Dex.ini line:
GP 2013 with the Dex.ini line:
For additional Microsoft Dynamics GP and
CRM user tips, become a Collins Computing customer - or wet your whistle by
visiting our Collins Computing YouTube
Channel and
then Contact Collins Today! We provide monthly
complimentary customer webcasts for our customers along with quarterly
newsletters with our favorite tips, and customer newsblasts with all the
important news surrounding Microsoft Dynamics.
Existing clients - contact your Collins Account Manager for questions.
Make sure to visit us at Booth 947 at Convergence 2014 next month!
