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

Chapter 2. Business Intelligence for the General Ledger

The General Ledger is the bucket that collects and holds data from every module of Dynamics GP. It can be used for so much more than just balance sheets and profit and loss statements. We encourage all Microsoft Dynamics GP customers to post everything but payroll into the General Ledger in detail. We recommend this because extracting data from the General Ledger is easier than extracting data from any other module.

What makes General Ledger (GL) data easier to work with is that all GL data contains the same format for transactions. Each line has either a debit or credit amount. There are no entries that need to have their type reviewed (for example, invoice vs return) to determine whether the amount should be a positive or negative amount. There is no need to determine if the document is still unpaid or paid. If it’s in the GL, it’s reportable (with the one exception of voided entries).

With detail in the GL, each entry can be linked...