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 – Publish using a custom SQL View

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 – Publish using a custom SQL View

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