Category: GP Distribution

Microsoft Dynamics GP Dropship Quantity Variance

Handling DropShip variances in Microsoft Dynamics GP.

Originally Posted 10/2/2014

You know I love questions on Microsoft Dynamics GP and recently I was asked the following question:

What happens when the drop-ship item in the SO is for quantity 10 and the vendor sends 11 and the PO invoice is received with 11. The inventory was already sent to the customer; the SOP Entry program will not allow you to change to 11. Since you already received, you cannot change the PO. Any thoughts? 

Inventory

Continue reading “Microsoft Dynamics GP Dropship Quantity Variance”

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

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

Microsoft Dynamics GP–Purchase Order (POP) warning feature (with video)

In Microsoft Dynamics GP there is a little feature with a BIG benefit. You can setup Purchase Order Processing or POP to warn you if you try to close a Purchase Order when there are remaining quantities received but not invoiced.

Originally Posted 11/7/2013

In Microsoft Dynamics GP there is a little feature with a BIG benefit.  You can setup Purchase Order Processing or POP to warn you if you try to close a Purchase Order when there are remaining quantities received but not invoiced.  This can save you a BIG reconciliation headache.

Continue reading “Microsoft Dynamics GP–Purchase Order (POP) warning feature (with video)”

Microsoft Dynamics GP – Excel AR Trial Balance (with video)

This is part 1 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/4/13

This is part 1 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 AR Trial Balance (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”