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!

New Releases are coming for Dynamics GP!

The MSDYNGP development team has been hard at work.  They have now adopted a 6 monthly release cycle which will bring incremental value to clients on a much more regular basis via their enhancement/maintenance plan.  The team will deliver again in CY2014 with new identity management and workflow capabilities.  In Q4 there will be another major release with more functionality, more workflow, more apps and a Service Based Architecture.  This will be the foundation for the further development of Dynamics GP over the next five years.

 

This year will be a great year for MSDYNGP and our clients!

If you have any questions and/or would like to know more about Dynamics GP, please contact Collins Computing at info@collinscomputing.com or call (800) 943-9211.

March Hotfix & US Payroll Changes

March Hotfix

There are several ROE XML issues as this file format has changed again, all of them will be addressed in the March hotfix and here is the list of ROE issue:

> New ROE does not have the F tag in the XML telling the ROE Web to print ROE in French

> After year edn ROE mark off functionality is not working

> Comments on more than one line in the window Payroll ROE Creation - Canada Box 18

> Payroll ROE Amounts - Canada Box 19 error when date is entered

> The xml is skipping weeks with no activity.  Services Canada made a late change and stated that between periods this was to be indicated by zero's not blanks.

 

US Payroll Changes:
The US Payroll 941 form is changing again for 2014.  The cobra credit fields that were implemented a few years ago are getting removed.
 
US Payroll Tax Update - Round 3

This update is planned.  Currently, Wisconsin is the only state to release changes.  The effective date is 4/1/2014.