We will cover the PA master record tables – Projects, Contracts and Cost Categories. We will cover the PA transaction tables - Timesheets, Employee Expenses, PO’s, Miscellaneous Logs and Equipment Logs.
We will also cover the budget and budget template tables. We will show how to write very basic SQL queries linking the above tables for use with Smartlist Builder or SSRS.

Audience: Beginner – Intermediate

Attendee Role: Accountant, Senior Accountant, Controller, CFO, Business Analyst, More...Programmer Analyst

This is part of the Reporting Special Interest Group: It's a hot topic for Dynamics GP users! Come learn about tools and strategies for effective reporting.
• Who Should Participate: Accountants, CFO/Controllers, AP Professionals, IT Professionals, Budget Managers, Operations, Business Analysts/Reports, Payroll
• Leaders: Derek Krebs, Russ Worth, Shawn Dorward, Steve Erbach
• When We Meet: Monthly
Click to stay involved in with further education and collaboration with Members, please become an active member in the Reporting community: https://www.gpug.com/communities/community-home?CommunityKey=22086f8b-0a4a-4d77-991e-393dcdd18ff4

Russ Worth
Business Analyst – Grand Isle Shipyard, Galliano, LA (2011 - present). GP/AX consultant – 3 years. CFO/Controller/Accounting Manager – 20 years. GP user since 1998. MBA – Georgia State University (Finance), BBA – University of Georgia (Finance).