27 Define Multi-Site Consolidations
This chapter contains these topics:
27.1 Defining Multi-Site Consolidations
Before you can consolidate account balances, you must define the structure of the consolidation. For multi-site consolidations, you define the business unit structure separately from the account structure. The combination of the account structure and business unit structure represents the multi-site consolidation structure.
| Structure | Provides |
|---|---|
| Business unit | Where: Business unit |
| Account | What: Object.Subsidiary |
Defining multi-site consolidations consists of:
-
Defining business unit structures
-
Defining account structures
27.2 Defining Business Unit Structures
You can create business unit structures manually using the Structure Revisions program (P0050) or have the system generate the structure for you. The system uses the business unit structure to create the Multi-Site Transfer (F1001, F1002, F1003) tables that contain consolidated balances to be sent to the target company.
Defining business unit structures consists of:
-
Generating business unit structures
-
Reviewing business unit structures
-
Revising business unit structures
-
Printing business unit structures
27.2.1 Generating Business Unit Structures
From Financial Reports (G10), choose Multi-Site Consolidations
From Multi-Site Consolidations (G1021), choose Setup (G1042), and then Structure Build under the Define Business Unit Summarization heading
The Structure Build program generates the business unit structure. When generating the structure, the system reads business unit category codes in the Business Unit Master (F0006) table in the sequence you specify and creates the business unit structure based on the sequence. You can review and revise this structure.
You can run this batch program in proof or final mode. In proof mode, the system prints a report which displays the hierarchy of the business unit structure but does not update the Organization Structure Master (F0050) table.
In final mode, the system updates the Organization Structure Master table with the structure information. The system prints a report which displays the hierarchy of the structure if you set the processing options accordingly. Only the columns that you specify for the data sequence appear on the report, and they appear in the sequence you specify. The system marks with an asterisk (*) any business units that it created dynamically.
27.2.2 What You Should Know About
| Topic | Description |
|---|---|
| Rerunning the Structure Build program | Each time you run the Structure Build program, the system rebuilds the structure. |
| Making manual changes to the structure | If you make changes to the business unit parent-child structure manually, you might want to change the category codes for the business units to show the new relationships.
Otherwise, the next time you run the Structure Build program, the system rebuilds the structure and overwrites your changes. |
| Creating multiple structures | You can create multiple structures for different reporting requirements. You might want one structure to represent the financial organizational structure, another for the functional organizational structure, and so on. You use a processing option to enter the name of the structure you are building. |
Business Unit Structure Build Report
The Business Unit Structure Build report shows the business units in the parent-child structure. Only the columns that you specify for the data sequence appear on the report, and they appear in the sequence you specify. The system marks with an asterisk (*) any business units that it created dynamically.
Figure 27-1 Business Unit Structure Build report, Financial Rollup
Description of "Figure 27-1 Business Unit Structure Build report, Financial Rollup"
27.2.3 Processing Options
See Section 89.1, "Business Unit Structure Build (P10450)".
Data Selection for Build Multi-Site Summarization - Business Units
You must set the first sequenced field NE *BLANKS. The system selects only the business units that are specified in the category codes that follow.
Data Sequence for Build Multi-Site Summarization - Business Units
You can enter a maximum of nine fields for sequencing. You can sequence on Business Unit, Business Unit Type, and category codes 1-30.
27.2.4 Reviewing Business Unit Structures
From Financial Reports (G10), choose Multi-Site Consolidations
From Multi-Site Consolidations (G1021), choose Setup (G1042), and then Structure Build under the Define Business Unit Summarization heading
You can review your business unit structures online. The system displays the hierarchies for a particular business unit according to structure type, using one of three modes:
-
Single-level structure
-
Multi-level structure without indentation
-
Multi-level structure with indentation
27.2.5 Revising Business Unit Structures
From Financial Reports (G10), choose Multi-Site Consolidations
From Multi-Site Consolidations (G1021), choose Setup (G1042), and then Structure Revisions under the Define Business Unit Summarization heading
After you review your business unit structures, you might want to revise them. You can add or delete business units from the hierarchy, or delete a business unit and all of the business units lower than it in the hierarchy.
27.2.6 What You Should Know About
| Topic | Description |
|---|---|
| Defining the entire structure | You can define your entire business unit structure by using the Structure Revisions program, but it is more efficient to run Structure Build (P10450) to generate the structure and then make changes individually if necessary.
If you make changes to the business unit parent-child structure manually, you may want to change the category codes for the business units to show the new relationships. Otherwise, the next time you run the Structure Build program; the system rebuilds the structure and overwrites your changes. |
27.2.7 Printing Business Unit Structures
From Financial Reports (G10), choose Multi-Site Consolidations
From Multi-Site Consolidations (G1021), choose Setup (G1042), and then Structure Report under the Define Business Unit Summarization heading
After you create or revise business unit structures, you can print a report that shows the complete hierarchies for one of the following:
-
All business units
-
A single business unit
-
Business units highest in the hierarchy
27.3 Defining Account Structures
The system creates an initial account structure based on the Account Master (F0901) table. You can review and revise this structure.
Defining the account summarization structure consists of:
-
Generating the account structure
-
Revising the account structure
-
Printing the account structure
27.3.1 Before You Begin
-
Set up a pseudo company in Company Numbers and Names for the consolidated account balances
27.3.2 Generating Account Structures
From Financial Reports (G10), choose Multi-Site Consolidations
From Multi-Site Consolidations (G1021), choose Setup (G1042), and then Structure Build under the Define Account Summarization heading
Before you can consolidate account balances, you generate the account structure that the system will use for the consolidation.
This batch program reads the Account Master table and creates the account structure based on the sequence that you specify. The system creates one record in the structure for each unique object and subsidiary combination.
The program can add records to an existing account structure, or it can create a new account structure. The system deletes the existing structure if you set the processing option to create a new account structure that has an existing structure name.
You can run the Structure Build program in proof or final mode. In proof mode, the system prints a report but does not update the Multi-Site Consolidation Build File - Accounts (F10430) table.
In final mode, the system updates the Multi-Site Consolidation Build File - Accounts table. The system prints a report if you set the appropriate processing option.