Some users are reporting that only a splash page appears when trying to load Microsoft Dynamics GP on a Windows server. GP won’t launch or is stuck, and simply hangs there indefinitely. What’s going on? The Problem: Our expert Dynamics GP support team has helped fix this for a couple of our clients now. These … Read more
Posts by 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
Professional Services Tools Library Error with Dynamics GP
Recently when upgrading a GP client from their older version of GP 2015 to the latest GP release, build 18.2.1060, we ran into an error when trying to launch PSTL: We searched and located a new 18.2.4 version of the PSTL tool on the Microsoft Partnersource website that was released in October, but installing that … Read more
Dynamics GP Workflows Not Working with a Gmail Account
As I was working with a client, I experienced an issue getting Workflow Emails to send using a Google/Gmail account. Even though I entered all the necessary account and SMTP information, I couldn’t get the test email to go through the Workflow Setup window in Dynamics GP 2016. No Errors I attempted to send the … Read more
“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
Why is Dynamics GP Taking a Long Time to Switch from One Company to Another & What Can I do about it?
Here’s a true client story and how Crestwood helped. Customer: Lately, we have noticed that the time it takes to switch from one company to another is a lot longer. Is there anything that can be done to improve the amount of time to log on and switch companies? Crestwood: Hi, I wanted to reach … Read more
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
Increase Performance & Speed Up Reporting in Dynamics GP
Are you trying to improve performance of Microsoft Dynamics GP without investing thousands more in hardware and infrastructure? Has your SQL database size started to grow out of control? Perhaps Inventory Reconcile, Check Links, or other maintenance tasks are taking a long time to run due to the growing data volume? Sounds like you need … Read more
Is Management Reporter Dynamics 365 Prompting You for a Username & Password?
We recently got a call from a customer with a Management Reporter (MR) Dynamics 365 issue that I had not run into yet. It happened after the client had installed updates and rebooted their server. They weren’t sure what happened but MR started prompting everyone for a username and password when trying to run reports. … Read more
Integration Manager: Errors When Trying to View Integration Logs
I was helping a client and was trying to determine the problems with Integration Manager (IM). However, when I went to check the log files, I got an error message and couldn’t get to the log files to see the problems. Here is the IM Log Error: Within Integration Manager, I went to view the … Read more
Problems Updating Dynamics GP – Update Process Couldn’t Verify Information
This morning a client got this message on all their Dynamics GP 2018 clients. This is a new one to us, we haven’t seen this error in the past. (Note – this error could apply to almost any version of GP that supports Automatic Updates). “An available update may be required for your computer, but … Read more
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
Microsoft Dynamics GP Document Attach Button is Slow
Have you noticed the Doc Attach button in some companies responds slow? We had a client with this problem. When they clicked the “Attach” button, there was a long delay for the dialog box to appear to allow selection of the documents to attach. We hadn’t heard of this happening and even an online search … Read more
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
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
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
Management Reporter MR Configuration Console Stopped Working
Problem: I ran into a unique issue today. A client had reset their SA password, and after doing so, they could no longer login to Dynamics GP or SQL with the SA password. The SQL SA account kept getting locked out. We determined this was being caused by the Management Reporter (MR) services. When trying to … Read more
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
Dynamics GP SSRS Report Deployment Problems
If you’re trying to deploy SQL Server Reporting Services Reports (SSRS) and it keeps failing, saying you don’t have permission, it might be because you have SQL Express. Dynamics GP Error Message: You do not have security access to the location where you want the reports to be deployed Report deployment with SSRS is NOT … Read more
Dynamics GP Network or Profile Errors, but Not – Mystery Solved!
This is a good one for all you Microsoft Dynamics GP administrators! We have gotten some calls about network or anti-virus type errors in Dynamics GP, but the normal fixes just don’t work. The Errors: Here are the Dynamics GP errors we encountered: FP: Couldn’t close table! An open operation on table ‘taxHistory_TRX’ failed because … Read more
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
Dynamics GP Exchange Email Not Working after Moving to Office 365
Client Issue: We recently had a support case where a client was using one Exchange server, and had just moved their email to Office365. They are using the “Exchange” email option in their environment since they are using Office and Outlook 64-bit. When prompted to login with their Exchange email credentials, they would continue to … Read more
VSS Error When Uninstalling Dynamics CRM 2016
I recently was helping a client who tried to upgrade to Microsoft Dynamics 2016 and had problems. I had to uninstall Microsoft Dynamics CRM 2016 and reinstall Dynamics CRM 2013 first. When doing so, I ran into an issue with the Volume Snapshot Service, also known as the Volume Shadow Copy Service (VSS). What is … Read more