In Microsoft Dynamics GP, users have access to nothing until security access to windows, reports, and files are granted. There are standard Roles and Tasks are the pre-defined set of windows, reports, and files based on the tasks they are granted. Microsoft built the system in a way that allows Administrators to edit the Roles…

Microsoft Dynamics GP Deleting User Error “Deleting the login failed for an unknown reason. Contact your SQL Server administrator for assistance.” Every time I have encountered this is when a user is set up to a specific company database. To resolve this follow these steps: Go to your SQL and verify that the user has…

1. User Training This is probably the biggest item. The worst aspect of CryptoLocker is that they are not actively hacking your network. They are sending spam e-mail or having your user’s go to websites that are not for work purposes and download the installer without them seeing it. Train your users to be wary…

CryptoLocker is the boogeyman of the IT world.  It is a silent predator until you get an error that says your file is not legible.  It affects a multitude of programs.  It also affects Microsoft Dynamics GP.  Typically, when a computer is a victim of CryptoLocker and has Microsoft Dynamics GP installed it will get…

Let’s face it, people like free items.  Free is amazing.  You get something for nothing.  In the case of most businesses, they get more patrons coming into their venue and staying longer when they offer this server.  People stick around longer and potentially spend more money.  Seems like a win, win. In all reality, free…

Direct connection into SQL databases to connect into Microsoft Dynamics GP and also Microsoft Dynamics 365. This product is designed to work with a variety of data sources.  Including Excel, CSV, XML, Access databases, Microsoft SQL Server, MySQL, etc.  If you have data stored, there is a high chance that Microsoft Power BI will connect…

This error has been the most troublesome for me in the past.  Typically of you try searching the error you will get pointed to KB article 943948.   What I have found is that this is caused when you run an integration and Microsoft Dynamic GP seems to disappear and Integration Manager freezes or gets closed…

1.  The utility is run during a SQL server move to verify the database.  This is always necessary when moving clients into a Multitenant move.  I have run into an issue where the version of GP. 2.  The database has an open query in SQL. If you ran a query in SQL and the Query…

In Microsoft Dynamic GP, there is a direct scanning button that is available.  For the direct scan button to activate you must have a WIA driver installed.  If it does not detect the driver it will appear grayed out (as the screenshot above shows). I ran into an issue recently where I needed to have…

With Microsoft Dynamics GP permissions come from two different types of accounts.  There are local accounts and GP accounts.  Local accounts are setup on a domain in Active Directory.  GP accounts are setup within the GP programs. The permissions for excel reports pulls from Active Directory and not Microsoft Dynamics GP.  Specifically, it is an…

A validation report simply shows warnings that you will want to check to verify if information is correct.  I have seen in the past where an SSN number is correct and the number shows that it is wrong. In Microsoft Dynamic GP, the SSN number is verified in the validation report and will provide an…

For the error, “An error has occurred in the script on this page” URL: “https://online.dynamics.com/us/WebResource.axd?d=2eiL_4UDyPKUYbDwJbaFejBYJ44y52hSWZGz5-A7NDC2pVxbl2HB1Ni-” the solution is not within the GP software.  The first time I came across this error and attempted to resolve it, I followed https://support.microsoft.com/en-us/kb/2702223.  None of these solutions fixed the error. Steps I had taken was to proceed to clear…