Distributing Joint Venture Account Ledger Records

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 to entity that is assigned to the transaction. This program writes records to the Joint Venture Distribution Detail table (F09J12).

The R09J402 only includes F09J11 records that meet the following criteria when processing:

  • The record must be at an Available to Process status.

  • The record must include a value in either the DOI Name, Direct Bill to Outside Partner, or Direct Bill to Insider BU field.

After the F09J11 records are selected, the R09J402 distributes the transaction amount across the partners using the DOI that is specified in the DOI Name field. Alternatively, it distributes the entire amount of the transaction to a single partner if the Direct Bill to Outside Partner or Direct Bill to Insider BU is populated.