This chapter contains these topics:
From Financial Reports (G10), choose Multi-Site Consolidations
From Multi-Site Consolidations (G1021), choose Setup
From Setup (G1042) choose Structure Revisions under the Define Account Summarization heading
After you generate the account summarization structure for multi-site consolidations, you can review it online and revise it if necessary.
The columns appear in the sequence that you defined for the structure. Additional columns appear in the detail area if necessary.
The Structure Revisions program updates the Multi-Site Consolidation Build File - Accounts table.
To revise an account structure
Complete the following fields:
Type Structure
Skip to Sort Number (optional)
Skip to Account (optional)
Change any of the following fields:
Sort Number
Target Obj
Target Sub
LD (Account Level of Detail)
To change the record, press Enter.
Field | Explanation |
---|---|
Organization Type Structure | A user defined code (00/TS) that identifies the type of account structure, such as financial or responsibility. Each type structure can have a different hierarchy. |
Sort Number | Number used to sort and consolidate accounts for multi-site consolidation. |
Target Object Account | The object account that the system uses for mapping in multi-site consolidations when the target object is different from the source object. |
Target Subsidiary | The subsidiary account that the system uses for mapping in multi-site consolidations when the target subsidiary is different from the source subsidiary. |
Account Level of Detail | A number that summarizes and classifies accounts in the general ledger. You can have up to 9 levels of detail. Level 9 is the most detailed and 1 the least detailed. Example:
3 – Assets, Liabilities, Revenues, Expenses 4 – Current Assets, Fixed Assets, Current Liabilities, and so on 5 – Cash, Accounts Receivable, Inventories, Salaries, and so on 6 – Petty Cash, Cash in Banks, Trade Accounts Receivable, and so on 7 – Petty Cash - Dallas, Petty Cash - Houston, and so on 8 – More Detail 9 – More Detail Levels 1 and 2 are reserved for company and business unit totals. When using the Job Cost system, Levels 8 and 9 are reserved for job cost posting accounts. |
See Section 89.2, "Account Structure Build (P10430)"
Data Selection for Build Multi-Site Summarization - Accounts
You must set the first sequenced field NE *BLANKS. The system selects only the accounts that are specified in the category codes that follow.
Data Sequence for Build Multi-Site Summarization - Accounts
You can enter a maximum of nine fields for sequencing. The object and subsidiary fields must be the last fields in the sequence.
From Financial Reports (G10), choose Multi-Site Consolidations
From Multi-Site Consolidations (G1021), choose Setup (G1042), and then Structure Report under the Define Account Summarization heading
After you create or revise the account summarization structure, you can print a report that shows the complete hierarchy of the structure.