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.
*This post is locked for comments