29 Revise Account Structures

This chapter contains these topics:

29.1 Revising Account Structures

Navigation

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

On Structure Revisions

Figure 29-1 Structure Revisions screen

Description of Figure 29-1 follows
Description of "Figure 29-1 Structure Revisions screen"

  1. Complete the following fields:

    • Type Structure

    • Skip to Sort Number (optional)

    • Skip to Account (optional)

  2. Change any of the following fields:

    • Sort Number

    • Target Obj

    • Target Sub

    • LD (Account Level of Detail)

  3. 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.

29.1.1 Processing Options

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.

29.2 Printing Account Structures

Navigation

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.