Microsoft Dynamics GP Payables Holds

This video discusses Vendor Holds and Microsoft Dynamics GP Payables Invoice Holds. It also uses SmartList to help manage holds.

Originally posted 3/2/11

This video discusses Vendor Holds and Microsoft Dynamics GP Payables Invoice Holds. It also uses SmartList to help manage holds.

This is a reposting as my blog URL has changed since it was originally posted.

Continue reading “Microsoft Dynamics GP Payables Holds”

Oh Magic Wizard, grant me a Microsoft Dynamics GP MR report

This video walks through creating a report in Microsoft Dynamics GP Management Reporter using the Report Wizard.

Originally posted – 2/25/2011

This video walks through creating a report in Microsoft Dynamics GP Management Reporter using the Report Wizard.

This is a reposting as my blog URL has changed since it was originally posted.

Continue reading “Oh Magic Wizard, grant me a Microsoft Dynamics GP MR report”

From Sean Dorward: Unable to connect to the PowerBI Site to your Microsoft Dynamics GP

The following is a terrific post from Microsoft Dynamics GP MVP, Shawn Dorward.

The following is a terrific post from Microsoft Dynamics GP MVP, Shawn Dorward.

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…

via Dynamics GP & Power BI – Unable to connect to the Power BI site. Contact your system administrator. — GP Life Hacks

Microsoft GL Actual compared to Budget Dashboard using eOne Excel Builder and Excel in 23 minutes! (with Video)

In the attached 23-minute video, I walk you through the process of using eOne Software’s Excel Builder in Microsoft Dynamics GP and Excel to create a dashboard to assist in budget to actual comparisons.

If you create budgets, you’ll need to compare them to actual numbers to see how close you are coming to your estimates/forecasts/budgets.

If you are holding Department Heads/Managers accountable to budgets, they need to review how they are doing along the way.

In the attached 23-minute video, I walk you through the process of using eOne Software’s Excel Builder in Microsoft Dynamics GP and Excel to create a dashboard to assist in budget to actual comparisons.

Continue reading “Microsoft GL Actual compared to Budget Dashboard using eOne Excel Builder and Excel in 23 minutes! (with Video)”

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

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”

Microsoft Connect Replaced with Microsoft Dynamics Ideas

Post from Mahmood M. AlSaadi: The new MS Connect website has been released recently providing spaces for ideas, blogs, trials, help and roadmap for Dynamics 365 and Dynamics GP. Yes, Dynamics GP is part of the new portal and it is not going away.

Mahmood
Posted at SIROCo
Posted on 3/23/18

The new MS Connect website has been released recently providing spaces for ideas, blogs, trials, help and roadmap for Dynamics 365 and Dynamics GP. Yes, Dynamics GP is part of the new portal and it is not going away.

As published by the Microsoft Dynamics GP Support and Services blog, it was addressed that

“Have no fear, the end is nowhere near for Microsoft Dynamics GP. We are back in business, you have an IDEA? We want to hear it. The MS Connect site was decommissioned before the new site was ready so I know you are eager to start entering all your feedback for Microsoft Dynamics GP. We have a new release targeting for the end of the year so now is the time you should enter those fabulous new product ideas you want to see in the software you use and love every day!!”

See the full post using the link:  Full Post