Reversed Original Transaction Reference
To create a reversing transaction using the Costs Integrator, enter the correct transaction details (e.g., Transaction Source, Project Number, Task Number, etc) that match the existing Cost in Oracle that is being reversed. Negative values must be entered for Quantity and Raw Cost (for costed transactions) fields. The value entered in the Reversed Original Transaction Reference field must match the Original Transaction Reference value from the existing Costs in Oracle.
A transaction is a reversing transaction if the Reversed Original Transaction Reference column contains data, and negative values exist for Quantity and Raw Cost (for costed transactions).
In the Oracle forms, the Original Transaction Reference needed for a reversing transaction can be found by navigating to the Manage Project Costs area and searching for the transaction that should be reversed. Copy the number and paste it into the Reversed Original Transaction Reference column in the Costs Integrator.
Along with the Original Transaction Reference of the transaction that is to be reversed, all other values must match the original transaction in order for the reversal to be successful. The example batch below shows valid and invalid reversing transactions lines. For this scenario, each transaction line was uploaded individually to avoid the Integrator Grouping functionality so that valid and invalid rows can be viewed. If all the rows were selected and uploaded together, the upload would have failed due to the invalid transactions being included with valid ones. See Integrator Batch Size for more information.
The errors in the above scenario are due to:
· Item Date did not match the original transaction that the reversing transaction on the sheet is reversing.
· Negative Raw Cost amount did not match the Raw Cost from the original transaction that is being reversed.
· Negative Quantity amount did not match the Quantity from the original transaction that is being reversed.
· The Reversed Original Transaction Reference entered is incorrect and did not match any existing Project Costs.
· The Project Number did not match the original transaction.
