1. Joint Venture Management Implementation Guide
  2. Loading Records into the Joint Venture Account Ledger

Loading Records into the Joint Venture Account Ledger

After transaction records have been created in the Account Ledger table (F0911), you can run the Load Joint Venture Account Ledger program (R09J400) to copy F0911 transactions that are associated with distributable joint venture accounts into the Joint Venture Account Ledger table (F09J11).

You can use data selection to specify the joint ventures that you want to include in the processing. The program retrieves the business unit from the selected joint ventures, along with the joint venture distributable account designation, to determine which records in the F0911 to include in the process. If the business unit on the selected joint venture is a parent business unit, the program also includes accounts associated with child business units.

Note that the parent child relationship for a business unit is set up by specifying the parent business unit in the Joint Venture Parent Business Unit field of the Business Unit Master program (P0006).

You can also use processing options to specify whether to use the Service/Tax Date or the the Fiscal Year and Period Number to select the records you want to include in the process.
  • When you select to use the Service/Tax Date, specify the date range that the system uses to select the transaction records.
  • When you select to use the Fiscal Year/Period Number, you can specify whether you want to process only that specified period or if you want to include all year-to-date transactions up through that period. If you rerun the Load Joint Venture Account Ledger program for the same period, the system copies only new records that do not already exist in the Joint Venture Account Ledger table (F09J11).

Lastly, you can use the processing options to specify whether the system automatically runs the DOI Assignment process over the records that are copied into the F09J11 table after the R09J400 completes processing. This process can also be run separately. See Assigning DOIs or Direct Billed Partners to Joint Venture Account Ledger Records for additional information about the DOI Assignment process.

When the R09J400 completes processing, the system generates a report listing all joint ventures included in the process, and also any errors that occurred during processing.