Go to main content
1/116
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I Allocations
1
Overview to Allocations
1.1
Objectives
1.2
About Allocations
1.2.1
Why Use Allocations?
1.2.2
What Are The Types of Allocations?
1.2.3
Are There Other Methods of Setting Up Allocations?
1.2.4
How Can You Use Cost Allocations?
1.2.5
How Can You Use Variable Numerator Allocations?
1.2.6
How Can You Use Indexed Allocations?
1.2.7
What Are the Similarities Among the Different Types?
1.2.7.1
Multi-Tiered Allocations
1.2.8
Common Allocation Errors
2
Work with Cost Allocations
2.1
Setting Up Cost Allocations
2.1.1
What You Should Know About
2.1.2
What You Should Know About
2.1.3
Processing Options
2.2
Reviewing Cost Allocations
2.2.1
Processing Options
2.3
Calculating Cost Allocations
2.3.1
What You Should Know About
2.3.2
Processing Options
2.3.3
Data Selection for Compute Cost Allocations
3
Work with Variable Numerator Allocations
3.1
Setting Up Variable Numerator Allocations
3.1.1
Example: The Variable Numerator Allocation
3.1.2
What You Should Know About
3.1.3
What You Should Know About
3.1.4
What You Should Know About
3.2
Reviewing Variable Numerator Allocations
3.2.1
Processing Options
3.3
Calculating Variable Numerator Allocations
3.3.1
Before You Begin
3.3.2
What You Should Know About
3.3.3
Processing Options
3.3.4
Data Selection for Compute Variable Numerator Allocations
4
Review and Post Allocations
4.1
Reviewing Allocations
4.2
Posting Allocations
4.2.1
What You Should Know About
Part II Integrity Reports
5
Overview to Integrity Reports
5.1
Objectives
5.2
About Integrity Reports
5.2.1
Why Should You Run Integrity Reports?
5.2.2
When Should You Run Integrity Reports?
5.2.3
What Do Integrity Reports Provide?
5.2.4
What Are the Types of Integrity Reports?
5.2.5
Which Integrity Report Should You Run?
6
Print Unposted Batches
6.1
Printing Unposted Batches
6.1.1
What You Should Know About
7
Locate Damaged Account Data
7.1
Locating Damaged Account Data
7.1.1
What You Should Know About
7.1.2
Processing Options
7.1.3
Correcting Discrepancies
8
Correct Transactions to Batch Records
8.1
Running the Report
8.1.1
What You Should Know About
8.1.2
Processing Options
8.2
Correcting Discrepancies
9
Correct Out-of-Balance Batches
9.1
Overview
9.2
Running the Report
9.2.1
What You Should Know About
9.2.2
Processing Options
9.3
Correcting Discrepancies
10
Correct Out-of-Balance Batches by Company
10.1
Running the Report
10.1.1
Before You Begin
10.1.2
What You Should Know About
10.1.3
Processing Options
10.2
Correcting Discrepancies
11
Correct Company Imbalances
11.1
Correcting Company Imbalances
11.2
Running the Report
11.2.1
What You Should Know About
11.3
Locating Out-of-Balance Conditions
11.4
Correcting Discrepancies
11.4.1
What You Should Know About
12
Correct Intercompany Account Imbalances
12.1
Correcting Intercompany Account Imbalances
12.1.1
Before You Begin
12.2
Running the Report
12.2.1
What You Should Know About
12.2.2
Processing Option
12.3
Locating Out-of-Balance Conditions
12.4
Correcting Discrepancies
13
Correct Chart of Accounts Discrepancies
13.1
Overview
13.1.1
Before You Begin
13.2
Running the Accounts without a Business Unit Report
13.2.1
What You Should Know About
13.2.2
Correcting Discrepancies
13.2.3
Processing Options
13.3
Running the Account Balance without Account Master Report
13.3.1
What You Should Know About
13.3.2
Processing Options
13.4
Running the Transactions without Account Master Report
13.4.1
Before You Begin
13.4.2
What You Should Know About
13.4.3
Issues Resolution
13.4.4
Processing Options
13.5
Correcting Discrepancies
14
Changing the Company Number on Business Units
14.1
Before You Begin
14.2
Changing the Business Unit Company Number
15
Correct Account Balances to Transactions
15.1
Overview
15.2
Running the Account Balance to Transaction Report
15.2.1
What You Should Know About
15.2.2
Example: Out-of-Balance Condition
15.2.3
What You Should Know About
15.2.4
Processing Options
15.3
Correcting Discrepancies
Part III Organization Report Structures
16
Overview to Organization Report Structures
16.1
Objectives
16.2
About Organization Report Structures
17
Work with Organization Report Structures
17.1
Creating Organization Report Structures
17.1.1
Before You Begin
17.1.2
What You Should Know About
17.1.3
Processing Options
17.2
Reviewing Organization Report Structures
17.2.1
Before You Begin
17.2.2
Processing Options
17.3
Printing Organization Report Structures
17.3.1
Before You Begin
17.3.2
Processing Options
Part IV Advanced Chart of Accounts
18
Overview to Advanced Chart of Accounts
18.1
Objectives
18.2
About the Advanced Chart of Accounts
18.2.1
What Should You Consider Before Creating a Flexible Format?
19
Understand Flexible Format
19.1
About Flexible Format Structure
19.1.1
What You Should Know About
19.2
About Flexible Format Account Segments
19.2.1
Defining Business Unit Segments
19.2.2
Defining Object Account Segments
19.2.3
Defining the Subsidiary Account Segments
20
Create a Flexible Format
20.1
Creating a Flexible Format
20.1.1
Before You Begin
20.2
Defining a Flexible Account Segment
20.3
Defining a Subledger Segment
20.4
Updating Business Units and Account Numbers
20.4.1
Running the Refresh Index - Business Unit Program
20.4.2
Running the Refresh Index - Account Program
20.4.3
Data Selection and Sequence for Refresh Index - Account
20.5
Entering New Account Numbers
21
Set Up Structured Subledgers
21.1
Setting Up Structured Subledgers
22
Changing the Chart of Accounts Using Flexible Format
22.1
Overview
22.1.1
Before You Begin
22.2
Changing the Flex Format
22.3
Updating the Account Master File
22.4
Updating the Account Ledger (F0911), Account Balance (F0902) and Item Balances (F1202) Files
22.5
Updating Additional Files
Part V Account Consolidations
23
Overview to Account Consolidations
23.1
Objectives
23.2
About Account Consolidations
23.2.1
What Are the Advantages and Disadvantages of Each Method?
23.2.2
What You Should Know About
24
Work with Low-Volume Consolidations
24.1
Working with Low-Volume Consolidations
24.2
Consolidating Business Units
24.2.1
Example: Consolidating Business Units by Category Code
24.2.2
Example: Organizational Structure Consolidation
24.2.3
What You Should Know About
24.2.4
What You Should Know About
24.3
Consolidating by Masked Business Unit
24.3.1
Example: Consolidating by Masked Business Unit
24.4
Reviewing Income Statements and Balance Sheets
24.4.1
What You Should Know About
24.4.2
What You Should Know About
24.5
Storing Online Consolidation Criteria
24.5.1
Processing Options
25
Work with High-Volume Consolidations
25.1
Working with High-Volume Consolidations
25.1.1
Example: High-Volume Consolidation
25.2
Creating High-Volume Consolidations
25.2.1
Before You Begin
25.2.2
What is the Structure of Pseudo Business Units?
25.2.3
What You Should Know About
25.2.4
Processing Options
25.2.5
Data Selection and Data Sequence for Refresh Consolidations
25.3
Reviewing High-Volume Consolidations
25.3.1
Before You Begin
25.3.2
Processing Options
25.4
Deleting Prior High-Volume Consolidations
25.4.1
What You Should Know About
25.4.2
Processing Options
Part VI Multi-Site Consolidations
26
Overview to Multi-Site Consolidations
26.1
Multi-Site Consolidations
27
Define Multi-Site Consolidations
27.1
Defining Multi-Site Consolidations
27.2
Defining Business Unit Structures
27.2.1
Generating Business Unit Structures
27.2.2
What You Should Know About
27.2.3
Processing Options
27.2.4
Reviewing Business Unit Structures
27.2.5
Revising Business Unit Structures
27.2.6
What You Should Know About
27.2.7
Printing Business Unit Structures
27.3
Defining Account Structures
27.3.1
Before You Begin
27.3.2
Generating Account Structures
28
Account Structure Build Report
28.1
Account Structure Build Report
28.1.1
Processing Options
29
Revise Account Structures
29.1
Revising Account Structures
29.1.1
Processing Options
29.2
Printing Account Structures
30
Define Multi-Site Consolidation Rules
30.1
Defining Multi-Site Consolidation Rules
31
Consolidate Multi-Site Information
31.1
Creating Consolidated Balances
31.1.1
What You Should Know About
31.1.2
Processing Options
31.1.3
Data Selection for Build Multi-Site Transfer File
31.1.4
Data Sequence for Build Multi-Site Transfer File
31.2
Verifying Consolidated Balances
32
Build Multi-Site Transfer File (P10550)
32.1
Building the Multi-Site Transfer File Report
33
Work with Consolidation File Control
33.1
Working with Consolidation File Control
33.1.1
Processing Options
34
Run Integrity Reports
34.1
Running the Prior Period Balance Checking Report
34.1.1
Processing Options
34.2
Running the Create UDC Control File Report
34.2.1
Processing Options
34.3
Running the UDC Value Control Report
34.3.1
Processing Options
34.4
Running the Create Object/Subsidiary Control File Report
34.4.1
Processing Options
34.5
Running the Object/Subsidiary Value Control Report
34.5.1
Processing Options
34.6
Running the Business Units/Accounts Previous Period Not Current Period Report
34.6.1
Processing Options
34.7
Running the Business Units/Accounts Current Period Not Previous Period Report
34.7.1
Processing Options
34.8
Running the Multi-Site Simple Balance Sheet
34.8.1
Processing Options
34.9
Running the Multi-Site Simple Income Statement
34.9.1
Processing Options
35
Send Consolidated Balances
35.1
Sending Consolidated Balances to the Target Company
35.1.1
To Send Consolidated Balances
35.1.2
Processing Options
35.1.3
Data Selection for Multi-Site Consolidation Tape Creation
35.1.4
Data Sequence for Multi-Site Consolidation Tape Creation
35.2
Updating the Status of the Multi-Site Transfer Tables
36
Generate and Process Batch Journal Entries
36.1
Generating and Processing Batch Journal Entries
36.2
Running Integrity Reports at the Target Company
36.3
Generating Multi-Site Batch Journal Entries
37
Journalize Consolidation Reports
37.1
Journalizing Consolidation Balances Report
37.1.1
Processing Options
37.1.2
Data Selection for Journalize Consolidation Balances
37.1.3
Data Sequence for Journalize Consolidation Balances
37.2
Accounts Created Financial Rollup Report
37.2.1
What You Should Know About
38
Work with Multi-Site Batch Journal Entries
38.1
Reviewing Multi-Site Batch Journal Entries
38.2
Revising Multi-Site Batch Journal Entries
38.3
Processing Multi-Site Batch Journal Entries
38.4
Purging Processed Multi-Site Journal Entries
38.5
Creating Multi-Site Journal Entries for Elimination
38.5.1
Processing Options
Part VII Account Structures Revisions
39
Overview to Account Structures Revisions
39.1
Objectives
39.2
About Account Structures Revisions
39.2.1
Can You Change Your Chart of Accounts?
39.2.2
Which Tables Are Affected?
39.2.3
Is There More Than One Posting Level?
40
Change Account Structures
40.1
Changing Account Structures
40.2
Setting Up Business Units
40.3
Updating Free-Form Account Numbers
40.4
Changing Business Unit, Object, or Subsidiary
40.4.1
Before You Begin
40.4.2
Changing an Account within a Business Unit
40.4.3
Changing an Account by Object
40.4.4
Changing a Single Account
40.4.5
Changing a Business Unit on Multiple Accounts
40.4.6
Changing Accounts by Object
40.4.7
Changing Accounts by Subsidiary
40.5
Updating Account Ledger and Account Balances Tables
40.6
Updating AAIs
40.7
Revising Business Unit Security
40.8
Revising Old Business Unit Information
40.9
Updating Reports and Allocations
41
Work with Account Information
41.1
Changing Account Information
41.1.1
Processing Options
41.1.2
Data Selection for Change Account Information
41.2
Changing Budget Pattern Codes
41.3
Updating Model/Consolidated Field
41.3.1
Processing Options
41.4
Updating Category Codes
41.4.1
Before You Begin
42
Increase the Length of Object Accounts
42.1
Increasing the Length of Object Accounts
43
Update Batch Header Amounts
43.1
Updating Batch Header Amounts
44
Repost the Account Ledger
44.1
Reposting the Account Ledger
44.1.1
Examples: Reposting Account Ledgers
44.1.2
What You Should Know About
44.1.3
Processing Options
44.1.4
Data Selection and Sequence for Repost Account Ledger
45
Change Date Patterns
45.1
Changing Date Patterns
45.2
Changing from a Calendar Year to a Fiscal Year Date Pattern
45.3
Changing from a Fiscal Year to a Calendar Year Date Pattern
46
Revise Entries Split Between Two Periods
46.1
Identifying Split Entries
46.2
Correcting Split Entries
Part VIII Data Removal
47
Overview to Data Removal
47.1
Objectives
47.2
About Data Removal
47.2.1
What is the Difference Between Delete and Purge?
47.2.2
What Information Can You Delete or Purge?
48
Summarize the Account Ledger (F0911) Prior to Purge
48.1
Summarizing the Account Ledger
48.2
Automatic Accounting Instruction (AAI)
48.3
Periods to Retain Processing Option
48.4
Record Structure after Summarization
48.5
Accounts Ledger Reports
49
Retain Periods When Summarizing Transactions
49.1
Retaining Periods When Summarizing Transactions
50
Create Balance Forward Records
50.1
Creating Balance Forward Records
50.1.1
Before You Begin
50.1.2
What You Should Know About
50.1.3
Processing Options
50.1.4
What You Should Know About
51
Purge Prior Year Journal Entries
51.1
Purging Prior Year Journal Entries
51.1.1
Processing Options
51.1.2
Data Selection for Purge Prior Year Journal Entries
52
Restore Purged Data to the Account Ledger (F0911)
52.1
Restoring Purged Data
53
Purge Prior Year Account Balances (P09912)
53.1
Purging Prior Year Account Balances
53.1.1
How It Works
53.1.2
Post Purge
54
Restore Purged Data to the Account Balance File (F0902)
54.1
Restoring Purged Data
55
Delete Account Master Records
55.1
Deleting Account Master Records
55.1.1
Processing Options
56
Delete Business Units and Companies
56.1
Deleting Business Units and Companies
56.1.1
Processing Options
57
Purge Bank Statement Information
57.1
Purging Bank Statement Information
57.2
Purging Bank Statement Header Information
57.2.1
Data Selection for Purge Statement Header
57.3
Purging Bank Statement Detail Information
57.3.1
Data Selection for Purge Statement Detail
Part IX Bank Statement Processing
58
Overview to Bank Statement Processing
58.1
Objectives
58.2
About Bank Statement Processing
58.2.1
Bank Statement Processing Using Electronic Data Interchange (EDI)
58.2.2
What You Should Know About
59
Understand Transaction Codes
59.1
About Transaction Codes
59.1.1
How Do You Use Transaction Codes?
59.1.2
What You Should Know About
60
Work with Bank Statements
60.1
Entering Bank Statements
60.1.1
What Should You Consider For Multi-Currency Bank Statements?
60.1.2
Entering Bank Statement Information
60.1.3
Entering Detail Information
60.1.4
Processing Options
60.2
Locating and Revising Bank Statements
60.2.1
What You Should Know About
60.3
Reviewing Bank Statements
60.3.1
What You Should Know About
60.3.2
What You Should Know About
60.3.3
Processing Options
61
Update the Reconciliation Table
61.1
Updating the Reconciliation Table
61.1.1
Before You Begin
61.1.2
Processing Options
62
Reconcile Bank Statements
62.1
Reconciling Bank Statements
62.1.1
Before You Begin
62.1.2
What You Should Know About
62.2
Reviewing the Proof Report
62.2.1
What You Should Know About
62.3
Reviewing the Bank Reconciliation Report
62.3.1
What You Should Know About
62.4
Reviewing the Cleared Not Issued Report
62.4.1
What You Should Know About
62.5
Reviewing the Cleared Before Issued Report
62.5.1
What You Should Know About
62.6
Reviewing the Amounts Not Equal Report
62.6.1
What You Should Know About
62.7
Reviewing the Unreconciled Items Report
62.7.1
What You Should Know About
62.7.2
Processing Options
62.7.3
Data Sequence for Reconcile Bank Statements
63
Post Bank Statement Transactions
63.1
Posting Automatic Receipts for Bank Statements
63.1.1
Before You Begin
63.2
Posting General Journal Batches for Bank Statements
63.2.1
Before You Begin
63.3
Posting Manual Payments for Bank Statements
63.4
Posting Manual Receipts for Bank Statements
63.4.1
Before You Begin
63.4.2
What You Should Know About
64
Reconcile Bank Statements Manually
64.1
Reconciling Bank Statements Manually
65
Print Bank Statement Reports
65.1
Overview
65.1.1
Before You Begin
65.1.2
What You Should Know About
Part X Batch Journal Entry Processing
66
Overview to Batch Journal Entry Processing
66.1
Objectives
66.2
About Batch Journal Entry Processing
66.2.1
What Do You Need to Do to Prepare Journal Entries?
66.2.2
Before You Begin
66.2.3
What You Should Know About
67
Review Batch Journal Entries
67.1
Overview
68
Revise Batch Journal Entries
68.1
Revising Batch Journal Entries
68.1.1
What You Should Know About
68.2
Adding Batch Journal Entries
68.2.1
What You Should Know About
68.3
Correcting Unprocessed Batch Journal Entries
68.3.1
Processing Options
69
Process Batch Journal Entries
69.1
Processing Batch Journal Entries
69.2
Submitting Batches
69.3
Verifying Batch Information
69.3.1
What You Should Know About
69.4
Correcting Proof Batch Journal Entries
69.4.1
What You Should Know About
69.4.2
Processing Options
70
Purge Processed Journal Entries (F0911Z1)
70.1
Purging Processed Journal Entries
70.1.1
What You Should Know About
70.1.2
Processing Options
Part XI Journal Entry and Batch Maintenance
71
Overview to Journal Entry and Batch Maintenance
71.1
Objectives
71.2
About Journal Entry and Batch Maintenance
71.2.1
Before You Begin
72
Revise a Journal Entry by Line Number
72.1
Overview
72.1.1
What You Should Know About
73
Revise a Journal Entry
73.1
Overview
73.1.1
What You Should Know About
74
Work with Batch Headers
74.1
Working with Batch Headers
74.1.1
What You Should Know About
74.2
Adding Batch Headers
74.3
Locating Batch Headers
74.4
Revising Batch Headers
74.5
Revising Batches to Post Out-of-Balance
74.5.1
Reasons to Post Out-of-Balance
74.5.2
Results of Posting Out-of-Balance
Part XII Business Unit Supplemental Data
75
Overview to Business Unit Supplemental Data
75.1
Objectives
75.2
About Business Unit Supplemental Data
75.2.1
Example: Supplemental Data for a Construction Company
75.2.2
Before You Begin
76
Set Up Business Unit Supplemental Data Types
76.1
Overview
76.1.1
Example: Setting Up Data Types
76.1.2
Before You Begin
77
Work with Business Unit Supplemental Data
77.1
Working with Business Unit Supplemental Data
77.1.1
Before You Begin
77.2
Entering Coded Entries
77.2.1
Example: Entering Coded Entries
77.3
Copying Coded Entries
77.3.1
What You Should Know About
77.4
Entering Narrative Text
77.4.1
Example: Entering Narrative Text
77.5
Copying Narrative Text
78
View Business Unit Supplemental Data
78.1
Viewing Data by Business Unit
78.2
Viewing Data by Data Type
79
Print Business Unit Supplemental Data
79.1
Printing Business Unit Supplemental Data
79.1.1
Before You Begin
79.2
Printing the Data by Data Type Report
79.2.1
What You Should Know About
79.2.2
Processing Options
79.2.3
Data Sequence for Data by Data Type
79.3
Printing the Data by Business Unit Report
79.3.1
Processing Options
79.3.2
Data Sequence for Data by Business Unit
80
Set Up Business Unit Supplemental Data Security
80.1
Overview
80.1.1
Before You Begin
Part XIII 52 Period Accounting
81
Overview to 52 Period Accounting
81.1
Objectives
81.2
About 52 Period Accounting
81.2.1
How Does 52 Period Accounting Differ from 12-to-14 Period Accounting?
81.2.2
Can You Change to 52 Period Accounting?
82
Set Up 52 Period Accounting
82.1
Setting Up Fiscal Date Patterns
82.1.1
What You Should Know About
82.2
Setting Up Financial Reporting Dates
83
Close a 52 Period Year
83.1
Overview
83.1.1
Before You Begin
83.1.2
Data Selection
84
Change to 52 Period Accounting
84.1
Overview
84.1.1
Before You Begin
84.1.2
Data Selection for Repost for 52 Period
Part XIV Processing Options
85
Allocations Processing Options
85.1
Cost Allocations (P0912)
85.2
Allocations Review (P09220)
85.3
Allocations Journal (P09302)
85.4
Allocations Review (P09220)
85.5
Allocate General Payroll to Marketing (P093022)
86
Integrity Report Processing Options
86.1
Trans w/o Batch Header - Unposted Only (P007021)
86.2
Batches Posted Out of Balance (P007031)
86.3
Batch and Company w/in Batch Out of Balance (P09706)
86.4
Intercompany Out of Balance (P097011)
86.5
Account Master without Business Unit Master (P097041)
86.6
Transaction without Account Master (P097021)
86.7
Compare Account Balances to Transactions (P09705)
87
Organization Report Structure Processing Options
87.1
Business Unit Organization Structure Rev (P0050)
87.2
Business Unit Org. Structure Review (P00250)
87.3
Structure - Organizational - Top Only (P00425)
88
Account Consolidation Processing Options
88.1
Consolidated Trial Balance (P09218)
88.2
Refresh Consolidations (P10862)
88.3
Account Balance Comparison (P092121)
88.4
Delete Prior Consolidations (P10861)
89
Multi-Site Consolidation Processing Options
89.1
Business Unit Structure Build (P10450)
89.2
Account Structure Build (P10430)
89.3
Build Multi-Site Transfer File (P10550)
89.4
Consolidation File Control (P10610)
89.5
Previous Balance Integrity (P10700)
89.6
Create UDC Control File (P10005)
89.7
UDC Value Control (P107011)
89.8
Obj/Sub Value Control (P107021)
89.9
Obj/Sub Value Control (P107021)
89.10
Business Units & Accounts This Period Not Last (P10701)
89.11
Business Units & Accounts This Period Not Last (P10701)
89.12
Multi-Site Simple Balance Sheet (P10150)
89.13
Multi-Site Simple Income Statement (P10250)
89.14
Consolidation File Control (P10610)
89.15
Journalize Consolidation Balances (P10480)
89.16
Stand Alone Eliminations (P10570)
90
Account Structures Revisions Processing Options
90.1
Change Account Information (P09813) (Release A9.3 Update)
90.2
Update Model/Consolidated Field (P0006QD)
90.3
Repost Account Ledger (P099105)
91
Data Removal Processing Options
91.1
Summarize Account Ledger - All Companies (P09811)
91.2
Purge - All Companies (P09911)
91.3
Delete All Account Master Records - Proof (P09814)
91.4
Delete Business Unit or Company (P09925)
92
Bank Statement Processing Options
92.1
Bank Statement Entry - Default Options (P09160)
92.2
Review Bank Statement - Default Options (P09181)
92.3
Refresh Reconciliation File (P09130)
92.4
Create Bank Statement Batches (P09170)
93
Batch Journal Entry Processing Options
93.1
Journal Entry Batch Maintenance (P0901Z1)
93.2
JE Batch File Processing - In Balance (P09110Z)
93.3
Batch File Purge (P00PURGE)
94
Business Unit Supplemental Data Processing Options
94.1
All Business Unit by Data Type - Alpha (P00640)
94.2
Business Unit Supplemental Data-By Alpha (P00650)
A
Quick Reference
A.1
Menus
A.2
Ledger Types
A.3
Document Types
B
Batch Input Setup
B.1
Table 1 - Required or Conditionally Required Fields
B.2
Table 2 - Optional Control Fields
B.3
Table 3 - Additional Fields
B.4
Table 4 - Ignored Fields
C
Functional Servers
C.1
About Functional Servers
C.1.1
To set up business rules for an entry program
Index
Scripting on this page enhances content navigation, but does not change the content in any way.