Edit Joint Venture Transactions

In the Transactions work area, you can make changes to transactions that haven't already been processed by the Create Joint Venture Distributions process.

Changes to transactions in the Joint Venture Transactions work area are limited to 100 records at a time. Therefore, for mass updates, you're highly encouraged to use the Excel spreadsheet to make changes to in joint venture transactions. Download the spreadsheet from the Joint Venture Transactions work area and follow the instructions in the spreadsheet to make changes as needed and upload your changes back to the work area. See Manage Joint Venture Data in Microsoft Excel for more information.

Here’s what you can change:
Update Description
Transaction status
  • For transactions that you don't want to distribute and invoice, change the status from Available to Process to Not Distributable.
  • For transactions that you don’t want distributed yet, for example transactions that have been called into question, change the status to On Hold.
  • For transactions that are in the following error statuses, you can change their status to Available to Process after you correct the errors: Missing Transaction Date, Missing Ownership, Ownership Not Effective, and Inactive Stakeholder.

If you have project-related transactions or unpaid transactions from Payables or Receipt Accounting, see these topics for more information about the status changes you can make:

Ownership definition Override the ownership definition on the transactions with a different ownership definition.
Direct billed stakeholder Override the ownership definition on the transactions with a direct billed stakeholder to apply an entire transaction amount to a stakeholder.
Transaction date

If the transaction date on the original transaction is either incorrect or missing, you can change the transaction date in the Joint Venture Transactions work area.

When the Create Joint Venture Distributions process is run, it compares the transaction date to the effective dates in the available ownership definitions to determine which ownership definition to use to create distributions for the transaction.

Distribution only Change the “Distribution Only” setting for transactions.

You must enter the reason for making the changes. The application provides an audit trail of the last changes made.

Additionally, you can clear ownership definition assignment rules that were incorrectly applied to transactions. This enables you to correct the assignment rules and then run the process to apply assignment rules to the transactions again. See Clear Assignment Rules for more information.

To edit joint venture transactions:

  1. Select the transactions you want to change:

    • Select one or more rows manually.

    • Or click the Select All checkbox above the first row if you want to update all transactions based on your filter criteria.

    Caution: When you use Select All, the application selects only the first 100 transactions displayed in the table. It won't update additional transactions that meet the search criteria without having to repeat the update. Therefore, for mass updates, you're highly encouraged to use the Excel spreadsheet.
  2. Click Edit.

    The Edit Joint Venture Transactions dialog box displays the count of selected transactions.

  3. On Edit Joint Venture Transactions, select the new values as appropriate.

    Note: If the records selected for updating are from different joint ventures, the Ownership Definition and Direct Billed Stakeholder fields aren’t displayed. To update these fields, you can select and update each transaction individually. Or, you can use the search and suggested filters to display joint venture transactions belonging to a specific joint venture, and then you can use the Select All checkbox and update all fields.

    You must complete the Change Reason field and optionally enter additional information describing the reason for updating the transaction.

  4. Click Update.