Author: Samantha Vislay
-
Top 3 Reasons Your Database Maintenance Utility Won’t Run
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…
-
Change a Vendor to a 1099 Vendor in Microsoft Dynamics GP
We have all been there, a vendor changes their status from being a non-1099 vendor to a 1099 vendor. You can simply go into the vendor card and edit the setting to make them a 1099 vendor. The only problem with this situation is that historical transactions posted in Microsoft Dynamic GP would still show…
-
1095C Form Show Wrong/Incorrect Information
One of my clients had an interesting issue that prompted me to write this article. They have been tracking their ACA information religiously throughout the year. However, when we created the wage file and printed the 1095C to screen, all of the figures were wrong. The last code that they should have used was in…
-
Understanding SQL Tables 101
There are many concepts that are brushed aside as extremely basic. This post is going to be for someone that does not know anything about SQL and may seem overly basic to anyone that already knows about databases. This is the first post in a series and will address database structure. After speaking with several…
-
Useful KB Articles
Here is a list of KB articles I reference. I have these bookmarked and have found them to be extremely useful. General: Microsoft Dynamic GP Directory – Quickest way to locate updates and year end information 888003 – Year-end closing procedures for General Ledger 864652 – The checkbook balance and the general ledger cash account…
-
Excel Report Error: “The SELECT permission was denied on the object ‘accounts’, database ‘MLC’, schema ‘dbo.’”
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…
-
Script error when opening Microsoft Dynamic GP: “An error has occurred in the script on this page”
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…