Book Image

Microsoft Dynamics GP 2013 Reporting

Book Image

Microsoft Dynamics GP 2013 Reporting

Overview of this book

Table of Contents (21 chapters)
Microsoft Dynamics GP 2013 Reporting
Credits
About the Author
Acknowledgments
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges
Index

Summary


In this chapter, we discussed both various ways to identify the data we need to create our reports as well as the various tools that assist us with this task. Once the challenges presented in the previous chapter have been identified, the next logical step is finding our data. Keep in mind that although some reporting tools do not require a pre-knowledge of the SQL database or GP company database structure, we can still use our knowledge of GP data structures to build better reports.

To that end, we've used this chapter to explore some of the conventions surrounding how GP data is stored. We began at the database level by exploring the differences between the system and company databases, including the new enhancements to naming system databases in GP 2013. Then we moved on to understanding the naming and numbering convention for tables found within these databases. At first glance, the numbering convention used for GP tables can be confusing, but by this point, we are familiar with...