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 – Resolve Error: This login failed

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018. To view the full … Continue reading Dynamics GP & Power BI – Resolve Error: This login failed

Dynamics GP & Power BI – How to delete APP registrations

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018. To view the full … Continue reading Dynamics GP & Power BI – How to delete APP registrations

Dynamics GP & Power BI – Connecting GP OData to Power BI Desktop

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018. To view the full … Continue reading Dynamics GP & Power BI – Connecting GP OData to Power BI Desktop

Dynamics GP & Power BI – Configure OData Service in Dynamics GP

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018. To view the full … Continue reading Dynamics GP & Power BI – Configure OData Service in Dynamics GP