17 Processing Joint Venture Account Ledger Transactions

This chapter discusses:

17.1 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.

17.2 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 Project Number field of the Business Unit Master program (P0006).

You can also use processing options to specify the fiscal year and period associated with the records you want to include in the process. Additionally 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 Section 17.3, "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.

17.2.1 Prerequisites

Before you complete the tasks in this section, set up processing options for the Load Joint Venture Account Ledger program (R09J400).

On the Select tab, set up the following processing options:

  • Ledger Type

    To select transactions for a specific ledger type from the Account Ledger table (F0911), enter the ledger type in this option. If you leave this option blank, the system uses the AA (Actual Amounts) ledger type.

  • Fiscal Year

    To process records for a selected fiscal year, enter the year in this option. If you leave this option blank, the system uses the current fiscal year for the joint venture company of the joint venture.

  • Fiscal Period

    To process records for a specific fiscal period, enter the period in this option. If you leave this option blank, the system uses the current fiscal period for the joint venture company of the joint venture.

  • Period or Year To Date

    Specify whether to include only the records from the specified fiscal period, or to include all year-to-date records up through the specified fiscal period.

On the Process tab, set up the following processing option:

  • Assign Division of Interest or Direct Billed Entity

    Specify whether to assign DOIs or direct billed entities to the records after they are processed by the R09J400 program. If this processing option is set to assign DOIs or direct billed entities, the system automatically assigns the DOI or direct billed partner to the transaction records that do not have a DOI or direct billed partner assigned. If left blank, the DOIs will be not be automatically assigned, and you will assign them later by running the Assign DOI or Direct Billed to JV Account Ledger program (R09J401).

17.2.2 Running the Load Joint Venture Account Ledger Program (R09J400)

From the Joint Venture Management module (G09J), select Periodic Processing, Distribute G/L Transactions, and then Load Joint Venture Account Ledger.

17.3 Assigning DOIs or Direct Billed Partners to Joint Venture Account Ledger Records

After you process the Load Joint Venture Account Ledger program (R09J400), and 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 from the F09J22 to assign the appropriate DOI or direct billed partner to each transaction record in the F09J11.

Note:

You can set up a processing option in the R09J400 program to assign DOIs or direct billed partner to the records after they are processed by the R09J400 program. If this processing option is set to assign DOIs or direct billed partner, the system automatically assigns the DOI or direct billed partner to the transaction records that do not have a DOI or direct billed partner assigned.

The R09J401 program processes F09J11 records by joint venture and begins by searching for the most specific rule in the F09J22 table for the selected joint venture. The system uses the joint venture business unit hierarchy and the DOI assignment rules when attempting to assign the DOIs or the direct billed partners to the transactions. The system assigns the rules starting with the most specific (business unit) to the least specific (company).

17.3.1 Prerequisite

Before you complete the tasks in this section, set up the Ledger Type processing option for the Assign DOI or Direct Billed to JV Account Ledger program (R09J401).

You use this processing option to specify a ledger type that the system uses to select transactions from the Joint Venture Account Ledger table (F09J11). If you leave this option blank, the system will use the AA (Actual Amounts) ledger type.

Note that if you use multiple ledger types, you will require multiple versions of the R09J401 program.

17.3.2 Running the Assign DOI or Direct Billed to JV Account Ledger Program (R09J401)

From the Joint Venture Management module (G09J), select Periodic Processing, Distribute G/L Transactions, and then Assign DOI or Direct Billed on JV Account Ledger.

17.4 Reviewing and Revising Joint Venture Account Ledger Records (P09J11)

After running the R09J401, you can review, and if necessary, revise the records in the F09J11 using the Joint Venture Account Ledger Revisions program (P09J11). This program enables you to manually enter or override the DOI or the direct billed partner that was assigned to the F09J11 record by the R09J401.

You can use this program to make the following updates to the joint venture account ledger records:

  • Update the Transaction Status value.

    When records are created in the F09J11 table, they are automatically assigned the Available to Process status. You can manually update this status if necessary.

  • Update the DOI Name value.

    This is the DOI that was assigned to the record by the R09J401 program. You can update this value if necessary.

    Note that you can have a value in only one of the following fields: DOI Name, the Direct Billed To Insider BU, or the Direct Billed To Outside Partner. Each record in the F09J11 must have either a valid DOI or partner for direct billing to complete the distribution process.

  • Update the Direct Billed To Outside Partner or Direct Billed To Insider BU value.

    If you do not want the transaction amount to be distributed among partners using a DOI, you can specify that you want the entire amount to be directly billed to a single partner. If the single partner is an insider, you update the Direct Billed To Insider BU field. If the single partner is an outside partner, you update the Direct Billed To Outside Partner field.

    Note that you can have a value in only one of the following fields: DOI Name, the Direct Billed To Insider BU, or the Direct Billed To Outside Partner. Each record in the F09J11 must have a valid DOI or direct billed partner to complete the distribution process.

  • Remark

    You can enter a remark on any of the F09J11 records.

Note:

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

When you make changes to individual records using the editable fields in the grid, the system requires you to click OK on the form to apply the changes. However, when you use the mass update features, the system applies the changes immediately and does not require you to click OK on the form.

You can also use the P09J11 program to perform specific searches over the records in the F09J11. Using options on the form header, you can easily search for these types of records:

  • DOI or Direct Billed Not Assigned

    This option displays all records that have a blank DOI Name, blank Direct Billed To Outside Partner, and blank Direct Billed To Insider BU field. Oracle recommends doing this search after processing the R09J401 to identify and update these records. The system cannot successfully complete distribution processing for these records.

    If records exist when you use this search option, it is because no DOI rule matched the criteria of the F09J11 record. You might need to reevaluate your DOI assignment rules, and create additional rules for these transactions.

  • DOI or Direct Billed Assigned

    This option displays all records that include a value in the DOI Name, Direct Billed To Outside Partner, or Direct Billed To Insider BU field.

  • DOI Direct Billed Overridden

    This option displays all records where the value in the Original DOI Name, Original Direct Billed To Outside Partner, or Original Direct Billed To Insider BU field does not match the value in the DOI Name, Direct Billed To Outside Partner, or Direct Billed To Insider BU field respectively.

Mass Update Features

You can also use several mass update features to update multiple records at the same time. You can select records for mass update using the selection 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.

If you select records using the selection box, you can then select the Update Selected or Delete Dist Selected option from the Row menu on the Joint Venture Account Ledger Revisions form. If you use query criteria to search for the records you want to update, you can choose Update All, Delete All, or Delete Dist All from the Form menu. The Delete All option enables you to delete all the records included in your query that are not at the Process Complete status. The Delete Dist Selected and Delete Dist All options enable you to reset the distribution information of selected records or all the records included in your query. You can then enter a a new DOI or a direct billed partner to the records.

Note:

If you want to delete distribution records associated with the joint venture account ledger transaction, all the associated distributed details must not be at the Process Complete status. Distribution records at any other status can be deleted.

Both the Update Selected and Update All options enable you to make the following updates to the selected records:

  • DOI Name

    You can update the DOI for all selected records.

    Note that if you have selected records with a value in the Direct Billed To Outside Partner or Direct Billed To Insider BU field, the system clears that value and populates the DOI Name field with the value you specify.

  • Direct Billed To Outside Partner

    You can update the Direct Billed To Outside Partner used for direct billing for the selected records to an outside partner.

    Note that if you have selected records with a value in the DOI Name or Direct Billed To Insider BU field, the system clears that value and populates the Direct Billed To Outside Partner field with the value you specify.

  • Direct Billed To Insider BU

    You can update the Direct Billed To Insider BU used for direct billing for the selected records to an insider business unit.

    Note that if you have selected records with a value in the DOI Name or Direct Billed To Outside Partner field, the system clears that value and populates the Direct Billed To Insider BU field with the value you specify.

  • Transaction Status

    You cannot change the Transaction Status to Process Complete. If you want to prevent the transaction from being processed, you can delete the transaction or change the Transaction Status to On Hold.

  • Clear for Reassignment

    After using this option, the DOI and Direct Bill fields will be blank. You must rerun the R09J401 program to process the DOI Assignment Rules over the records.

  • Reset DOI or Direct Billed to Original

    This option returns the DOI and Direct Billed fields of the selected F09J11 records to the state they were in immediately after running the R09J401 program.

Note:

When using the mass update features, you can update only one of these values at a time:
  • DOI Name

  • Direct Billed To Outside Partner

  • Direct Billed To Insider Business Unit

  • Clear for Reassignment

  • Reset DOI or Direct Billed to Original

You can update the Transaction Status value by itself, or along with one of these options.

You can use the media object attachment feature to save and attach documents or files that are relevant to the joint venture.

For transactions where the amounts have been distributed to the partners, you can access the Work with JV Account Ledger program (P09J12) from the Row menu on the Joint Venture Account Ledger Revisions form. You use this program to review distribution information for the selected transaction. You can also revise the transaction status and remark for the transaction.

17.4.1 Reviewing and Revising Joint Venture Account Ledger Records

To review and revise Joint Venture account ledger records:

  1. From the Joint Venture Management module (G09J), click Daily Processing, and then JV Account Ledger Revisions.

  2. On the Joint Venture Account Ledger Revisions form, use any of the fields or options in the form header, the QBE line, or the advanced query to enter search criteria, and then click Find.

  3. Optionally, update the following values directly in the detail area of the form:

    • Transaction Status

    • DOI Name

    • Direct Billed To Outside Partner

    • Direct Billed To Insider BU

    • Remark

    To save your changes, click OK.

  4. To select multiple records for update, select the selection check box at the beginning of the row, and then select Update Selected from the Row menu.

    Alternatively, to update all of the records that are included in your current query results, select Update All from the Form menu. Note that this option includes all records that meet your current selection criteria. This could include more records than are currently displayed on your form.

  5. On the Joint Venture Account Ledger - Update All or Update Selected form, enter a value in or select one of these fields, and then click Update:

    • DOI Name

    • Direct Billed To Outside Partner

    • Direct Billed To Insider BU

    • Clear For Reassignment

    • Reset DOI or Direct Billed to Original

    You can also select a new value in the Transaction Status field in addition to specifying one of the above options, if necessary.

  6. Click Update and then click Yes on the confirmation form to confirm your update.

    The system returns you to the Joint Venture Account Ledger Revisions form and refreshes the data based on your updates.

17.4.2 Deleting Joint Venture Account Ledger Records

To delete joint venture account ledger records:

  1. From the Joint Venture Management module (G09J), click Daily Processing, and then JV Account Ledger Revisions.

    The system displays the Joint Venture Account Ledger Revisions form.

  2. Use any of the fields or options in the form header, the QBE line, or the advanced query to enter the search criteria, and then click Find.

  3. To delete one or more records, select the selection option at the beginning of the row for these records, and then click the Delete button.

    Alternately, to delete all of the records that are included in your current query results, select Delete All from the Form menu. Note that this option includes all records included in your query that meet your current selection criteria. This could include more records than are currently displayed on your form.

    On the confirmation window that is displayed, click Yes to confirm the delete.

    Note:

    The Delete button and Delete All option enable you to delete specific records or all the records that are not at the Process Complete status. After you delete the records from the F09J11 table, they can be added back to the table the next time you run the R09J400 program
  4. To delete the distributions associated with a joint venture account ledger record that is at a Process Complete status, select the selection option at the beginning of the row for the record, and then click Delete Dist Selected from the Row menu.

    Alternately, to delete the distributions for all the records that are included in your current query results, select Delete Dist All from the Form menu. Note that this option includes all records included in your query that meet your current selection criteria. This could include more records than are currently displayed on your form.

    On the confirmation window that is displayed, click Yes to confirm the delete.

  5. Note:

    The system deletes the distribution records for a joint venture account ledger transaction only when all of the associated distribution details are not at the Process Complete status.

    When the distribution records for a joint venture account ledger transaction is deleted, the transaction status for the joint venture account ledger record automatically resets to Available To Process. After the distribution records are deleted, you can now delete the account ledger record, if needed. You can then enter a a new DOI or a direct billed partner to the F09J11 record.

The system returns you to the Joint Venture Account Ledger Revisions form and refreshes the data based on your deletion.

17.5 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.

17.5.1 Transaction Type

The program also reads the joint venture account type and partner type for each transaction and determines whether to mark the transaction for creating an invoice, voucher, or journal entry.

  • A distribution transaction with a Revenue account type that is assigned to an outside partner is marked for creating a voucher in the F09J12 table.

  • A distribution transaction with a Capital Cost or Expense account type that is assigned to an outside partner is marked for creating an invoice in the F09J12 table.

  • A distribution transaction that is assigned to an insider business unit is marked for creating a journal entry irrespective of whether the account type is Revenue, Capital Cost, or Expense, unless the DOI indicates that invoices and vouchers are to be generated.

Note:

If the joint venture account type is Distribution Only, the system will not create a joint venture invoice, voucher, or journal entry for the transaction.

See Chapter 6, "Setting Up Account Information for Joint Ventures".

17.5.2 Cutback AAIs

For each transaction type (revenue, expense, or capital cost), the system also reads the joint venture cutback AAIs to identify the appropriate cutback account. The system will use the cutback account when creating the offset cutback entry in the Account Ledger table (F0911) when the you create joint venture invoices, vouchers, or journal entries. The joint venture cutback AAIs are:

  • JVCBR - Cutback Revenue

    If the transaction is a revenue transaction, the system uses the account that you define in this AAI.

  • JVCBC - Cutback Capital

    If the transaction is a capital cost transaction, the system uses the account that you define in this AAI.

  • JVCBE - Cutback Expense

    If the transaction is an expense transaction, the system uses the account that you define in this AAI.

When you run the R09J402 program, the system populates the appropriate AAI value in the Cutback AAI Item column for the record in the F09J12 table.

After the R09J402 completes processing, it produces a report. If there are transactions that the program is not able to distribute, the errors are reported to the work center and the R09J402 report contains the message Review Errors Written to Work Center. The program also updates the transaction status of the F09J11 records that could not be distributed to Error. If the transaction was successfully processed, the system changes the transaction status of the F09J11 records to Process Complete, and writes records to the F09J12 table.

17.5.3 Troubleshooting Transactions with Errors

When the R09J402 is unable to distribute a transaction amount, the transaction status of the F09J11 record is changed to Error. To view the records in error, you can use the Joint Venture Account Ledger Revisions program (P09J11) to review, and if necessary, revise the record.

In many cases, the reason a transaction might be in error is that the DOI that was assigned to the record was not active during the date associated with the transaction. To fix this error, you might need to update the DOI so that it is active during the service tax date on the transaction. Or, you might need to assign a different DOI to the transaction.

After you have fixed the error, you must then change the transaction status of the records in error back to Available to Process, and then rerun the R09J402 to distribute the transaction amount to the partners.

You can use the Update Joint Venture Transaction Status batch program (R09J410) to validate that the errors have been resolved in the distributed transactions and also to update the transaction status for the validated records to Available to Process.

See Section 17.8, "Updating Joint Venture Transaction Status Using a Batch Process (R09J410)".

17.5.4 Prerequisites

Before you complete the tasks in this section, set up the processing options for the Generate Joint Venture Distribution Detail program (R09J402).

  • On the Select tab, specify a ledger type that the system uses to select transactions from the Joint Venture Account Ledger table (F09J11). If you do not specify a ledger type, the system selects and processes transactions for the AA (Actual Amounts) ledger.

    Note that if you use multiple ledger types, you will require multiple versions of the R09J401 program.

  • On the Process tab, specify whether to set all AA ledger transactions that the system processes as Distribution Only transactions. Distribution Only transactions have the transaction status as Process Complete. You set up this processing option if you do not want to create joint venture invoices, vouchers, or journal entries for the partners.

17.5.5 Running the Generate Joint Venture Distribution Detail Program (R09J402)

From the Joint Venture Management module (G09J), select Periodic Processing, Distribute G/L Transactions, and then Generate Joint Venture Distribution Detail.

17.6 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.

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)

17.6.1 Prerequisite

Before you complete the tasks in this section, set up the following processing options for the Work with JV Account Ledger program (P09J12).

  • On the Defaults tab, enter values to these processing options:

    • Ledger Type: Specify a ledger type that the system uses to display records when you access the Work with JV Account Ledger program (P09J12). If this option is left blank, the system uses the AA ledger as the default ledger type.

    • Joint Venture Account Ledger Transactions: Specify whether to display all the joint venture account ledger transaction records or only the records that have a transaction status of Process Complete. If this option is left blank, the system displays records that have a transaction status of Process Complete.

    • Transaction Status for Redistribution: Specify the transaction status to set the redistribution record to when voiding or reversing distribution details that are assigned to cash calls. The valid statuses for this processing option are Available to Process (1), On Hold (2), and any user-defined status. If you leave this processing option blank, the system uses the transaction status On Hold (2).

  • On the Versions tab, specify the versions that you want to use for these programs: Journal Entries (P0911), Standard Invoice Entry (P03B11), and A/P Standard Voucher Entry (P0411). If you do not specify a version for these programs, the system uses ZJDE0001 as the default version.

  • On the Display tab, in the Display Cash Call Information processing option, specify whether to display the cash call information when reversing a distribution detail line. If you leave this processing option blank, the system does not display the cash call information.

17.6.2 Reviewing and Revising Joint Venture Account Distribution Records

To review and revise joint venture account distribution records:

  1. From the Joint Venture Management module (G09J), click Daily Processing, Joint Venture Inquiries, and then select Work with JV Account Ledger.

    The system displays the Work with Joint Venture Account Ledger form. If you have set the processing option to display only the distribution records that are at Process Complete status, the system displays only those records that are at Process Complete status.

  2. Use the fields in the header and QBE fields in the grid to filter records. You can filter records by transaction status, such as Available to Process, Available to Redistribute, Error, On Hold, or Process Complete.

  3. On the Work with Joint Venture Account Ledger form, review the account distribution information for the records by joint venture.

  4. Select the record you want to review, and then click Select.

  5. On the Revise Joint Venture Distribution Detail form, review the records, and optionally update these fields:

    • Transaction Status

    • Remark

    If the record is marked for redistribution (Joint Venture Void Code field = Available for Redistribution), you can also update these fields:

    • Insider Business Unit

    • Outside Partner

    • Distribution Only

    • Invoice/Voucher Insider

  6. Click OK to save your changes.

  7. To select multiple records for update, you must first perform your query. Then, select Update Status All from the Form menu.

    The system displays the Update Joint Venture Distribution Detail Status window.

    Enter the transaction status that you want to use, and click Update.

  8. Alternately, to update the status of specific transactions, select the records using the check box in the detail area of the form, and then select Update Selected from the Row menu.

    The system displays the Update Joint Venture Distribution Detail window.

    Enter values in these fields, and click Update:

    • Transaction Status

    • Outside Partner

    • Insider Business Unit

      You can update the outside partner and insider business unit only for redistribution records.

17.6.3 Deleting Joint Venture Account Distribution Records

To delete joint venture account distribution records:

Note:

You can delete only those F09J12 records that are not at the status of Process Complete.
  1. From the Joint Venture Management module (G09J), click Daily Processing, and then Work with JV Account Ledger.

    The system displays the Work with Joint Venture Account Ledger form. If you have set the processing option to display only the distribution records that are at Process Complete status, the system displays only those records that are at Process Complete status.

    You can also use the fields in the header and QBE fields in the grid to filter records. To filter records that are at the status of Process Complete, you can use the Transaction Status option in the header area of the form, or the Transaction Status QBE field in the grid.

  2. To delete the distributions associated with one or more records, select the records using the check box in the detail area of the form, and then select Delete Dist Selected from the Row menu.

    Click Yes to confirm the deletion.

  3. To delete all the distributions for the records included in your current query, you must first perform your query. Then, select Delete Dist All from the Form menu.

    Click Yes to confirm the deletion.

Note:

When you delete F09J12 records, the system automatically resets the transaction status for the corresponding F09J11 records to Available To Process. You can then enter a new DOI or a direct billed partner to the records and when you run the R09J402 program, the system recreates new F09J12 records.

17.6.4 Reversing Joint Venture Distribution Transactions (Release 9.2 Update)

You can reverse a single transaction, selected transactions, or all transactions in a document at the transaction level without affecting the distribution document that is associated with the transactions. The system voids the original transaction, reverses the transaction amount in the F09J12 table, and creates a new redistribution record, enabling you to redistribute the amount to a different partner, update the transaction as distribution only, or mark the transaction for invoicing or vouchering even if the amount is booked to the insider business unit.

To reverse joint venture distribution transactions, see Section 23.5, "Reversing a Joint Venture Distribution Transaction".

17.7 Reviewing Joint Venture Distribution Information by Partners (P09J12B and P09J12C)

After records exist in the F09J12 table, you can review the following information:

  • Summary of the distributed amount for each partner included in a joint venture and the total distributed amount for the joint venture

    You use the JV Distribution Summary by Partner program (P09J12B) to review this information.

  • Details and optionally, totals of the distribution for each partner included in each joint venture

    You use the JV Distribution Detail by Partner program (P09J12C) to review this information.

17.7.1 Reviewing Joint Venture Account Distribution Summary by Partner

The Joint Venture Distribution Summary by Partner program (P09J12B) enables you to review the total distributed amount and the distributed amounts for each partner summarized by:

  • Cost or expense

  • Revenue

  • Distributed amount that was invoiced

  • Distributed amount that was vouchered

17.7.1.1 Prerequisite

Before you complete the tasks in this section, set up the following processing options for the JV Distribution Summary by Partner program (P09J12B).

  • On the Defaults tab, in the Ledger Type processing option, specify a ledger type that the system uses to display records when you access the JV Distribution Summary by Partner program (P09J12B). If this option is left blank, the system uses the AA ledger as the default ledger type.

  • On the Process tab, enter values to these processing options:

    • Display Distributed Cost/Expense Amount: specify whether to display the Distributed Cost/Expense Amount column

      If this option is left blank, the system does not display the Distributed Cost/Expense Amount column.

    • Display Invoiced Amount: specify whether to display the Invoiced Amount column

      If this option is left blank, the system does not display the Invoiced Amount column.

    • Display Distributed Revenue Amount: specify whether to display the Distributed Revenue Amount column

      If this option is left blank, the system does not display the Distributed Revenue Amount column.

    • Display Vouchered Amount: specify whether to display the Display Vouchered Amount column

      If this option is left blank, the system does not display the Distributed Revenue Amount column.

    • Suppress Partners with Zero Amount: specify whether to suppress the partners that have zero amounts

      If this option is left blank, the system suppresses the partner with zero amounts.

    • Distributed Revenue Reverse Sign: specify whether to display distributed revenue as a positive value. If this option is left blank, the distributed revenue will be displayed as a negative value.

  • On the Versions tab, in the JV Distribution Detail by Partner (P09J12C) Version processing option, specify the version of the P09J12C program that you want the system to launch when you access the program from the Row menu of the Review Joint Venture Distribution Summary by Partner form. If this option is left blank, the system launches the ZJDE0001 version.

17.7.1.2 Reviewing a Joint Venture Account Distribution Summary by Partner

To review a joint venture account distribution summary by partner:

  1. From the Joint Venture Management module (G09J), click Daily Processing, Joint Venture Inquiries, and then select JV Distribution Summary by Partner.

  2. On the Review JV Distribution Summary by Partner form, complete the Joint Venture Name field.

    The system retrieves the joint venture company associated with the joint venture and populates the Currency and the Period and Year fields for this company.

  3. Use any of the fields or options in the form header or the QBE to enter the search criteria, and then click Find.

    You can filter records by:

    • Ledger Type

    • Period and Year of the joint venture company

    • Summary Type: Period, Year to Date, and Inception to Date

      The Period option retrieves records for the period and year specified.

      The Year To Date option retrieves records from the beginning of the fiscal year to the current period.

      The Inception To Date retrieves records since the beginning of the joint venture to the current period.

    The system displays records that match your search criteria in the detail area of the form. The program displays the distributed amount in different columns: Distributed Cost/Expense, Invoiced Amount (subset of the Distributed Cost or Expense), Distributed Revenue, and Vouchered Amount (subset of the Distributed Revenue).

  4. Review the aggregated balances of the amount that are distributed to each partner and the total distributed amount for the joint venture.

The Partner Dist Detail on the Row menu of the program enables you to access the distribution details by partner information for the selected record.

17.7.2 Reviewing and Revising Joint Venture Account Distribution Details and Totals by Partner

The JV Distribution Detail by Partner program (P09J12C) enables you to review distribution information by partners for each joint venture the partner is associated with. The transaction records are sequenced by the partner for each joint venture, and the system displays the distributed amounts by joint venture and partner. You can set the system to display the totals of the distributed amounts by partner. Therefore if a partner participates in multiple joint ventures, you would be able to review the distribution amounts and totals by joint venture, and the totals by partner.

Using this program, you can update the transaction status of each record, or perform a mass update of all records or selected records. You can also update the outside partner and insider business unit for redistribution records.

You can use the media object attachment feature to save and attach documents or files that are relevant to the joint venture.

17.7.2.1 Prerequisite

Before you complete the tasks in this section, set up the following processing options for the JV Distribution Detail by Partner program (P09J12C).

  • On the Defaults tab, enter values to these processing options:

    • Ledger Type: The system displays records associated with this ledger type when you access the JV Distribution Detail by Partner program (P09J12C). If this option is left blank, the system uses the AA ledger as the default ledger type.

    • Display Totals: Specify whether to display the totals of the distribution amounts by partner. If this option is left blank, the system displays the distribution totals by partner.

    • Transaction Status for Redistribution: Specify the transaction status to set the redistribution record to when voiding or reversing distribution details that are assigned to cash calls. If you leave this processing option blank, the system uses the transaction status On Hold (2).

  • On the Versions tab, specify the versions that you want to use for these programs: Journal Entries (P0911), Standard Invoice Entry (P03B11), and A/P Standard Voucher Entry (P0411). If you do not specify a version for these programs, the system uses ZJDE0001 as the default versions.

  • On the Display tab, in the Display Cash Call Information processing option, specify whether to display the cash call information when reversing a distribution detail line. If you leave this processing option blank, the system does not display the cash call information.

17.7.2.2 Reviewing and Revising Joint Venture Distribution Details by Partner

To review and revise a joint venture account distribution detail by partner:

  1. From the Joint Venture Management module (G09J), click Daily Processing, and then JV Distribution Detail by Partner.

  2. On the Revise Joint Venture Distribution Detail by Partner form, click Find.

    The system displays all the distribution records by the partner for all the joint ventures. The distribution amount totals by partner is displayed if you have set the processing option to display totals, or you have selected the Display Totals option in the header area of the form.

  3. Use the advanced query or any of the fields or options in the form header or the QBE to enter search criteria, and then click Find.

    The system displays records that match your search criteria in the detail area of the form.

  4. Review the aggregated balances of the amount that are distributed to each partner for each joint venture, and the total distributed amount for all of the joint ventures the partner is involved in.

    Note that if the joint ventures (a partner is involved in) operate in multiple currencies, the total distributed amount for that partner across the joint ventures will not be displayed.

  5. To update the records:

    • For an individual record, click the Transaction Status field for the record and select a status. You can also update the remark, and the outside partner and insider business unit if the record is a redistribution record. Then, click OK on the form to save your changes.

    • For multiple records, select the records that you want to update and click Update Selected on the Row menu.

      On the Update JV Distribution Detail Status form, specify the new status in the Transaction Status field, update the outside partner or insider business unit for redistribution records, and then click Update.

    • For all the records, click Update Status All on the Form menu.

      On the Update JV Distribution Detail Status form, specify the new status in the Transaction Status field, and then click Update.

    • To reverse individual or multiple transactions in a document, select the transactions and click Reverse Selected on the Row menu.

      On the Reverse Joint Venture Distribution Detail window, update the reverse date, if required, and click Reverse.

    • To reverse all transactions in a document based on a query, you must first perform your query. Then, click Reverse All on the Form menu.

      On the Reverse Joint Venture Distribution Detail window, update the reverse date and the transaction redistribution status, if required, and click Reverse.

      Note:

      The system displays the Transaction Redistribution Status field only for the distributed transactions that are assigned to cash calls, and only if you have specified in the processing option to display cash call information.

      For more information on reversing joint venture distribution transactions, see Section 23.5, "Reversing a Joint Venture Distribution Transaction".

The Dist Doc Detail on the Row menu of the program enables you to access the joint venture invoice, voucher, or journal entry information for the selected record on the corresponding system (Accounts Receivable, Accounts Payable, or General Accounting).

17.8 Updating Joint Venture Transaction Status Using a Batch Process (R09J410)

After you resolve issues in those distributed transactions that are in error, you must update the transaction status from In Error to Available to Process in order to process the transactions again.

Run the Update Joint Venture Transaction Status batch program (R09J410) to validate that errors have been resolved in the distributed transactions and also to update the transaction status for the validated records to Available to Process. If the system finds that some transactions are still in error, the transaction status of those records will not be updated. This program provides an easier way to validate and update the transaction status of multiple records to Available to Process so that they can be processed.

For example, a supplier master record is missing for a partner and because of this missing setup, many F09J12 records for that partner are set to error. After you create the supplier master record for the partner, you can run the R09J410 program to validate and update all of the F09J12 records of the partner to Available to Process.

17.8.1 Prerequisite

Before you complete the task in this section, set up data selection to include the transactions records in the F09J12 table for which you want to update the transaction status.

17.8.2 Running the Update Joint Venture Transaction Status Program (R09J410)

From the Joint Venture Management module (G09J), select Daily Processing, and then Update Joint Venture Transaction Status.