JudithJubilee said:
Hello there,
I have various tasks that I have added resources to with
their own Standard Rates. I understand how to accrue cost
Prorated, Start and End but I would like the cost to be
accrued after a time, eg. 21 days, has passed. Could
anyone advise me on the best way to go about this?
Thankyou in advance
Judith
Judith,
Yes. There are various approaches. One simple approach may seem a little
flaky but it should be relatively easy to implement. For each task that
you want a delayed cost accrual, create a "slave" task that is delayed
from the main task and assign the resource to the slave task.
Other methods that come to mind may not be as easy to implement. It
should be possible to develop one or more custom fields with formulas
that effectively delay the cost. Without actually trying this method, I
would guess the formula needs to delay the accrual, calculate the cost
based on the resource rate and roll up the cost to summary lines. It
will probably require additional effort and spare fields to capture the
resource rates for the calculation.
Personally I would use a VBA approach. Put all the delay, accounting and
rollup in code and then dump the results in a spare cost field. This
approach allows the most flexibility and I know it will work without
even trying it.
If there are other methods, hopefully someone else will offer their
suggestions.
John
Project MVP
