Belinda Allen, Microsoft MVP Business Solutions
Things I've learned from years of working with Microsoft Dynamics GP.
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”
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”
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”
Belinda Allen, Microsoft MVP Business Solutions 