Author: Samantha Vislay
-
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,…
-
What is Power BI and why do I need it?
Over the past few months, I have spoken with many customers and discussed Power Bi and how it can benefit their company. There is always a push back because people do not believe they need the service or they already had a report for that and it seems too complicated. In retrospect, it seemed complicated…
-
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…
-
Microsoft Dynamic GP Security Overview
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
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…
-
Understanding DELETE Statements
After you are comfortable with selecting information and isolating it, I would then recommend moving on to DELETE statements. You must be cautious when running a delete statement as this will remove data from your system. Because you will be making a change to your data, I always recommend getting into the practice of creating…
-
Understanding the SQL Query Window
Knowing where to look to run a query is also extremely helpful to getting started. There are three locations within SQL Server that you need to be aware of to get started. You can select New Query and this will bring up a new window to type your SQL query. You will see a box…