top of page

Micro Force -Velosio Newsletter April 2021 - Get the Most from Your Dynamics GP Software System

Updated: Apr 29, 2021


With temperatures slowly warming as Spring moves towards Summer, we continue to look forward to helping both you and your fellow GP users get the most from your Microsoft Dynamics GP business software system. We attempt to do so by providing information about your GP system that you may not be aware of. So read on below to learn about resources and tips that could hopefully permit you to do your job easier and more efficiently.


Integration Manager Update

I’m not sure if you’re familiar with the GP Integration Manager module, but Integration Manager has been a module that has been offered for Dynamics GP for over 20 years. This is Microsoft’s tool that can be used to bring data into Dynamics GP from an Excel file or any other data source.

When Microsoft introduced the new Ribbon command layout as a new feature in GP 2013 R2, it created a problem importing very large files using Integration Manager, and Integration Manager would error out. These errors didn't occur until approximately 1,000 records had been successfully imported, then the integration would fail at the same point every time.

Because IM is at heart a collection of 'macros on steroids', essentially mimicking a user with really fast typing skills, the new button layout doesn't seem to conform completely with the IM Destination Adapters. We recently found out when debugging an issue for one of our customers, that this is also a problem with any third party or custom program that uses macros to input large amounts of data.

The temporary resolution in either case is to change the setting for the window layout in a new area in User Preferences called the 'Window Command Bar'. The default setting is 'Action Pane'. You need to set it to 'Menu Bar' to make IM, or any macros, play nicely with GP.

After changing the setting, log out and back into GP for the setting change to take effect.