Reviewing and Revising Distribution Records (P09J12)

After records exist in the Joint Venture Distribution Detail table (F09J12), you can use the Work with JV Account Ledger program (P09J12) to review and update the distribution detail records in the F09J12 table. Using this program, you can update these fields only:

• Transaction Status

• Remark

However, if the record is marked for redistribution (Joint Venture Void Code = Available for Redistribution), you can also update the insider business unit, outside partner, mark the record for distribution only, and mark the record for creating invoices and vouchers if the partner is an insider. Redistribution records are created by the system when you void joint venture documents, or reverse individual transactions in a joint venture document. You use redistribution records to reassign a distribution to a different partner in the joint venture and to process the transactions in a new document.

Note: When the DOI is set up to create invoices and vouchers for the insider business unit, the system populates the address number of the insider business unit in the Outside Partner field. If the DOI is set up to only create journal entries for the insider business unit, the address number of the insider business unit is not displayed.

Mass Update Features

You can also use several mass update features to update multiple records at the same time. For example, you can delete all the distribution records or selected records. You might have run the distribution process using DOIs that had incorrect information. In this situation, you can delete the distribution records, correct the DOIs, and rerun the distribution process.

You can select records for mass update using the check box at the beginning of each row, or you can use the form header, QBE line, or Advanced Query function to search for all records that you want to update.

The system enables you to perform mass update for these actions:

• Delete selected distribution records.

• Delete all distribution records that mach your current query.

• Update the status, outside partner, and insider business unit of selected distribution records.

• Update the status of all distribution records that match your current query.

• Reverse selected distribution records.

• Reverse all distribution records that match your current query.

Note: You cannot update individual records or perform mass update of multiple records for transactions that have the Process Complete status.

Note: Processing numerous distribution detail records at a time using the mass update features may lead to time-out web exception error. Run the Joint Venture Distribution Details Revision batch program (R09J413) to update a large volume of distribution detail records. See (Release 9.2 Update)Processing Joint Venture Distribution Transactions Using a Batch Process (R09J413).

The Form menu of the program also provides access to the following information for a specific distribution detail record:

• The joint venture distribution document information in the P09J12D program

• The joint venture invoice, voucher, or journal entry information for the selected record on the corresponding system (Accounts Receivable, Accounts Payable, or General Ledger)