Points: 53625

10/28/2014 2:03:07 PM

Certified Payroll

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

I recently received a request to write a certified payroll report, and the query turned out to be a tough one. The client needed me to bring in the project from the gpUPRCPR table, which I'd never heard of; and several other custom fields. Like most GP reports, this report does not run from a query but they build the dataset one line at a time behind the form. I had to trace through several hundred SQL calls to get this figured out. More, the stored procedures that they did call were not on the machine. I'm not sure how that works, because they didn't return errors. Maybe they create them on the fly and delete them?

At any rate, the query for the report is below. I don't what to have to do this twice <smiles>

If you can shed any light on how this process works, would you add a comment below the article?
Version: GP 2010,GP 2013
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables