bigfoot
25th February 2008, 19:21
I have a reporting query for PCS Hours.
For current PCS Hours reporting I can get hours from hours input and rates from operation rates, and generate a report using Crystal (or equivalent).
However we do change our rates annually, when this happens the rates in table ticpr150 do not have a time stamp.
My result is that all hours become valued at current rates (when using crystal).
Is there a table I can use that holds the operation rates that are assigned to tasks that get posted to a PCS project... that records the rates in force at a particular time. Or an hours table that also includes the cost?
:confused:
regards,
For current PCS Hours reporting I can get hours from hours input and rates from operation rates, and generate a report using Crystal (or equivalent).
However we do change our rates annually, when this happens the rates in table ticpr150 do not have a time stamp.
My result is that all hours become valued at current rates (when using crystal).
Is there a table I can use that holds the operation rates that are assigned to tasks that get posted to a PCS project... that records the rates in force at a particular time. Or an hours table that also includes the cost?
:confused:
regards,