Dimension Analysis for MDA – SQL View for Microsoft Dynamics GP — GP Life Hacks

I LOVE MDA and apparently, so does Microsoft Dynamics GP MVP, Shawn Dorward.  checkout his blog post below.  He gives away a free MDA SQL View.

I LOVE MDA and apparently, so does Microsoft Dynamics GP MVP, Shawn Dorward.  checkout his blog post below.  He gives away a free MDA SQL View.

Earlier I wrote about how to use MDA for dimension analysis rather than Analytical Accounting. You can find that blog here. To continue that thought, I have created a SQL view to help users get that dimensional analysis data easily! The script captures commonly used data – if you feel I am missing something, please…

Continue reading “Dimension Analysis for MDA – SQL View for Microsoft Dynamics GP — GP Life Hacks”

Using Relative Date Filtering in Microsoft Power BI

In this video, I demonstrate using Relative Date Filtering in Microsoft Power BI. My dataset contains unpaid Accounts Payable invoices and their due dates. I use the Filter options to restrict the visual to display only invoices that are in the next 275 weeks. My sample data is way out in the future, realistically, you would want to see what’s due this week, month, etc.

Check out this blog post from my www.BIBelinda.com blog.

 

Continue reading “Using Relative Date Filtering in Microsoft Power BI”

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

Today we’ll be talking about the new Microsoft Business Summit, and whether it really is the return of Convergence.  You’ll also get to listen in on our sharing how we prepare and come up with topics on which to present.

This podcast was recorded on 4/13/2018.

Listen Here!

Our Sponsor today is PowerGP Online.  Visit their site at PowerGPonline.com

This podcast is the opinions and ideas of three Microsoft MVP’s, who are wrong a lot.

 

MBS Podcast

Today we’ll be talking about the new Microsoft Business Summit, and whether it really is the return of Convergence.  You’ll also get to listen in on our sharing how we prepare and come up with topics on which to present.

This podcast was recorded on 4/13/2018.

Listen Here!

Our Sponsor today is PowerGP Online.  Visit their site at PowerGPonline.com

This podcast is the opinions and ideas of three Microsoft MVP’s, who are wrong a lot.

View original post

27 steps to make you better than 99% of other people — The Better Today Club (Repost)

This is a pretty cool blog post I came across on StumbleUpon, which I like to run through on occasion.  It’s making want to meditate.  

This is a pretty cool blog post I came across on StumbleUpon, which I like to run through on occasion.  It’s making want to meditate.

The world is full of people wanting to improve and be more successful, but who aren´t willing to do anything about it. In many cases, this is due to not knowing what to do or thinking they aren´t good enough. 2,066 more words

via 27 steps to make you better than 99% of other people — The Better Today Club

Mark Polino asks: “Who needs a vacation?”

Historical Excel Reporting for Dynamics GP. Users of Historical Excel Reporting…

I’m telling you, this tools is cheaper than building it yourself.

It’s April and spring keeps trying to break through. If you aren’t thinking about vacation, you haven’t been cooped up long enough. Once you start thinking about tropical beaches and drinks with umbrellas in them, how do you find the time? One option is Historical Excel Reporting for Dynamics GP. Users of Historical Excel Reporting…

via Who needs a vacation? — DynamicAccounting.net

 

 

Microsoft Dynamics GP Navigation Lists

This video shows how to work using the Navigation Pane/Lists rather than using the traditional menu driven method using Microsoft Dynamics GP. It could be a real game changer for you! 

Navigation

Originally Posted 5/23/11

This video shows how to work using the Navigation Pane/Lists rather than using the traditional menu driven method using Microsoft Dynamics GP. It could be a real game changer for you!

Continue reading “Microsoft Dynamics GP Navigation Lists”