MSP_TIMEPHASED_DATA and "Assignment actual cost"

[TomG]

Hi,
I am working on MS Project timephased data via an Access database.
Everything works fine with data for

1 Assignment remaining work
2 Assignment actual work
3 Assignment actual overtime work
4 Assignment baseline work
5 Assignment baseline cost

BUT - I want to use "Assignment actual cost" (CONV_VALUE = 6) and the data
is just not coming across into the MSP_TIMEPHASED_DATA table.

I know the calculated Actual Cost information is present in Project 2003
because I can see it in the Resource Usage view. I know the Actual Cost
information is NOT
present in MSP_TIMEPHASED_DATA because there is no row in the table with
TD_FIELD_ID = 6.

Here's the weird thing: When I enter the Actual Cost information manually
into Project 2003, it comes across into the MSP_TIMEPHASED_DATA fine. It's
the automatically created data which will not transfer.

For example: If the calculated Actual Cost = £400.00, it does not get
written to MSP_TIMEPHASED_DATA. If I change the value to £401.00, it gets
written to the table!

Is this a known problem?

I'd be very grateful for any help.

Regards,
Tom

 

[HariP]

Try turning off the automatic calculation before you save the project to
Access. You may already know this but here are the steps. Open your mpp
file, On the Tools menu, click Options, and
then click the Calculation tab. Clear the Actual costs are always calculated
by Microsoft Office Project check box, Save the file to Access.

You may want to turn the auto calculation back on before you enter any
actuals though.

Hope this helps.

 

[TomG]

HariP,
You're right! Thanks.

Now I just have work this into the application (probably by trappping
ProjectBeforeSave and using the AutoCalcCosts property).

Cheers,
Tom

PS How did you know this would work?

 

[UMAN]

How do you actually enter the timephased data into the MSP_TIMEPHASED_DATA
table? I am following the directions in the pjdb.htm file and cannot seemt
to get it to work. any suggesitons?