Belinda Allen, Microsoft MVP Business Solutions
Things I've learned from years of working with Microsoft Dynamics GP.
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”
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…
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.
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”
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”
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
Thanks Mark, I am going to be testing and playing with the new OData this week, so this was timely! 🙂
Introducing Microsoft Dynamics GP OData Version 4 – Microsoft Dynamics GP Community The original OData release had a few issues so it’s nice to see ongoing updates with this feature. The post Introducing Microsoft Dynamics GP OData Version 4 – Microsoft Dynamics GP Community appeared first on DynamicAccounting.net.
Have you ever needed to compare data in 2 Microsoft Excel Spreadsheets?
In this video, I show how I compare the addresses on the Microsoft Dynamics GP Vendor card with the addresses in the Vendor Address card. One of my followers asked me about this comparison due to concerns that the data imported in each table might not match. I’ll use the Excel Add-on, Inquire, to compare data from each of these tables.
The Spreadsheet Inquire window can compare any Excel files, and do so much more!
Have you ever needed to compare data in 2 Microsoft Excel Spreadsheets?
In this video, I show how I compare the addresses on the Microsoft Dynamics GP Vendor card with the addresses in the Vendor Address card. One of my followers asked me about this comparison due to concerns that the data imported in each table might not match. I’ll use the Excel Add-on, Inquire, to compare data from each of these tables.
The Spreadsheet Inquire window can compare any Excel files, and do so much more!
Continue reading “Compare 2 Microsoft Excel Files using Inquire (Video)”
This 9-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Historical Payroll Checks in Microsoft Power BI.
Part 4 of a 4-Part Series
This 9-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Historical Payroll Checks in Microsoft Power BI.
Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 4) in Power BI (Video)”
This 15-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the General Ledger Unit Accounts in Microsoft Power BI.
Part 3 of a 4-Part Series
This 15-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the General Ledger Unit Accounts in Microsoft Power BI.
Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 3) in Power BI (Video)”
Belinda Allen, Microsoft MVP Business Solutions 