89 Multi-Site Consolidation Processing Options

This chapter contains these topics:

89.1 Business Unit Structure Build (P10450)

Processing Option Processing Options Requiring Further Description
MODE:  
1. Enter the mode the calculations and update will be processed in:

0 = Proof mode with Report (Default)

1 = Final mode with Report

2 = Final mode without Report

  
STRUCTURE NAME:  
2. Enter the name of this Business Unit Type Structure.  
BUSINESS UNIT CREATION:  
3. Enter a '1' for Dynamic Business Unit Creation with concatenation of Category code values to determine the new Business Unit.

Enter a '2' for Dynamic Business Unit Creation with Next Numbering to determine the new Business Unit.

Leave blank for no Dynamic Business Unit Creation.

  
4. Enter the Business Unit Type to use when creating business units.  
5. Enter the Pseudo Consolidation Company to be used for Business Unit Creation.

If left blank, Company '00000' will be used.

  

89.2 Account Structure Build (P10430)

Processing Option Processing Options Requiring Further Description
MODE:  
1. Enter the mode the calculations and update will be processed in:

0 = Proof mode with Report (Default)

1 = Final mode with Report

2 = Final mode without Report

  
STRUCTURE NAME:  
2. Enter the name of this account structure.  
TYPE OF BUILD:  
3. Enter a '1' to add records to an existing structure.

The default of blank will build a new structure.

  
TARGET OBJECT/SUB:  
4. Enter the field(s) to use to load the Target Object. If multiple fields are used, their values will be concatenated together to form the Target Object.

The default of blank will leave Target Object blank.

Field 1:

Field 2:

Field 3:

Note: Valid fields are Alternate Object 'OBJA', Object 'OBJ', and Category Codes R001 - R023.

  
5. Enter the field(s) to use to load the Target Subsidiary. If multiple fields are used, their values will be concatenated together to form the Target Sub.

The default of blank will leave Target Sub blank.

Field 1:

Field 2:

Field 3:

Note: Valid fields are Alternate Subsidiary 'SUBA', Subsidiary 'SUB', and Category Codes R001 - R023.

  
LEVEL OF DETAIL:  
6. Enter the field that contains the account level of detail.

The default of blank will use the Account Level of Detail field LDA.

Note: Valid fields are Category Codes R001 - R023 and Account Level of Detail 'LDA'.

  

89.3 Build Multi-Site Transfer File (P10550)

Processing Option Processing Options Requiring Further Description
MODE:  
1. Enter the mode the calculations and updating will be processed in:

0 = Proof mode with report (Default)

1 = Final mode with report

2 = Final mode without report

  
FISCAL PERIOD/YEAR:  
2. Enter the fiscal year and period through which the consolidation is to be prepared.

Leave blank to use the financial reporting year and period.

Year:

Period:

  
TO LEDGER TYPE:  
3. Enter the Ledger type to be used for consolidation.

If left blank, 'AA' will be used.

  
PSEUDO COMPANY:  
4. Enter the number of your pseudo consolidation company.

If left blank, company '00000' will be used.

  
REPORT FORMATTING FACTOR:  
5. Enter a '1' to print amounts without separator characters.

The default of blank will print amounts with separator characters.

  
6. Enter a value from '0' to '9' to scale the amounts printed on the report.

The default of blank will not scale the amounts.

  
CONSOLIDATION VARIANCE:  
7. Enter a variance threshold for creating an automatic write-off for consolidations. If a variance exists in the consolidations that were created, and the variance is within the tolerance, an automatic write-off will be created.

Leave blank if you do not wish to use this feature.

Note: If the variance entered is a percentage, use the % character. For example, 3 percent would be entered as 3%.

  
8. Enter the Object and Subsidiary to be used for the write-off Multi-Site Transfer record.

Object:

Subsidiary:

  
9. Enter a '1' to save Business Unit Category Codes for transmission.

Enter a '2' to save Account Category Codes for transmission.

Enter a '3' to save both Business Unit and Account Category Codes for transmission.

The default of blank will not save category code values for transmission.

  

89.4 Consolidation File Control (P10610)

Processing Option Processing Options Requiring Further Description
REQUIRED INTEGRITIES:  
1. Enter a '1' next to the Integrities that are required before the Consolidation Batch may be Transmitted.

If left blank, the integrity failure or non-execution will not affect transmission.

Prior Period Adjustments

Credits = Debits

Source UDC = Target UDC

Source Obj/Sub = Target Obj/Sub

Accounts Last Month Not This

BU Last Month Not This Month

Accounts This Month Not Last

BU This Month Not Last

  
ALTERNATE TAPE CREATION PROCESSING:  
2. Enter the name of an alternate tape creation or transmission program to be used.

If left blank, program J1055011 will be used.

  
3. Enter the DREAM Writer version of the Tape Creation Program being called.

If left blank, version XJDE0001 will be used.

  

89.5 Previous Balance Integrity (P10700)

Processing Option Processing Options Requiring Further Description
INTEGRITY STATUS:  
1. Enter a '1' to force the integrity to fail if a previous consolidation record is not found for comparison.

If left blank, a message will be printed on the report if a previous balance is not found, but it will not cause an error condition or integrity failure.

  

89.6 Create UDC Control File (P10005)

Processing Option Processing Options Requiring Further Description
UDC CONTROL FILE VERSION:  
1. Enter the unique name of the UDC Control File version you would like to create.

Default will use a name of blank.

  

89.7 UDC Value Control (P107011)

Processing Option Processing Options Requiring Further Description
UDC CONTROL FILE VERSION:  
1. Enter the unique name of the UDC Control File version you would like to use.

Default will use a name of blank.

  

89.8 Obj/Sub Value Control (P107021)

Processing Option Processing Options Requiring Further Description
OBJ/SUB VALUE CONTROL FILE VERSION:  
1. Enter the unique name of the Obj/Sub Control File version you would like to use.

Default will use a name of blank.

  
FILE DATA SELECTION:  
2. Enter a '1' to check unique object and subsidiary.

Default will check unique object only.

  

89.9 Obj/Sub Value Control (P107021)

Processing Option Processing Options Requiring Further Description
OBJ/SUB VALUE CONTROL FILE VERSION:  
1. Enter the unique name of the Obj/Sub Control File version you would like to use.

Default will use a name of blank.

  
FILE DATA SELECTION:  
2. Enter a '1' to check unique object and subsidiary.

Default will check unique object only.

  

89.10 Business Units & Accounts This Period Not Last (P10701)

Processing Option Processing Options Requiring Further Description
CONSOLIDATION STATUS:  
1. Enter the status of the 'Previous' consolidation you wish to match the Current consolidation to.

If left blank, an error will be printed and the integrity will not be run.

  
INTEGRITY STATUS:  
2. Enter a '1' to force the integrity to fail if a previous consolidation is not available at the status specified for comparison.

If left blank, a message will be printed if a previous consolidation is not found but the integrity will not fail.

  

89.11 Business Units & Accounts This Period Not Last (P10701)

Processing Option Processing Options Requiring Further Description
CONSOLIDATION STATUS:  
1. Enter the status of the 'Previous' consolidation you wish to match the Current consolidation to.

If left blank, an error will be printed and the integrity will not be run.

  
INTEGRITY STATUS:  
2. Enter a '1' to force the integrity to fail if a previous consolidation is not available at the status specified for comparison.

If left blank, a message will be printed if a previous consolidation is not found but the integrity will not fail.

  

89.12 Multi-Site Simple Balance Sheet (P10150)

Processing Option Processing Options Requiring Further Description
FORMAT:  
1. Enter a '1' to print liability accounts as negative amounts.

If left blank, the accounts will print as positive amounts.

  
ACCOUNT DESIGNATIONS:  
2. Enter the beginning object for each of the following.

If left blank, the Automatic Accounting Instruction designated will be used. Beginning Stockholder's Equity is a required field.

Beginning Assets GLG2

Beginning Liabilities GLG3

Beginning Stockholders Equity

YTD Income or Loss GLG5

  

89.13 Multi-Site Simple Income Statement (P10250)

Processing Option Processing Options Requiring Further Description
FORMAT:  
1. Enter a '1' to print expense and liability accounts as negative amounts.

If left blank, the accounts will print as positive amounts.

  
ACCOUNT DESIGNATIONS:  
2. Enter the beginning object for each of the following categories.

If left blank, the Automatic Accounting Instruction designated on each category will be used.

Beginning Revenue GLG6

Beginning Cost of Goods Sold GLG8

Beginning Other Income GLG11

Beginning Other Expense GLG13

  

89.14 Consolidation File Control (P10610)

Processing Option Processing Options Requiring Further Description
REQUIRED INTEGRITIES:  
1. Enter a '1' next to the Integrities that are required before the Consolidation Batch may be Transmitted.

If left blank, the integrity failure or non-execution will not affect transmission.

Prior Period Adjustments

Credits = Debits

Source UDC = Target UDC

Source Obj/Sub = Target Obj/Sub

Accounts Last Month Not This

BU Last Month Not This Month

Accounts This Month Not Last

BU This Month Not Last

  
ALTERNATE TAPE CREATION PROCESSING:  
2. Enter the name of an alternate tape creation or transmission program to be used.

If left blank, program J1055011 will be used.

  
3. Enter the DREAM Writer version of the Tape Creation Program being called.

If left blank, version XJDE0001 will be used.

  

89.15 Journalize Consolidation Balances (P10480)

Processing Option Processing Options Requiring Further Description
MODE:  
1. Enter the mode the update will be processed in:

0 = Proof mode with Report (Default)

1 = Final mode with Report

2 = Final mode without Report

  
CONSOLIDATION COMPANY:  
2. Enter the Consolidation Company to update.

If left blank the company defined in the Consolidation Transmission file F1001 will be used.

  
LEDGER TYPE:  
3. Enter the Ledger Type to update.

If left blank, the ledger defined in the Consolidation Transmission file will be used.

  
PRIOR PERIOD ADJUSTMENTS:  
4. Enter a '1' to create adjusting entries to prior periods for differences between the current and previous consolidation.

Enter a '2' to create the adjusting entries in the current period.

Enter a '3' to ignore prior period differences.

If left blank, adjusting entries will not be created, the record will not be processed, and an error will be written to the report.

  
5. Enter a '1' to directly update the Account Balances file (F0902) for Balance Forward differences between the current and previous consolidation.

If left blank, the Account Balances file will not be updated.

  
DYNAMIC BUSINESS UNIT CREATION:  
6. Enter a '1' to dynamically create business units that exist in the Consolidation file but do not exist in the Business Unit Master.

Leave blank for no Dynamic Business Unit Creation.

  
7. Enter the Business Unit Type to use when creating business units.  
DYNAMIC ACCOUNT CREATION:  
8. Enter a '1' to dynamically create accounts that exist in the consolidation file but do not exist in the Account Master.

Enter a '2' to dynamically create accounts that exist in the consolidation file but do not exist in the Account Master by editing the Object only. If the Object exists in the account master model, the account will be created regardless of the Subsidiary.

Leave blank for no Dynamic Account Creation.

  
AUTOMATIC BATCH JOURNAL ENTRY PROCESSING:  
9. Enter a '1' to automatically submit to Process Batch Journal Entries after processing/creating batch journal entries.

If left blank, Process Batch Journal Entries will not be automatically submitted.

  
10. Enter the DREAM Writer version of Process Batch Journal Entries to be executed.

The default is version XJDE0001.

  

89.16 Stand Alone Eliminations (P10570)

Processing Option Processing Options Requiring Further Description
MODE:  
1. Enter the mode the calculations and updating will be processed in:

0 = Proof mode with report (Default)

1 = Final mode with report

2 = Final mode without report

  
FISCAL PERIOD/YEAR:  
2. Enter fiscal year and period through which the elimination is to be prepared.

Leave blank to use the financial reporting year and period.

Year:

Period:

  
TO LEDGER TYPE:  
3. Enter the Ledger type to be used for consolidation.

If left blank, 'AA' will be used.

  
PSEUDO COMPANY:  
4. Enter the number of your pseudo consolidation company.  
ELIMINATION VARIANCE:  
5. Enter a variance threshold for creating an automatic write-off for eliminations. If a variance exists in the eliminations that were created, and the variance is within the tolerance, an automatic write-off will be created.

Leave blank if you do not wish to use this feature.

Note: If the variance entered is a percentage, use the % character. For example, 3 percent would be entered as 3%.

  
6. Enter the Object and Subsidiary to be used for the write-off journal entry.

Object:

Subsidiary: