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)”

Introducing Microsoft Dynamics GP OData Version 4

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.

via Introducing Microsoft Dynamics GP OData Version 4 – Microsoft Dynamics GP Community — DynamicAccounting.net

Compare 2 Microsoft Excel Files using Inquire (Video)

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!

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)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 4) in Power BI (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.

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. 

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)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 3) 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.

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. 

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)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 2) in Power BI (Video)

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.

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. 

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 2) in Power BI (Video)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 1) 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.

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)”

Using Microsoft Excel to create a Dynamics GP auto refreshing report (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.

Microsoft Dynamics GP User Group.

Continue reading “Using Microsoft Excel to create a Dynamics GP auto refreshing report (Video)”

Using Microsoft Dynamics GP SmartList with Bank Transactions (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!

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)”