Microsoft Dynamics GP FRx Sales Report

This video shows how I use FRx to create Operational Reports, such as a Sales Report from Microsoft Dynamics GP data. I build it from scratch so you can see each step along the way. 

Originally Posted 7/12/11

This video shows how I use FRx to create Operational Reports, such as a Sales Report from Microsoft Dynamics GP data. I build it from scratch so you can see each step along the way.

Continue reading “Microsoft Dynamics GP FRx Sales Report”

Microsoft Dynamics GP General Ledger Budget used for last Year Actual?

In this video I show how I used the Microsoft Dynamics GP GL Budget to store last year’s actual numbers for native GP inquiries, this year vs. last years. It’s easy and provides amazing information! 

In this video I show how I used the Microsoft Dynamics GP GL Budget to store last year’s actual numbers for native GP inquiries, this year vs. last years. It’s easy and provides amazing information! 

Originally Posted 7/11/11

In this video I show how I used the Microsoft Dynamics GP GL Budget to store last year’s actual numbers for native GP inquiries, this year vs. last years. It’s easy and provides amazing information!

Continue reading “Microsoft Dynamics GP General Ledger Budget used for last Year Actual?”

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”

Overview of Microsoft Management Reporter for Dynamics GP

This video is an overview of Microsoft Dynamics GP Management Reporter, explaining the building blocks used to create Financial Reports. 

This video is an overview of Microsoft Dynamics GP Management Reporter, explaining the building blocks used to create Financial Reports. 

Originally Posted 2/24/2011

This video is an overview of Microsoft Dynamics GP Management Reporter, explaining the building blocks used to create Financial Reports.

Continue reading “Overview of Microsoft Management Reporter for Dynamics GP”