Author: Samantha Vislay
-
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…
-
Security Mishap Friday: Hackable Passwords Part I
Password security is something everyone always hears about. Make sure that you have a strong password. Weak passwords are hackable. What I find that is not mentioned enough is what constitutes as a strong password is constantly increasing as hackers get better. 15 years ago they recommended adding uppercases to lowercases. 10 year ago they…
-
Proactive Not Reactive: Top 10 ideas to Protect Yourself From CryptoLocker
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 and Microsoft Dynamics GP
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…
-
Security Mishap Friday: The Fake Wi-Fi Scam
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…
-
SQL Saturday
Learning SQL and becoming involved in the technical community can be difficult if you do not know where to look. A fantastic event that encourages people of all ability levels is through PASS. PASS is an independent, not-for-profit organization run by and for the community. One event that they offer for each of their communities…
-
Top Reasons To Love Microsoft Power BI
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…
-
Business Intelligence: When Standard Reporting Is Not Enough
It should be no surprise to anyone that we are living in a digital world and data is being kept on the most mundane items. Especially in every aspect of a business. Once a business creates data, it needs to be able put it together in a meaningful, productive way. Reports once filled this void. …
-
Understanding SELECT Statements
The first time anyone looks at SQL can be overwhelming. Mostly because it is like learning a foreign language. You need to learn the vocabulary and the syntax to get what you want. The first step to learning should be how to navigate information. In my examples, I will be using examples from Microsoft Dynamics…
-
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…