D
David F-H
I have a question about the best approach to handle multiple cost rates for a
project. I understand that MS Project has 5 cost rate tables (A, B, C, D &
E) and that each of these can have effective date ranges within them.
However, we need more than 5 different cost rates to cover the same period
for team members, as each project that a team member works on may have
separately negotiated rates with our clients, and they may also be in
different currencies.
My solution has been to create an enterprise task custom variable
(tskCostRate) that must be set for each assignment within the project (using
Task Usage view and insert tskCostRate field). However, my understanding is
that they would not be reflected as costs in standard MS Project reporting,
and I'm also worried about possible future integration with Portfolio Server.
We do extract our own reports from the Reporting database, however, which I
have coded to recognise these fields.
My question is (before I proceed to far down this path) whether this is the
best approach, or is there a better method that I have missed?
project. I understand that MS Project has 5 cost rate tables (A, B, C, D &
E) and that each of these can have effective date ranges within them.
However, we need more than 5 different cost rates to cover the same period
for team members, as each project that a team member works on may have
separately negotiated rates with our clients, and they may also be in
different currencies.
My solution has been to create an enterprise task custom variable
(tskCostRate) that must be set for each assignment within the project (using
Task Usage view and insert tskCostRate field). However, my understanding is
that they would not be reflected as costs in standard MS Project reporting,
and I'm also worried about possible future integration with Portfolio Server.
We do extract our own reports from the Reporting database, however, which I
have coded to recognise these fields.
My question is (before I proceed to far down this path) whether this is the
best approach, or is there a better method that I have missed?