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

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.

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.

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 AR Trial Balance with SQL (with video)

In this video, I create a Summary Aged Trial Balance for Receivables Management using a custom SQL view created by Microsoft Dynamics GP MVP, Victoria Yudin.

In this video, I create a Summary Aged Trial Balance for Receivables Management using a custom SQL view created by Microsoft Dynamics GP MVP, Victoria Yudin. The view can be located on her blog posting below:

Continue reading “Microsoft Dynamics GP – Excel AR Trial Balance with SQL (with video)”

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”