Perform a Mass Reversal of Distributions

Perform a mass reversal of distributions generated from transactions that were processed incorrectly due to a setup issue in the joint venture definition.

The adjustments process enables you to enter a date range that encompasses the joint venture transactions whose distributions you want to reverse. You can enter additional criteria to further refine the transactions by joint venture or a particular account. If your setup includes an integration with Oracle Project Costing, you can enter project details to identify transactions associated with a project.

The process creates reversed distributions that are associated with the transactions identified by the search criteria. It cancels the original distributions and for each canceled distribution, it creates a new distribution with a distribution line type set to Reversed.

You can configure the process to reset the status of the transactions to “Available to process” or “Reversed” after completing the reversals. When you reset the status to “Available to process,” you can correct the setup issue in the joint venture definition and process the transactions again. You can set the status to “Reversed” if you are reversing distributions for transactions that should not have been processed. This status prevents the transactions from being distributed again.

Perform these steps to perform a mass reversal of distributions:

Access Scheduled Processes from the Tools menu, and then search for this process by job: Process Joint Venture Adjustments.
Select Create Joint Venture Distribution Reversals for the processing mode.
Select “Distributions for selected transactions” for the reversal source.
In the Basic Options section, complete the following fields to identify the distributed transactions:
- Joint Venture. You can identify transactions for a particular joint venture or leave this blank to identify all transactions according to the date range.
- Transaction from Date and Transaction to Date. You must enter a date range to identify the transactions.
Use the following fields to further refine the list of transactions:
- Account. You can identify transactions for a particular account.
- Project Number, Task Number, Expenditure Type. (Project Costing integration only) Use these fields to identify transactions associated with a particular project. If you select a task number, you must select a project number first because task numbers are specific to a project number.
In the Transaction Status After Reversal drop-down list, select the status that you want set for the transactions after reversing their distributions:
- Available to process. Use this setting when you want to process the transactions again. This enables you to correct the issue in the setup of the ownership definition, stakeholder, or invoicing partner and distribute the transactions again.
- Reversed. Use this setting when you distributed the wrong transactions. The Reversed status prevents the transactions from being distributed again.
Note: If you determine later that the transaction can be distributed again, you can change the status from Reversed to Available to process.
Use the following fields to include a reason for the reversal in the transactions and distributions:
- Transaction Reversal Reason
- Distribution Reversal Reason
Click Submit.
When the process completes, open the associated text file to view the number of selected transactions and the number of distributions that were selected, processed for reversal, or skipped.
You can access the Joint Venture Distributions work area to review the original distributions and their associated reversed distributions.
The original distributions are updated with Canceled as the distribution line type. A new reversed distribution is created with Reversed as the distribution line type.
For reversed cost distributions, the amount that was originally in the Debit column is now in the Credit column. For reversed revenue distributions, the amount that was originally in the Credit column is now in the Debit column.