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
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
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
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
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
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
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
We recently got a call from a customer with a Management Reporter (MR) 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. I had … Read more
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
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
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
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
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
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
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
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
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
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
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
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
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
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