MBS Podcast #002: Presenting Convergence… Yeah, you’ll understand after you listen.

Mark, Belinda and Shawn (That’s me!) share our thoughts on the new upcoming Microsoft Applications Business Summit – is it the new Convergence?  Find out who will attend, potential content for sessions and what our general thoughts are on this new conference!

Da-55qmVQAAHYM9.jpg

We also share our experiences and techniques in prepping for presentations that we do throughout the year… and our podcast wouldn’t be complete, with poking fun at each other along the way.

I hope you enjoy it!


Title/Link Presenting Convergence… Yeah, you’ll understand after you listen.
Podcast Number 002
Recorded Date 04/13/18
Release Date 04/17/18
Our Sponsor PowerGP Online

Thanks for reading!

Shawn


Shawn Dorward

Microsoft MVP, Business Solutions

GPLifeHacks.com | LinkedIn | Twitter | GPUG | MSDYNGP

GP #LifeHacks 101: Use dimensions WITHOUT Analytical Accounting! MDA to the rescue!

AA (Analytical Accounting) provides the ability to add additional details to transactions without adding new segments to your chart of accounts.  It does a lot of other ‘fun’ stuff, but before you dive into the deep end… consider an alternative… consider Multidimensional Analysis (MDA for the acronym fans out there).

Once thought to be removed from Dynamics GP (and maybe even some folks still believe it is not in GP), MDA lives and breathes in Dynamics GP and is an underutilized feature… so let’s take a look at this functionality!

What is MDA and how does it work?

Continue reading “GP #LifeHacks 101: Use dimensions WITHOUT Analytical Accounting! MDA to the rescue!”

GP #LifeHacks 110: Post Financial Transactions to History

Does this sound familiar?  “I can’t close my fiscal year yet… the audit is not finished.”

Closing a fiscal year in Dynamics GP does a few things, but in particular, it closes the Profit and Loss account balances out to the retained earnings account.

Many customers fear closing their fiscal year because their previous years work is not complete.  This causes complications with summary windows as well as with Financial Reporting.

I believe, in most cases, that the fiscal year can be closed right on schedule… just like closing any other month… no need to wait… no need to rebuild reports to create a make shift ‘balance brought forward’.  Just use the ‘Post to History’ functionality.

Let’s take a brief look at this…

Continue reading “GP #LifeHacks 110: Post Financial Transactions to History”

MBS Podcast #001: Are your ready for GDPR?

mbspodcastYours truly joined up with fellow Microsoft MVP’s, Mark Polino & Belinda Allen, and started a podcast.

We talk about Microsoft, Business and @&$#! (Stuff!)

Today we talk about GDPR (General Data Protection Regulation) – we don’t know much, but we sure do like to talk about it 🙂


Title/Link Are you ready for GDPR?
Podcast Number 001
Recorded Date 03/16/18
Release Date 03/26/18
Our Sponsor FastPath

Thanks for reading!

Shawn


Shawn Dorward

Microsoft MVP, Business Solutions

GPLifeHacks.com | LinkedIn | Twitter | GPUG | MSDYNGP

Dynamics GP & Power BI – An Error Has Occurred In The Script On This Page

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 list of the series, click here.

How to resolve “An error has occurred in the script on this page.” Error when hovering over Power BI within Dynamics GP

Continue reading “Dynamics GP & Power BI – An Error Has Occurred In The Script On This Page”

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 be used to reset the password.

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 get in a normal Smartlists.

Below are the steps needed to add a SQL View to your Smartlists.

Continue reading “GP #LifeHacks 137: Add a SQL View to Smartlist using Designer”

Looking for the MS Connect replacement for Dynamics GP?

The MS Connect site, which was the one-stop repository for ideas/suggestions/bug fixes relating to Dynamics GP (among other things) was retired not too long ago.

Since then, I have had many discussions, online and in person, regarding its replacement. And so far, the replacement was ‘in the works’… until now.

Continue reading “Looking for the MS Connect replacement for Dynamics GP?”

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 list of the series, click here.

How to resolve “This login failed. Attempt to login again or contact your system administrator” error when connecting to Client ID

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 list of the series, click here.

How to delete APP registrations

Continue reading “Dynamics GP & Power BI – How to delete APP registrations”