Microsoft Dynamics GP Revenue/Expense Deferrals

Here I’ll show you how easy it is to defer Revenue over a specified period of time in Dynamics GP. I’ll setup a Deferral Profile to make a template for commonly used deferrals. No more manually deferring, let GP do it for you!

Originally Posted 8/23/11 

Here I’ll show you how easy it is to defer Revenue over a specified period of time in Dynamics GP. I’ll setup a Deferral Profile to make a template for commonly used deferrals. No more manually deferring, let GP do it for you!

Continue reading “Microsoft Dynamics GP Revenue/Expense Deferrals”

Microsoft Dynamics GP Posting Dates (Transaction vs. GL)

What are there 2 dates in Dynamics GP on all transaction except the General Ledger? I answer this question for you, along with the why’s and wherefores? The dates can be confusing, but this video helps you understand the difference between the 2 dates and how they are used. 

What are there 2 dates in Dynamics GP on all transaction except the General Ledger? I answer this question for you, along with the why’s and wherefores? The dates can be confusing, but this video helps you understand the difference between the 2 dates and how they are used.

Continue reading “Microsoft Dynamics GP Posting Dates (Transaction vs. GL)”

Microsoft Dynamics GP Metrics Dashboard

You would not drive your car without a dashboard, why do you drive your business without one? Using Microsoft SQL Server Reporting Services with Microsoft SQL Server 2008 and Microsoft Dynamics GP 2010 R2, will give you a dashboard with the click of 1 box. No kidding, watch me do it in this video! 

Originally Posted 8/3/2011

You would not drive your car without a dashboard, why do you drive your business without one? Using Microsoft SQL Server Reporting Services with Microsoft SQL Server 2008 and Microsoft Dynamics GP 2010 R2, will give you a dashboard with the click of 1 box. No kidding, watch me do it in this video!

Home

Continue reading “Microsoft Dynamics GP Metrics Dashboard”

Microsoft Dynamics GP GL Trial Balance made easy with Excel Pivot Tables

This video shows how to create a very easy, REFRESHABLE, General Ledger Summary Trial Balance using Microsoft Dynamics GP Excel Refreshable Reports. The power’s in the Pivot! 

Originally Posted 6/6/11

This video shows how to create a very easy, REFRESHABLE, General Ledger Summary Trial Balance using Microsoft Dynamics GP Excel Refreshable Reports. The power’s in the Pivot!

Note this is an older post, but this method still exists and is super easy, so it’s still valuable.

Continue reading “Microsoft Dynamics GP GL Trial Balance made easy with Excel Pivot Tables”

Microsoft Dynamics GP Vendor Analysis, made simple and cool

Today I want to show you how to use Excel Pivot tables and Microsoft Dynamics GP Excel Refreshable reports to create a Vendor Analysis Report that one of my customers requested. 

Today I want to show you how to use Excel Pivot tables and Microsoft Dynamics GP Excel Refreshable reports to create a Vendor Analysis Report that one of my customers requested. 

Originally Posted 6/6/11

Today I want to show you how to use Excel Pivot tables and Microsoft Dynamics GP Excel Refreshable reports to create a Vendor Analysis Report that one of my customers requested.

It provides you the total amount billed, showing paid and unpaid for a specified Time period. This is a great tool to assist in Budgeting and Month End Closings.

Continue reading “Microsoft Dynamics GP Vendor Analysis, made simple and cool”

Microsoft Dynamics GP Sales Order Processing Analysis in Excel

Use Microsoft Dynamics GP Excel Refreshable Reports to create amazing Sales Order Processing (SOP) analysis Reports. Pivot Tables never looked so good! 

Use Microsoft Dynamics GP Excel Refreshable Reports to create amazing Sales Order Processing (SOP) analysis Reports. Pivot Tables never looked so good! 

Originally Posted 6/1/2011

Use Microsoft Dynamics GP Excel Refreshable Reports to create amazing Sales Order Processing (SOP) analysis Reports. Pivot Tables never looked so good!

Continue reading “Microsoft Dynamics GP Sales Order Processing Analysis in Excel”