Most Common GP Tables for Reporting

Overview

The data structure of Microsoft Dynamics GP is unique,  often cryptic, and presents a challenge to building reports

Jet Reports has created The most common GP Tables for reporting

This document is an aid for anyone who needs to create reports on a GP database. It provides information about how commonly-used data is stored in the standard Microsoft Dynamics GP database.

This is not a complete overview of the database but, rather, a look into the most commonly-used tables and fields in reporting.

Download the latest version of the document --> Here {requires Excel 2007 or higher}

No warranty is implied, nor is any representation given that this information is complete or accurate. Microsoft could change the table structure at any time. Microsoft and Dynamics GP are trademarks of Microsoft Corporation. This document was not provided or reviewed by Microsoft