Multi Select in Microsoft Dynamics GP POP Return

Using the Web Client in Microsoft Dynamics GP, I show the new GP2013 feature of being able to select multiple serial numbers using standard Windows commands.

Originally Posted 6/3/2014

Using the Web Client in Microsoft Dynamics GP, I show the new GP2013 feature of being able to select multiple serial numbers using standard Windows commands (CTRL to select non-sequential items and SHIFT to select sequential items.)

Continue reading “Multi Select in Microsoft Dynamics GP POP Return”

Microsoft Excel Power Maps in Power BI

This AWESOME Power BI tool allows you to “Visualize” your data not only in a map, but as a video over a period of time.

Originally Posted 6/2/14

This AWESOME Power BI tool allows you to “Visualize” your data not only in a map, but as a video over a period of time.  It allows you to SEE your data in ways you never even thought amount.  Take a tour with me of Elevator Complaints in New York City for Q1, 2014.

Continue reading “Microsoft Excel Power Maps in Power BI”

Microsoft Dynamics GP – Make Excel Data refreshing easier (video)

This is part 7 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 12/16/13

This is part 7 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 – Make Excel Data refreshing easier (video)”

Microsoft Dynamics GP – Why avoid 3D charts in Excel? (video)

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

This is part 6 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 – Why avoid 3D charts in Excel? (video)”

Microsoft Dynamics GP – Open Purchase Order Table (with video)

This is part 5 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 12/2/13

This is part 5 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 – Open Purchase Order Table (with video)”

Microsoft Dynamics GP – Inventory Item Reorder Dashboard (with video)

This is part 4 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/25/2013

This is part 4 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 – Inventory Item Reorder Dashboard (with video)”

Transfer Inventory to Fixed Assets in Microsoft Dynamics GP

A Microsoft GP User sent me an email asking about how they can consume inventory items for use and how they can transfer inventory items to Fixed Assets. For the second part, I found a fabulous blog posting from my friend and fellow Microsoft MVP, Mariano Gomez

Originally posted August 13, 2013

A Microsoft GP User sent me an email asking about how they can consume inventory items for use and how they can transfer inventory items to Fixed Assets.  For the second part, I found a fabulous blog posting from my friend and fellow Microsoft MVP, Mariano Gomez (the link is below).

Continue reading “Transfer Inventory to Fixed Assets in Microsoft Dynamics GP”

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

Balancing Payables to General Ledger Microsoft Dynamics GP

In this video I walk through the steps I use when I start a project balancing Payables to the General Ledger in Microsoft Dynamics GP.

Originally Posted August 8, 2013

In this video I walk through the steps I use when I start a project balancing Payables to the General Ledger in Microsoft Dynamics GP.

Continue reading “Balancing Payables to General Ledger Microsoft Dynamics GP”

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”