Fixed Cost automatically populated

[Nach]

Hello,

I am using Project 2007 and Project Server 2007. Recently we had a problem
where the Actual Cost didn't really add up the actual cost of the assignments
and when I started digging deep I realised that there were some fixed costs
associated with that particular Task which was negative and hence it affected
the Actual Cost for that particular Task. When asked, the PM refused doing
anything with Fixed Costs. Out of curiosity I ran an SQL query to see if
there were more Projects with Fixed Cost and I found about 9 Projects that
had it. And it turns out that none of the PMs manually/intentionally assigned
any fixed cost to those Tasks.

I browsed through this forum and couldn't find any bugs reported about this.
I'd like to know if there is any other field or formula that is doing this
which I'm not aware of. And any pointers or advice as to how to continue my
investigation would be helpful.

Here is the SQL query you could use to find out if any Projects/Tasks have
Fixed Costs associated--
SELECT MSP_EpmTask_UserView.TaskName,
MSP_EpmProject_UserView.ProjectName, MSP_EpmTask_UserView.TaskFixedCost,
MSP_EpmTask_UserView.TaskActualFixedCost
FROM MSP_EpmTask_UserView INNER JOIN
MSP_EpmProject_UserView ON
MSP_EpmTask_UserView.ProjectUID = MSP_EpmProject_UserView.ProjectUID
WHERE (MSP_EpmTask_UserView.TaskFixedCost <> 0)

Thanks
Nach