Initially there were a few transactions created by users using Transaction Entries (Voucher Expense/Other). But they have entered on wrong task and they want to revert them back to zero.
What I did -
Checked PPA WIP table where the status = 0 but the value present in DB is (-200) not sure if application will only show the absolute values.
I guess application will pick the Actuals with Status 0, not sure. Please tell where am I doing wrong. I am running the Import financial Actuals Job too for every change.
Also, Please let me know how this mapping from Project actuals to PPA_WIP occur.
Thanks in advance.
Did you first entered the -200 did you use the same transaction date?
You could have also just used the 'Reverse' button.
As a first action, I have just reversed them but Actuals got reduced not zeroed.
After this action, Actuals were 200 so I Created WIP Adjustment as (-200).
Please log a Support ticket if issue still persist so we can help you.
It may be a case that you have an out-of-sync situation
I had a PPM client who did this, and requested Support if there was a way to correctly reverse, and sadly required database updates which Support would have to develop, due to the way the client had tried to reverse the transaction.
The client had managed to 'reverse' it correctly from a WIP perspective, but the Actuals on the Task lines remained incorrect. This then limits using the 'Populate from Task Assignment' on the Cost Plan as there are now 'differences' between the 'task actuals' and the 'wip actuals' as it will then push the 'difference' when using the 'Populate from Task Assignment'.
I would be very grateful if someone could provide a step-by-step guide on how to correctly reverse these types of transactions, in particular, when the item has been posted and the error may have not been identified for a couple of days/weeks later.