This is all about how I use GP, based on what I learned in my investigations with clients...

Creating a Microsoft SQL Server view from 2 Microsoft Dynamics GP Databases

Posted by Belinda Allen on Feb 2, 2016 3:40:45 PM

2PuzzlePieces.jpgSomeone 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.

Tags: GP, SQL

Microsoft Dynamics GP - Excel AR Trial Balance with SQL (with video)

Posted by Belinda Allen on Nov 11, 2013 10:00:00 AM

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:

Dashboard for Distribution Series:


Part 1:  Microsoft Dynamics GP - Excel AR Trial Balance



Tags: Receivables Management, SQL, GP2013 Weekly Topics, Excel

Microsoft Dynamics GP The Almighty SQL Server Backup

Posted by Belinda Allen on Apr 17, 2012 4:01:00 PM

Today I walk you through backing up in SQL Server 2008 R2 AND directly in Microsoft Dynamics GP! There are some activities that TRULY need a backup BEFORE you proceed. This video shows 2 ways to achieve successful backups.

This is so important; I felt the need to bring it up again. See Backups? I don't need no stinking backups!! from July, 2010 where I talked about backups!

Tags: Maintenance, SQL