Straightforward IT: Expert Guidance to Help Your ERP Challenges

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…

  • The Scan button grayed, shaded or unavailable is in Microsoft Dynamics GP

    In Microsoft Dynamic GP, there is a direct scanning button that is available.  For the direct scan button to activate you must have a WIA driver installed.  If it does not detect the driver it will appear grayed out (as the screenshot above shows). I ran into an issue recently where I needed to have…

Design a site like this with WordPress.com
Get started