The Project Task Assignment Actual Units is not updated correctly after we 'reversed' a transaction from WIP; the 'Actual Cost' amount on the task is correctly set to zero in PPM (Clarity). Differences in amount of actuals can also be noticed when comparing Team actuals versus WIP.
We reversed a financial transaction for a non-labor resource and the Project Actual Units field is not updated; we are expecting to see zero (0) actual units, but instead see a positive amount. We do not see the record in the 'Posted Transaction Review' nor do we see it in the Create WIP page as expected. The record has been successfully reversed.
Steps to Reproduce:
So now WIP and the Project Actual Units are out of sync. The WIP reversal removed the transaction and updated the cost, but the Project Actual Units has a positive value. There is no way to synchronize this value. Any further adjustments will either put the WIP side or the Project side off balance.
An Expense, Non-Labor Voucher Transaction was created with a Quantity = 1 and Cost/Rate = (-25,345) .
When the transaction is imported into the Project, because it is a Non-Labor resource, the Actual Units is computed as (Quantity * Cost).
For this scenario, this would compute to a negative amount. Within the current design of the application, the 'Import Financial Actuals' job allows this transaction to be posted to the project without any error and because the Project Actual Units does not allow a negative value, the Project Actual Units is now set to zero (0) and the Project Task Actual Cost = (-25,345)
Subsequently, the user wants to remove this transaction which will now cause a mismatch between WIP and Project Actual Units.
When the user 'reverses' or 'adjusts' the transaction, and it is imported back into the project, the Project Task Actual Units becomes +25,345 and the Actual Cost becomes zero (0). It was expected that both values should be zero. But because the Actual Units is set to zero from the original transaction, the 'reversal' or 'adjustment' transaction is computing the amount as [0 - (-25345)] = +25345 (simple math: subtracting a negative value becomes positive result)
Due to the current design of the application, there will always be a mismatch for this scenario.
At this point the user will need to decide where the correct amount is to reside, on the project side or on the WIP side.
Steps to Update Project Actual Units:
Reference TEC532981 : Import Financial Actuals job does negative transactions that can cause Project Actuals to be out of sync
Reference TEC536102 : PPM and OWB: Negative Transaction adjustment will cause bad data on assignment Actual Cost field