DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In
sgray128 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