Tuesday, February 11, 2014

Two different “Tips” for Microsoft Dynamics GP in one Dex.ini line

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!