1. Joint Venture Management Implementation Guide
  2. Understanding Joint Venture Account Ledger Transactions and Distribution Processing

Understanding Joint Venture Account Ledger Transactions and Distribution Processing

When your joint venture is set up in the system, financial transactions associated with that joint venture will occur. These transactions, which could include accounts payable, accounts receivable, purchasing, sales order transactions, allocation journal entries, or overhead journal entries are entered into the system, generating transaction records in the Account Ledger table (F0911) using standard processing for those systems.

After transactional data associated with your joint venture is in the F0911, you can bring that data into the Joint Venture Management system and process it so that it is correctly distributed among the partners of the joint venture.

This list provides an overview of how to process joint venture distributions:

  1. Prerequisite: The joint venture is completely set up, and transactions are entered into the EnterpriseOne system using the appropriate applications. Transaction records are available in the F0911 table and are posted to the Account Balances table (F0902). The system processes only those transactions that are at status P (Posted).

  2. After records exist in the F0911 table, run the Load Joint Venture Account Ledger program (R09J400) to copy all F0911 transactions that are associated with joint venture distributable accounts into the Joint Venture Account Ledger table (F09J11). Optionally, you can set this program to assign DOIs or direct billed partners to the transactions.

  3. After records exist in the F09J11 table, you run the Assign DOI or Direct Billed to JV Account Ledger program (R09J401). This program uses the Division of Interest (DOI) assignment rules to assign the appropriate DOI or direct billed partner to each transaction record in the F09J11. Each record in the F09J11 must have a valid DOI or direct billed partner to complete the distribution process.

    Note that this step is not required if you have set up the R09J400 to assign DOIs or direct billed to partners.

  4. Optionally, you can review the records in the F09J11 table and update them using the Joint Venture Account Ledger Revisions program (P09J11). This program enables you to manually override the DOI or the direct billed partner that was assigned to a transaction. You can manually enter the DOI or direct billed partner if it was not set by the assignment process.

  5. After the F09J11 records are reviewed and updated as needed, you then run the Generate Joint Venture Distribution Detail program (R09J402). This program uses the data from the F09J11 to distribute the transaction amounts among the partners of a joint venture using the DOI or the direct billed partner that is assigned to the transaction. This program writes records to the Joint Venture Distribution Detail table (F09J12).

  6. After records exist in the F09J12 table, you can use the JV Distribution Detail by Partner program (P09J12C) to review and update account distribution detail by partners. You can also use the Work with JV Account Ledger program (P09J12) to review and update F09J12 records and the JV Distribution Summary by Partner program (P09J12B) to review distribution summary by partners.