O'Reilly logo

Microsoft Dynamics GP 2010 Reporting by David Duncan, Christopher Liley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter, we discussed the various challenges of developing reports. Once those challenges have been considered, the next step is finding our data. Even though some reporting tools do not require understanding the SQL database structure of GP company databases, 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 DYNAMICS database and the various company databases. 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required