stevegray
4Penny.net
Points: 53175

10/5/2016 1:06:01 PM

Certified Payroll report that adds in (Olympic) Project Cost data

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

Recently I was asked to take the Certified Payroll report that comes with Dynamics and add Olympic Project Cost data to it.

The query that runs the report is below.

Warning:

This script depends quite a bit on the customer's data, and needs to be modified before use. If you don't have SQL chops, don't do it.

4Penny.net
Version: All
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
3