GP #LifeHacks 113: Resetting Forgotten System Password

Some of the administrator type functions in Dynamics GP use a system password in order to provide a thin layer of protection against unintentional and/or inappropriate use. This password often gets misplaced, forgotten, or just disappears with turnover. I have some good news for you if you fall into this situation… A SQL Script can … Continue reading GP #LifeHacks 113: Resetting Forgotten System Password

GP #LifeHacks 137: Add a SQL View to Smartlist using Designer

Dynamics GP offers a very good tool to create your own Smartlists... Smartlist Designer. One of the cool things users can do is incorporate custom SQL views into Smartlist through SmartList designer... this can be a HUGE time saver and really gives you the ability to get data you would normally not be able to … Continue reading GP #LifeHacks 137: Add a SQL View to Smartlist using Designer

Dynamics GP & Power BI – What it does and how to use it – New for GP2018

Dynamics GP has had a few iterations of its Power BI integration over the years.  I was very excited to see Power BI functionality in GP - this started with ~Dynamics GP 2016.  Despite my excitement, I found it hard to 'get on board' as the functionality was limited and somewhat unreliable.  Microsoft heard our … Continue reading Dynamics GP & Power BI – What it does and how to use it – New for GP2018

GP #LifeHacks 106: Change the Dynamics GP Splash Screen

Changing the Dynamics GP Splash Screen is not only fun and cool (yeah, I said it!) but it is very useful as well! If you are not familiar with a splash screen, Wikipedia describes it like this: A splash screen is a graphical control element consisting of a window containing an image, a logo, and … Continue reading GP #LifeHacks 106: Change the Dynamics GP Splash Screen