GP Support

2017 Sales Tax Changes Take Effect Jan. 1

Posted by Jen Bieker on December 20, 2016

Repost from Avalara Sales tax doesn’t often make headlines, but soda taxes, marijuana sales, tampon exemptions, and online sales tax did in 2016. That trend is likely to continue in 2017. The New Year will bring new taxes, new exemptions, and renewed efforts by states to implement internet sales taxes.…

Read More

Clearing Locks in Dynamics GP Manufacturing

Posted by Carla Duquette on November 10, 2016

Ever hear of database locking?  Microsoft Dynamics GP does it all the time.  Basically, a database will temporarily lock a record while someone is working in it, just to make sure no two people try and change the same record at the same time.  It’s…

Read More

Getting Everyone Out of Dynamics GP

Posted by Carla Duquette on November 4, 2016

Sometimes, it’s important to make sure no one is logged into Microsoft Dynamics GP.  Tasks such as these, require that no one is working with the data. File Maintenance Year-end Close First, you will want to notify everyone that you are going to need them to be…

Read More

Dynamics GP Company Data Archive Error

Posted by Mike Giuffre on November 3, 2016

Recently, we had a client who encountered some errors trying to archive their Microsoft Dynamics GP 2015 R2 system. They have been using the Company Data Archive (CDA) tool; and we don't usually see errors when running it. It had been awhile since this client last ran an archive, and…

Read More

Dexterity Test Mode Lookup Window Error

Posted by Tony Khoury, Senior Consultant on November 1, 2016

I ran across this error the other day when I was in Dexterity Test Mode and opened a lookup window:  Cannot access this form because the dictionary containing it is not loaded. Why?  The problem is that the lookup window is not stored in the Dynamics…

Read More

Management Reporter (MR) Error #3660431 After Starting the DataMart Integration

Posted by David Gigear, Senior Consultant on November 1, 2016

Error 3660431 – “Sequence contains no elements” I’ve seen this error happen a couple times now with both MR2012 CU13 and most recently, with CU15.  The error occurs after starting the DataMart Integration.  So, always make sure to go check the log after you start…

Read More

Dynamics GP Can Help You with New Overtime Labor Rules

Posted by Georgia Stewart on October 26, 2016

If you have Microsoft Dynamics GP Human Resources and Payroll Suite, you’ll want to make sure you are using the “Overtime Rate Manager”.  Starting December 1, 2016 all employers must comply with the Department of Labor (DOL)’s new overtime rules.  This built in feature…

Read More

Dynamics GP & SmartList Builder: Show Invoices within Aging Periods

Posted by Georgia Stewart on September 28, 2016

Have you ever wanted to get a quick look at Microsoft Dynamics GP customer documents ages based on due dates?  Wouldn’t it be great if you could then export that list to Excel?  You can, by using calculated columns in SmartList Builder, which is an add-on…

Read More

Missing Document Attach Paper Clip in Dynamics GP

Posted by Brandon Richards, Implementation Manager on September 26, 2016

We recently assisted a client with an upgrade to Microsoft Dynamics GP 2016.  One of the new features they were excited to use was the Document Attach functionality within various areas of Dynamics GP.  However, during testing, we discovered that the Doc Attach paper clip icon was not…

Read More

Reconcile a Sub-ledger to the General Ledger (GL) in Dynamics GP

Posted by Georgia Stewart on September 21, 2016

Each month our support team receives calls for assisting customers with reconciling a sub-ledger to the General Ledger in Microsoft Dynamics GP. Here are some tips to help you with the reconcile process: Run the Historical Aged Trial Balance for Payables or Receivables (Reports > Purchasing (or Sales) > Trial…

Read More