Microsoft Dynamics GP SOP, Which Status Field to use when building reports

When creating reports using Microsoft Dynamics GP Sales Order Processing (SOP) data, there are 8 potential status fields.  Watch the following video to see an explanation of these 8 fields.  In the video, Belinda uses Microsoft Excel and Get & Transform (the tool formerly known as Query Editor to review the SalesLineItems view in GP.

When creating reports using Microsoft Dynamics GP Sales Order Processing (SOP) data, there are 8 potential status fields.  Watch the following video to see an explanation of these 8 fields.  In the video, Belinda uses Microsoft Excel and Get & Transform (the tool formerly known as Query Editor to review the SalesLineItems view in GP.

Since the Early 80’ Microsoft Dynamics GP has been an ERP industry leader.
Since the Early 80’ Microsoft Dynamics GP has been an ERP industry leader.

Continue reading “Microsoft Dynamics GP SOP, Which Status Field to use when building reports”

Overview of Landed Costs in Microsoft Dynamics GP (with video)

This video gives an overview of Microsoft Dynamics GP Landed Costs and their setup. This includes both the Inventory Control and Purchase Order Processing modules.

This video gives an overview of Microsoft Dynamics GP Landed Costs and their setup.  This includes both the Inventory Control and Purchase Order Processing modules.

Continue reading “Overview of Landed Costs in Microsoft Dynamics GP (with video)”

Creating and receiving a Drop ship PO Microsoft Dynamics GP (with video)

One of my clients asked me about cleaning up Drop Ship Purchase Orders in Microsoft Dynamics GP.

One of my clients asked me about cleaning up Drop Ship Purchase Orders in Microsoft Dynamics GP.

Continue reading “Creating and receiving a Drop ship PO Microsoft Dynamics GP (with video)”

Combining Inventory Items with PSTL Microsoft Dynamics GP (with video)

One of my Microsoft Dynamics GP customers had accidentally created two (2) Inventory items for what was actually one item

One of my Microsoft Dynamics GP customers had accidentally created two (2) Inventory items for what was actually one item.  If you end up with duplicate Inventory Items and want to combine, watch this video on how to use the free Professional Services Tool Library (PSTL) to do just that.

Continue reading “Combining Inventory Items with PSTL Microsoft Dynamics GP (with video)”

Using multiple bins in Microsoft Dynamics GP Inventory Control (With Video)

Ever have a hard time trying to find a specific inventory item in your warehouse? If you said yes, you should be using the multiple bins feature in Microsoft Dynamics GP.

Ever have a hard time trying to find a specific inventory item in your warehouse? If you said yes, you should be using the multiple bins feature in Microsoft Dynamics GP.

Continue reading “Using multiple bins in Microsoft Dynamics GP Inventory Control (With Video)”

Using a separate Fulfillment Process in Microsoft Dynamics GP

In this Video I will show the various methods of fulfilling an Invoice in Microsoft Dynamics GP Sales Order processing.

Originally Posted 1/29/16

In this Video I will show the various methods of fulfilling an Invoice in Microsoft Dynamics GP Sales Order processing.

Continue reading “Using a separate Fulfillment Process in Microsoft Dynamics GP”

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

 Watch the following video to see how I suggest handling this situation!