Understanding the Process Consolidations Program

After you define the account and organizational structures and the rules for multisite consolidations for the source company, you are ready to create the consolidated balances.

When you run the Process Consolidations program (R10550) to create consolidated balances, the system reads the account and organizational structures that you defined in the sequence that you specified. The system then processes these structures, based on the rules that you defined for multisite consolidations and eliminations, and based on the processing options. The system reads account balances from the F0902 and:

  • Omits zero balance accounts.

  • Consolidates year-to-date balances.

  • Matches up fiscal date patterns for account balances.

  • Ignores balances after the as of period.

  • Performs rounding.

  • Maintains the specified subledger and currency detail.

  • Creates account balances at the specified levels of detail.

  • Writes off variances within the specified limits.

  • Eliminates intercompany balances.

The Process Consolidations program writes the consolidated balances to these tables:

  • Multi-Site Consolidation Transfer File Header (F1001)

  • Multi-Site Consolidation Transfer (F1002)

  • Multi-Site Consolidation Transfer - Category Codes (F1003)