Prerequisite

Before you complete the tasks in this section, set up the following processing options for the Joint Venture Account Ledger and Dist Detail Revisions batch program (R09J412).

• On the Default tab, in the Action Code processing option field, specify the action that is performed when you run the R09J412 batch program. The valid codes are:

  • 1 - Update Account Ledger
  • 2 - Delete Account Ledger
  • 3 - Delete Distribution Detail

  If you leave this field blank,the report ends with an error.

  Note: If you select the option to Update Account Ledger, ensure that you specify the field that should be updated in the Update Field processing option in the Update tab.

• On the Update tab, specify the values for these processing options:

  • Update Field: Specify the field that should be updated when you run the R09J412 batch program. To update the field, the system uses this processing option in conjunction with the respective values set for processing options DOI Name, Direct Billed to Outside Partner, and Direct Billed to Insider Business Unit.

    For example, if you specify DOI Name (1) as the Update Field value, the system updates the DOI Name field for all the records with the value set in the DOI Name processing option.

    The valid codes are:

    • 1 - DOI Name
    • 2 - Direct Billed to Outside Partner
    • 3 - Direct Billed to Insider Business Unit
    • 4 - Clear for reassignment
    • 5 - Reset DOI or Direct Billed to Original
    Note: The Clear for reassignment value enables you to reset the fields, DOI Name (JVDOI), Original DOI Name (JVODOI), Direct Billed to Outside Partner (JVDBTP), Original Direct Billed to Outside Partner (JVODBTP), Direct Billed to Insider Business Unit (JVDBTIBU), and Original Direct Billed to Insider Business Unit (JVODBIBU). When you select this value, the system clears the values in these fields for the selected records in the Joint Venture Account Ledger table (F09J11). After selecting this value, you must run the process to assign DOI or Direct Billed to Original before you run the distribution process.

    Note: The Reset DOI or Direct Billed to Original value returns the DOI and Direct Billed fields of the selected F09J11 records to the state they were in immediately after running the R09J401 program.

  • DOI Name: Specify an alphanumeric division of interest (DOI) name that must be used to update the DOI name in all the selected records.

  • Direct Billed to Outside Partner: Specify the direct billed to outside partner that must be updated in all the selected records.

  • Direct Billed to Insider Business Unit: Specify the direct billed to insider business unit that must be updated in all the selected records.
  • Transaction Status: Enter a user-defined code (from UDC 09J/TS) that indicates the transaction status that must be set for the selected joint venture account ledger records. The valid codes are Available to Process (1) and On Hold (2). You cannot change the transaction status to Process Complete.