Running the R09123 Program for Account Balance-Based Allocations

For account balance-based allocations, the R09123 program performs the following tasks:

• Launches versions of the R09123B program. The versions contain the data selection for source accounts and basis accounts. You identify the versions for each allocation in the Advanced Variable Numerator program (P09123).

• Retrieves records from the F0006, F0901, and F0902 tables, based on the specifications that you set up for the allocation in the P09123 program.

• Calculates the allocation percentage based on the values of the basis ratio. You can select any of these variables as the basis ratio for an allocation:

  • Business units.

  • Related business units.

  • Category codes 1–50.

  • Business unit types.

• Allocates amounts and units from the source accounts to the destination account based on the percentage calculated from the basis accounts or, if applicable, the business unit overrides. Creates journal entries in the F0911 table.

• Creates offset amounts in the F0911 table to balance the allocation entries.

• Prints the source, basis, destination, and offset records on the Compute Advanced Variable Numerator Allocations report (R09123).

  The R09123 report also lists detailed allocation information and errors, such as invalid accounts and entries posted before cutoff (PBCO). You should create different versions of this program for recurring frequencies, specific companies, and specific document types. Doing this allows you to include specific groups of allocations.

• Incrementally increases the general ledger date on the allocation according to the recurring frequency. This process ensures that the allocation is ready for future processing.