Month: February 2016

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

Creating a Microsoft SQL Server view from 2 Microsoft Dynamics GP Databases (Video)

In the following video I will show how to create a single Microsoft SQL Server View using 2 Microsoft Dynamics GP databases.

Someone reading my book asked me the following question:

Do you know or can point me in the right direction on how to join or union other company databases? For example we have 4 companies with separate databases and these queries will only pull from one company at a time

In the following video I will show how to create a single Microsoft SQL Server View using 2 Microsoft Dynamics GP databases. Continue reading “Creating a Microsoft SQL Server view from 2 Microsoft Dynamics GP Databases (Video)”