ACA Errors Excel Report GP 2018 Integration Manager Jet Reports Learning SQL Power Bi References Reporting Security SQL Tips & Tricks Uncategorized Web Client Windows 11 Workflow Year End
-
Integration Manager Error: “RPC Server is unavailable”
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…
-
Top 5 SQL Tips for Microsoft Dynamic GP
Think necessity – Only look for the information you really need. The fewer rows that you pull in the quicker your query will be. Keep it simple stupid (KISS) – When you attempt to get fancy with the queries, it can have consequences. Meaning that the queries can take longer and pull unnecessary data. Overcomplicating…
-
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…
Straightforward IT: Expert Guidance to Help Your ERP Challenges 