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”

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

 

 

The Future of Microsoft Dynamics GP

Mark was sharing his thoughts and opinions on the future of the Microsoft Dynamics family.  As much as I respect Mark, I disagree with most of his blog post, even going so far as to state that it has some incorrect facts about Microsoft Dynamics GP that I would like to clear up.

The Future of Microsoft Dynamics GP

Last Friday Morning, as I was returning from GPUG Amplify in Chicago, I read a blog post from my friend and NAV community leader, Mark Brummel, entitled All roads lead to Sweden with Microsoft Dynamics 365 Business Central.

Mark was sharing his thoughts and opinions on the future of the Microsoft Dynamics family.  As much as I respect Mark, I disagree with most of his blog post, even going so far as to state that it has some incorrect facts about Microsoft Dynamics GP that I would like to clear up.

Continue reading “The Future of Microsoft Dynamics GP”

Looking up Microsoft Dynamics GP Accounts by Segment Descriptions (Video)

In this video, I show how to create additional lookup options AND I show how Rockton SmartFill works with Microsoft Dynamics GP.  Check it out!

In this video, I show how to create additional lookup options AND I show how Rockton SmartFill works with Microsoft Dynamics GP.  Check it out!

I saw some great discussion on the GPUG (GP User Group) Forum about looking up Microsoft Dynamics GP GL Account numbers by Segment Descriptions.

In this video, I show how to create additional lookup options AND I show how Rockton SmartFill works with Microsoft Dynamics GP.  Check it out!

Hope this helps!

Continue reading “Looking up Microsoft Dynamics GP Accounts by Segment Descriptions (Video)”