Dynamics GP Error
Avatar photo
Brandon

Dynamics GP and SQL 2019 – Internal error: “An expression services limit has been reached”

With a recent Dynamics GP upgrade, we ran into a unique error message that we had not seen before: This error was appearing in various Navigation Lists in GP 2018 R2 on the latest version.  Examples of Navigation Lists impacted included the following: All Purchasing Transactions Purchase Orders Not Submitted Purchase Requisitions Pending Approval Other … Read more

Read More…

Maximum Users for Dynamics GP
Avatar photo
Brandon

“Maximum Number of Users” Error in Dynamics GP 

We ran into an issue recently where client would receive the following error when logging into Microsoft Dynamics GP even though licenses are available:  “The maximum number of users are logged into the system.”  Clicking OK closes Dynamics GP.  What is also strange is that the “Users Allowed” and “Current Users” fields both show 0.   When logging in with SA, there are … Read more

Read More…

Safety data access, computer network security, user account pass
Avatar photo
Brandon

Troubleshooting User Logins to Dynamics GP

Recently working with a customer we were trying to give a user access to a TEST company in Microsoft Dynamics GP.  When trying to switch to the test company, the user was getting the following error: “The selected company is not configured as a company of the current Microsoft Dynamics GP system database.  You must … Read more

Read More…

ERP
Avatar photo
Brandon

How Does a Microsoft Dynamics GP Upgrade Work?

Microsoft Dynamics GP Upgrade Methodology There’s a reason why our clients trust Crestwood Associates to upgrade their Dynamics GP systems to the latest version.  It’s a complicated process and we’ve done hundreds of them.  Upgrades can take anywhere from 30 to over 100 hours depending on the complexity of your system. So what are we … Read more

Read More…

Avatar photo
Brandon

Crashing and Connection Errors with Management Reporter Console, Dynamics GP, and SQL

Error and fix when your Management Reporter console crashes. This one is great!  My client was having issues with the Management Reporter (MR) Configuration Console crashing as soon as you tried to open it, and the MR Process Service kept stopping after you would start it. I was also getting errors in the Windows Application … Read more

Read More…

Avatar photo
Brandon

Management Reporter (MR) and Dynamics GP Legacy Connection – Caution When Importing a New Company

CAUTION – If you’re using MR with the Legacy connection to Microsoft Dynamics GP, when importing a NEW company to MR, be careful.  You want to make sure you check the boxes for “Skip Import” for all the existing companies that are setup if you are using multiple Building Block Groups (also known as Specification … Read more

Read More…

Avatar photo
Brandon

Tips & Tricks to Make Your SQL Queries Super Fast

The Crestwood Development staff had a recent team sharing session.  One of the things they went over were some great tips and tricks for SQL that we thought you might enjoy too. Index-Friendly Operators If you have indexes in your databases, using index-friendly operators can speed up searching.  Indexes identify what data we really care … Read more

Read More…

Avatar photo
Brandon

SQL Restore is Taking a Long Time

Many of us have run across a situation where a SQL restore just takes FOREVER!  Since I had some time on my hands, I decided to search and found this great blog post by Matt Slocum. Seriously, I waited well over an hour for a 58GB database to restore to SQL 2008 (and the restore never completed, … Read more

Read More…

Avatar photo
Brandon

Dynamics GP Web Services Not Working

Recently, we received a call from a client that their Microsoft Dynamics GP web services stopped working.  Additionally, they weren’t able to get into the Dynamics Security console either. The Problem: When clicking “Select Applications” the message would appear in the lower left corner “Action: In progress…” and nothing further would appear. Browsing to the … Read more

Read More…