Month: February 2018

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

Pasting an Excel sheet into Word not just Microsoft Dynamics GP data

Today’s posting is specific to Microsoft Office only, particularly Excel and Word.

When meeting with a customer yesterday, he mentioned having problems copying Excel spreadsheets into Word. When she chose to copy, the formatting was lost. She liked using the “Track Changes” feature for reviewing documents and information in Microsoft Word.

Today’s posting is specific to Microsoft Office only, particularly Excel and Word. When meeting with a customer yesterday, he mentioned having problems copying Excel spreadsheets into Word. When she chose to copy, the formatting was lost. She liked using the “Track Changes” feature for reviewing documents and information in Microsoft Word.

Originally Posted 8/23/2012

Today’s posting is specific to Microsoft Office only, particularly Excel and Word.

When meeting with a customer yesterday, he mentioned having problems copying Excel spreadsheets into Word. When she chose to copy, the formatting was lost. She liked using the “Track Changes” feature for reviewing documents and information in Microsoft Word.

Continue reading “Pasting an Excel sheet into Word not just Microsoft Dynamics GP data”

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