I replied to a GPUG question earlier today from someone wanting to use SQL 2016 with GP 2015. It bears repeating here and applies to similar situations as well. When Microsoft says not compatible, they mean it. It may work, but it’s not supported. If you do run into an issue with compatibility down the […]
There is a wealth of information about this, but I have to believe that some people just don’t get it. Let’s start with the easiest, Simple Recovery mode. You only have one choice for a restorable backup, and that’s a full backup. When you back up the database, the log (committed transactions) are truncated, allowing […]
Updated 3/19/2018 to include new findings based on real-world experience, newer Operating Systems, and best practices. I am frequently asked to condense Microsoft’s detailed System Specifications for Dynamics GP. Following is a ‘short list’ of server hardware requirements and recommendations that will give maximum performance at reasonable cost:1. 64-bit hardware platform, Hardware RAID. You want […]
There are several reasons for backing up your Dynamics GP SQL Data and shared files, among them: Business Continuity Human or Computer Error Recovery Historical Preservation Data Health and Maintenance Business Continuity or Disaster Recovery is the most comprehensive and usually requires the most planning. You must consider how much data loss is acceptable and […]
What appears to be a clear question on the surface quickly clouds in the face of reality. Your data is not only important, it’s vital to the life of your business. There are several reasons that I will cover below. Database upgrades complete with no errors. This is the first reason clients think of when […]
“You do not have permission to open this file.” This error is always, always, always in reference to insufficient permissions on a shared folder or file, usually a forms or reports dictionary. This behavior could happen when users are forcibly disconnected from a network resource, or unsynchronized AD Catalog Server permissions are accessed causing a […]
The official System Requirements for Microsoft Dynamics GP 2018 document from Microsoft does not give Network requirements. So some companies may forget to ask or be tempted to think it doesn’t matter. In fact, you must be aware that: Dynamics GP is supported only when client and SQL databases are on the same Local Area Network (LAN). […]
Dynamics GP Process Server, available since the early versions of Great Plains Dynamics, has been pretty much ignored by most of us throughout the years. Yet it can do so much to assist in many situations. Since most GP users (and honestly, many GP consultants) have never heard of Dynamics Process Server, let’s begin by […]
This is an additional post on the perils of network performance, hardware, and file placement as related to Dynamics GP’s client/server processing algorithm. While I could use posting, reporting, or data entry as an example, I will use SmartList as an example, since it provides a generic platform for non-technical analysis. Let’s consider a simple […]