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

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:

 

http://victoriayudin.com/2012/01/25/sql-view-for-current-receivables-aging-in-dynamics-gp/

Dashboard for Distribution Series:

 

Part 1:  Microsoft Dynamics GP - Excel AR Trial Balance

 

http://saci.com/blogs/belinda-the-gp-csi/bid/154096/Microsoft-Dynamics-GP-Excel-AR-Trial-Balance-with-video

 

 

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