Belinda Allen, Microsoft MVP Business Solutions
Things I've learned from years of working with Microsoft Dynamics GP.
This 8-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Employee Maintenance data in Microsoft Power BI.
Part 2 of a 4-Part Series
This 8-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Employee Maintenance data in Microsoft Power BI.
Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 2) in Power BI (Video)”
Last week a Microsoft Dynamics GP user asked a question in the user group form http://www.GPUG.com about obtaining the employee Head Count in Power BI. I offered a suggestion and another user offered a different suggestion. I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant.
Part 1 of a 4-Part Series
Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI. I offered a suggestion and another user offered a different suggestion. I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant.
This 8-ish minute video reviews the Pros and Cons of 3 different method of obtaining the employee head count. I review the method the initial user (who asked the question) used and the two recommendations that another user and I provided.
Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 1) in Power BI (Video)”
Last week, a Microsoft Dynamics GP User (Glenda) asked about making an Excel Refreshable Report refreshable. She not only wanted the table to refresh, but she wanted the associated PivotTable to refresh as well.
Last week, a Microsoft Dynamics GP User (Glenda) asked about making an Excel Refreshable Report refreshable. She not only wanted the table to refresh, but she wanted the associated PivotTable to refresh as well.
Continue reading “Using Microsoft Excel to create a Dynamics GP auto refreshing report (Video)”
Using SmartList to review Microsoft Dynamics GP Bank Transactions with default settings doesn’t provide you with the balance information, for which you are probably seeking. Why? Receipts are included in detail AND as Deposits. How can you remove the receipts from view? Watch this video and find out!
Using SmartList to review Microsoft Dynamics GP Bank Transactions with default settings doesn’t provide you with the balance information, for which you are probably seeking. Why? Receipts are included in detail AND as Deposits. How can you remove the receipts from view? Watch this video and find out!
Continue reading “Using Microsoft Dynamics GP SmartList with Bank Transactions (Video)”
Here’s a great Post from Connecticut based CAL Business Solutions on a new Microsoft Dynamics GP 2018 Analytical Accounting feature!
Copy User access settings in Analytical accounting from one user to another Are you a CAL client interested in installing Microsoft Dynamics GP 2018? Contact us first. CAL Business Solutions 860-485-0910 or support@calszone.com By CAL Business Solutions, Connecticut Microsoft Dynamics GP Partner, http://www.calszone.com Read original post at: HERE
The link to the entire post is below.
With all the reporting options available that can easily access Microsoft Dynamics GP data, it’s time to consider using, if you are not already doing so, the General Ledger Account Category.
With all the reporting options available that can easily access Microsoft Dynamics GP data, it’s time to consider using, if you are not already doing so, the General Ledger Account Category.
Continue reading “It’s time to consider using Microsoft Dynamics GP Account Categories”
Last week a Microsoft Dynamics GP user asked a question in the GPUG (GP User Group) forum, asking how to perform a mass vendor cleanup. Here is a video of how I used SmartList and Integration Manager to perform these mass changes.
Last week a Microsoft Dynamics GP user asked a question in the GPUG (GP User Group) forum, asking how to perform a mass vendor cleanup. Here is a video of how I used SmartList and Integration Manager to perform these mass changes.
Continue reading “Updating Vendor Status using Microsoft Dynamics GP Integration Manager”
Below is a Post from fellow MVP and my Good Friend Leslie Vail. Please note, that in my opinion, using Management Reporter is fine, but it is not the tool I recommend. That being said, this post is not about using Management Reporter, it’s about continuing to use FRx. Later this month, I’ll be highlighting the reporting tool I recommend for Microsoft Dynamics GP.
Below is a Post from fellow MVP and my Good Friend Leslie Vail. Please note, that in my opinion, using Management Reporter is fine, but it is not the tool I recommend. That being said, this post is not about using Management Reporter, it’s about continuing to use FRx. Later this month, I’ll be highlighting the reporting tool I recommend for Microsoft Dynamics GP.
Check out the new Microsoft Dynamics GP 2018 Payables feature.
Check out the new Microsoft Dynamics GP 2018 Payables feature.
Continue reading “Microsoft Dynamics GP 2018 new Payment Feature (with video)”
When creating reports using Microsoft Dynamics GP Sales Order Processing (SOP) data, there are 8 potential status fields. Watch the following video to see an explanation of these 8 fields. In the video, Belinda uses Microsoft Excel and Get & Transform (the tool formerly known as Query Editor to review the SalesLineItems view in GP.
When creating reports using Microsoft Dynamics GP Sales Order Processing (SOP) data, there are 8 potential status fields. Watch the following video to see an explanation of these 8 fields. In the video, Belinda uses Microsoft Excel and Get & Transform (the tool formerly known as Query Editor to review the SalesLineItems view in GP.
Continue reading “Microsoft Dynamics GP SOP, Which Status Field to use when building reports”
Belinda Allen, Microsoft MVP Business Solutions 