31 Consolidate Multi-Site Information

This chapter contains these topics:

After you define the account and business unit summarization structures and the rules for multi-site consolidations for the source company, you are ready to consolidate your multi-site information.

31.1 Creating Consolidated Balances

Navigation

From Financial Reports (G10), choose Multi-Site Consolidations

From Multi-Site Consolidations (G1021), choose Process Consolidations

When you create consolidated balances, the system reads the business unit and account structures that you defined in the sequence that you specified. The system processes these structures based on the rules that you defined for multi-site consolidations and based on the processing options. The system reads account balances from the Account Balances table (F0902) and does the following:

  • Eliminates intercompany balances between consolidated companies

  • Performs other eliminations based on the consolidation rules and on AAIs

  • 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

This batch program writes the consolidated balances to the Multi-Site Transfer (F1001, F1002, and F1003) tables.

31.1.1 What You Should Know About

Topic Description
Automatic eliminations of intercompany transactions This program eliminates two types of intercompany transactions:

  • Transactions between companies that are being consolidated

  • Automatic intercompany settlements that result from intercompany transactions
Processing a consolidation multiple times The system keeps the consolidation name and account balances in the Multi-Site Transfer table until you delete them. You cannot create new consolidated balances until previous consolidations are processed and transmitted.

31.1.3 Data Selection for Build Multi-Site Transfer File

Enter the name of the consolidation. This is the name you assigned when you defined the consolidation rules.

31.1.4 Data Sequence for Build Multi-Site Transfer File

Data sequencing does not apply to this program. The system uses the sequences that you have defined for business unit and account structures.

31.2 Verifying Consolidated Balances

When you process multi-site consolidations, the system produces two different reports. The first report has two parts. The first part of the report shows the summarized account balances that were written to the Multi-Site Transfer table for periods one through six. The second part of the report shows the same information for periods seven through 14.

The second report shows the accounts and corresponding amounts that were eliminated because of the consolidation of intercompany balances.