Book Image

Real-world Business Intelligence with Microsoft Dynamics GP

Book Image

Real-world Business Intelligence with Microsoft Dynamics GP

Overview of this book

Table of Contents (20 chapters)
Real-world Business Intelligence with Microsoft Dynamics GP
Credits
About the Author
Acknowledgments
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Sharable aged trial balance


All organizations, whether for-profit or nonprofit, have two important things to manage: money going out and coming in. Managing what is owed to you is not only critical to the success of your company, but it's also critical for you to receive your paycheck! Keeping track of what is owed and when it is owed, is what the aged trial balance is all about. The report we'll build is all about creating an aged trial balance in a format that will help all involved, with customers and the management of the checkbook, to know where the accounts receivables stand. This is a favorite auditor request and it can be challenging to get it into Excel using the native GP report.

Brief background of the company

This report is for a company that wanted to make a non-GP user responsible for collection calls, keeping the notes in their CRM system. Rather than purchase an additional license, this refreshable report was built.

Pain or goal defined

It's difficult to set up GP so that the...