Prerequisites

Before you complete the tasks in this section:

• Set up distribution ledger types using the Distribution Ledger Types program (P09J25).

  See Setting Up Distribution Ledgers for Financial Reporting (Release 9.2 Update).

• Set up processing options for the Generate Distribution Ledgers program (R09J500).

  • On the Select tab, enter values to the following processing options:

    • Source Ledger Type: The source ledger to use for selecting transactions from the Joint Venture Distribution Detail table (F09J12). If you leave this processing option blank, the system selects transactions associated with the AA (Actual Amounts) ledger type.

    • Fiscal Year: The accounting fiscal year to be used for selecting transactions from the Joint Venture Distribution Detail table (F09J12). If this processing option is left blank, the system uses the current fiscal year for the joint venture company.

    • Period Number: A number (from 1 to 14) that identifies the accounting period to be used for selecting transactions from the Joint Venture Distribution Detail table (F09J12). If this processing option is left blank, the system uses the current G/L period for the joint venture company.

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

    • Generate Distribution Ledgers: Specify whether to generate the managing distribution ledger or the non-managing distribution ledger, or both. If this processing option is left blank, the system generates both the ledgers.

    • G/L Date Value: Specify whether the end date of the current financial period for the joint venture company or a specific date will be used as the G/L date. If this processing option is left blank, the joint venture company's current period end date will be assigned as the G/L date to the journal entries created for the distribution ledgers. Otherwise, the date specified in the G/L Date processing option will be used as the G/L date.

    • G/L Date: The date that you enter in this processing option will be assigned to the journal entries during distribution ledger creation. If this processing option is left blank, the system date is used.

      Note that even if you do not opt to create distribution journal entries, the date used in this processing option will be used to determine the period number and fiscal year used to update the account balances table.

    • G/L Updates: Specify whether to create journal entries in addition to updating the account balances records for the distribution ledgers. If this processing option is left blank, the system creates only account balances records.

    • Bypass Units Ledger: Specify whether to create journal entries for the units ledger. If this processing option is left blank, journal entries for the units ledger will be created.

• Set up data selection to include the joint ventures for which you want to generate distribution ledgers.