Category: Tips & Tricks
-
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…
-
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…
-
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 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…