K
Kevin Flanagan
I am pulling 3 reports on resource costs. One is
directly out of the database via SQL query. One is the
Resource Cost view in PWA and the other is a view
directly within MS Project. I am trying to reconcile the
differences in the numbers being reported between the
three views of supposedly the same data. The cost and
actual data in PWA and Proj Pro seems to be OK and
match. However, the data within the SQL query
(MSP_RESOURCES table: RES_COST, RES_ACT_COST, and
RES_BASE_COST)is off two decimal places and yet another
1% in addition to that. Can anyone explain where all
these data views are pulling from and why I cannot
reconcile these various reports???
Thanks,
Kevin
directly out of the database via SQL query. One is the
Resource Cost view in PWA and the other is a view
directly within MS Project. I am trying to reconcile the
differences in the numbers being reported between the
three views of supposedly the same data. The cost and
actual data in PWA and Proj Pro seems to be OK and
match. However, the data within the SQL query
(MSP_RESOURCES table: RES_COST, RES_ACT_COST, and
RES_BASE_COST)is off two decimal places and yet another
1% in addition to that. Can anyone explain where all
these data views are pulling from and why I cannot
reconcile these various reports???
Thanks,
Kevin