Microsoft Dynamics GP – Excel Power Pivot SOP Dashboard (with video)

This is part 3 of a 7-part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Originally Posted 11/18/13

This is part 3 of a 7-part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Continue reading “Microsoft Dynamics GP – Excel Power Pivot SOP Dashboard (with video)”

How to track changes in Payroll in Microsoft Dynamics GP (with video)

Every time I teach a GPUG (Microsoft Dynamics GP User Group) Payroll training class I am asked about how changes to payroll records can be tracked. In this video, I show you how!

Originally Posted on August 9, 2013

Every time I teach a GPUG (Microsoft Dynamics GP User Group) Payroll training class I am asked about how changes to payroll records can be tracked.  In this video, I show you how!

Continue reading “How to track changes in Payroll in Microsoft Dynamics GP (with video)”

AP aging in Excel thanks to Victoria Yudin in Microsoft Dynamics GP

A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP.  There were several great responses to his question, but now I want to add my two cents!

A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP.  There were several great responses to his question, but now I want to add my two cents!

My Friend and fellow Microsoft MVP, Victoria Yudin has made this process a lot easier for you.  She has a SQL view that will organize your open payables and age them for you.

A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP.  There were several great responses to his question, but now I want to add my two cents!

Continue reading “AP aging in Excel thanks to Victoria Yudin in Microsoft Dynamics GP”

Microsoft Dynamics GP User Group (GPUG) Tech Tips Exert

Below is an exert from a future “Tech Tips” that I wrote for the Microsoft Dynamics GP User Group (GPUG) to send to it’s members.  If you are not a member, you should review membership. 

Originally Posed 1/23/13

Below is an exert from a future “Tech Tips” that I wrote for the Microsoft Dynamics GP User Group (GPUG) to send to it’s members.  If you are not a member, you should review membership.

 

Continue reading “Microsoft Dynamics GP User Group (GPUG) Tech Tips Exert”

Microsoft Dynamics GP Prepare for your 1099’s

November/December is the perfect time to start preparing for those pesky, yet required 1099’s in Microsoft Dynamics GP.

Originally Posted November 9, 2011
 First step is making sure you have a Tax ID for all your 1099 vendors. In this video I’ll show you how to:

Continue reading “Microsoft Dynamics GP Prepare for your 1099’s”

Microsoft Dynamics GP Payables Management Batch Review using Excel

The attached videos and steps show how to use Microsoft Excel to check unposted Payables entries along with their distributions for Microsoft Dynamics GP.

Originally Posted October 14, 2011

The attached videos and steps show how to use Microsoft Excel to check unposted Payables entries along with their distributions for Microsoft Dynamics GP.

Continue reading “Microsoft Dynamics GP Payables Management Batch Review using Excel”

Microsoft Dynamics GP Source Documents and Audit Trail Codes

Let’s talk about the Source Document and Audit Trail in Microsoft Dynamics GP posting:

Originally posted 9/27/2011

Let’s talk about the Source Document and Audit Trail in Microsoft Dynamics GP posting:
• Where is created?
• Where is it used?
• Why is an audit trail code important?
• How can I use the Source Document code in Smartlist?

Continue reading “Microsoft Dynamics GP Source Documents and Audit Trail Codes”