Category: Microsoft Dynamics GP
-
Adjustment periods from Microsoft Dynamics GP to Business Central
In Microsoft Dynamics GP, a 13th period is an optional, extra accounting period that some organizations use at year end to post final adjusting entries after period 12 has been closed. This includes entries like audit adjustments, accruals, or reclassifications. The purpose is to allow accountants to finish closing activities and clean up the books…
-
Microsoft Management Reporter End of Live
Every accountant can verify that reports are a necessary evil. Microsoft Dynamic GP first supplemented its internal reports with FRx. Which was transitioned out to Management Reporter to the relief of the GP world? Even experts, such as Mark Polino have written since 2016 about how it is time to rethink Management Reporter. Issues with…
-
Case Study: GplPostBatch Error DBMS:0, Microsoft Dynamics GP 20052
Situation: I have had several clients come to me with the following error: GplPostBatch returned the following results: DBMS:0, Microsoft Dynamics GP 20052. This typically occurs when they are posting a journal entry in the GL or printing an edit list. The one thing that they all have in common is that they used the…
-
Top 5 Window Changes to Microsoft Dynamics GP 2018 R2
Its that time again where Microsoft releases a new update for our beloved product. Here is the countdown of my favorite top 5. 5. Retain the Ship-To-Address with Customer Modifier. In prior versions of Microsoft Dynamics GP, the Ship-To-Address name field was removed whenever a customer was modified with the modifier utility or the customer…
-
SSRS Error: “This page might not function correctly because either your browser does not support scripts or active scripting is disabled”
Recently I have logged into a client’s new server. They recently upgraded and have a new report server. They requested that I edit an SSRS report for them. This was delayed because of the error: “This page might not function correctly because either your browser does not support scripts or active scripting is disabled.” After…
-
SQL Error: “Unclosed quotation mark after the character string”
One of the most frustrating thing that happended to me recently was looking for an unenclosed quotation mark after a character. The error message “Unclosed quotation mark after the character string” appeared when a client ran a Historical Aged Trial Balance for Payables Management in Microsoft Dynamics GP. My initial thought that I would be…
-
Error Tuesday: Workflow errors & EXEC wfDeployClrAssemblies
There are many issues that can occur with workflow within Microsoft Dynamics GP. The first step should always be to run the following script on your database (After a backup). EXEC wfDeployClrAssemblies If this does not resolve your issue, then I would recommend checking your setup. Sometimes a manager will be removed or an email…
-
IT Friday: Top 3 Reasons You Need to use a Phishing Simulators
Despite all your network protections, all it takes is one click from your end user to open your network. Imagine, it is three o’clock on a Friday afternoon. Joe opened his email to check the responses from his clients. He sees an email from FedX saying his tracking number is available. Perplexed, Joe opens the…
-
Error: “You Can’t complete this process while transactions are being edited”
 “You can’t complete this process while transactions are being edited,” is a common error that I see at least 3-4 times a month from various clients. This error can happen on almost any screen or even when you try to exit GP right after you opened the program. Often times if you wait a…
-
Pittsburgh’s Power BI Dashboard in a Day
On March 9, 2018, Microsoft in partnership with Orion Systems Integrators will host another Dashboard in a Day event at its Pittsburgh office. I encourage anyone interested in learning more about Power BI’s business analytics service to monitor your company’s health to attend this event. This hands-on event is a built around a demo environment,…
-
Web Client Error: “A problem occurred creating a session error.”
 I’m sure that this has happened to everyone, you follow the steps and you launch your web client web page. Then, after you log in you receive the dreaded error, “A problem occurred creating a session error.” Often the first response is to repair the web client and proceed to check the local certificate.…
-
Solved: Error: Cannot access this report because the dictionary containing it is not loaded
I’m certain that this has taken place in many businesses. Someone logs in for the day and when they print a report or a check, they receive this error. Or they receive a new computer with a fresh copy of Microsoft Dynamics GP and when they try to print a report, the error…
-
What’s New GP2018: Workflow Features
Microsoft Dynamics GP 2018 was released in December 2017 and new features are abound. One of the most impressive features for me is the changes to the workflow process, which defines how information flows through the system. Workflow 1.0, released with Microsoft Dynamics GP 2013, worked the same as it did in Business Portal without…
-
1095C Old Employees are Populating in Microsoft Dynamics GP
Payroll in January is the most havoc time of year. One common problem I see on the help desk in January is the 1095C printing a form for an employee that has not worked this year or has been inactive since before the current year. To correct this there are two scripts to run. Both…