Ever wondered about the tables and joins behind the GP Smartlist? Well thanks to Bud on the GP Newsgroup, you don't have to wonder any more. The Dexterity Integration Guide is hidden on Disc 2 with your GP install and has the details of the tables and joins for the default Smartlists!
The file is called IG.pdf. For version 9, Bud indicates that it's in the Tools>Dex>Doc>PDF folder on Disc 2 and that the tables start around page 272. For version 10, I actually had to install Dexterity from Tools>Dex on Disc 2. After installation, the PDF was available at C:\Program Files\Microsoft Dexterity\Dex 10.0\Manuals by default. The Smartlist data starts in Chapter 7 and you'll see the details starting on page 312.
If you're new to the GP Tables and looking to write SSRS or Crystal Reports, these examples may help you as well.
For those of you who love Relationship Diagrams, you'll find these in the SDK also on Disc 2 under Tools>SDK. Also in the SDK are design documents and transaction flows. I still prefer Accolade's Info Flow and Posting but these may get you started. Also don't forget about the Table References for v 9.0 and 10.0 in the Downloads section.
Which tool you need depends on your level of experience and what you're trying to do.
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
