Hello experts,
We have orphan records in the CostControlCommittedCost table generated from pending invoices that are still open and not relieved. These records are associated with source document (vendor invoice) that no longer exist. it seems as the pending invoice was deleted without clearing (relieve) the project committed costs on the table CostControlCommittedCost.
This data causes the budget control failure in the project module and overruns the budget for the project.
How does this phenomenon occur? No idea we could not reproduce the problem.
We use workflows to approve invoices, it seems that there are invoices with the same number were processed (invoiced and finalized) and linked to the purchase order.
However, it seems that the project committed costs are linked to a copies of no existing pending invoices (we call them ghosts invoices).
We use AX 2012 R3 CU9 with almost all modules activated.
My question :
1) - Is there any one have seen this before? if yes what is the best approach to fix it?
2)- We wrote an X++ script to reverse the lines in CostControlCommittedCost table and close the transaction (we could have deleted the line too, but as precaution we just close the transaction) (Set Open = 0);
Is closing these transactions on CostControlCommittedCost manually will affect any other things then the remaining budget and committed costs on the project budget balance?
What is the risk?
Thank you for your help in advance!
