Pending Commitment Change Order Amount Incorrect

SOLVED

Hello! When we enter commitment change orders, they are saved with a "Pending" status until management approves them to be issued. We have one commitment change order that was updated as approved, but the totals on the commitment are now incorrect.

The original CO amount was [positive] +4,655.19. After updating the CO to approved, the system now shows a "Pending CO Amount" of [negative] -4,655.19. But the weird thing is it also applied the positive amount to the "Approved CO Amount" as well. It seems like the process that deducts the pending CO amount from the JC Commitment table happened twice (or the initial positive addition never occurred.) 

The odd thing is there's no record of a pending CO in that amount anywhere in the system. We've pulled up the CO's to ensure there weren't any unapproved items and we even deleted all the commitment's CO's and re-entered them. The pending value remains at [negative] 4,665.19 regardless.

Attached is a screenshot of the logs that show all the green data is correct (including the Revised Contract Amount) while the Pending CO Amount is still incorrect. 

Is there any way to force the system to "recalculate" based on the current records? Or maybe to manually update that amount? 

Thanks!