Go to main content
1/109
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Information
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 Elimination Entry Creation
26
Overview to Elimination Entry Creation
27
Define Business Unit Structures
27.1
Defining Business Unit Structures
27.1.1
Generating Business Unit Structures
27.1.2
What You Should Know About
27.1.3
Reviewing Business Unit Structures
27.1.4
Revising Business Unit Structures
27.1.5
What You Should Know About
27.1.6
Printing Business Unit Structures
28
Defining Account Structures
28.1
Generating Account Structures
28.1.1
Account Structure Build Report
28.1.2
Processing Options
28.2
Revising Account Structures
28.2.1
Processing Options
28.3
Printing Account Structures
29
Define Elimination Rules
30
Consolidate Elimination Information
30.1
Creating Elimination Balances
30.1.1
What You Should Know About
30.1.2
Processing Options
30.1.3
Data Selection
30.2
Verifying Elimination Balances
31
Create Eliminating Journal Entries
Part VII Account Structures Revisions
32
Overview to Account Structures Revisions
32.1
Objectives
32.2
About Account Structures Revisions
32.2.1
Can You Change Your Chart of Accounts?
32.2.2
Which Tables Are Affected?
32.2.3
Is There More Than One Posting Level?
33
Change Account Structures
33.1
Changing Account Structures
33.2
Setting Up Business Units
33.3
Updating Free-Form Account Numbers
33.4
Changing Business Unit, Object, or Subsidiary
33.4.1
Before You Begin
33.4.2
Changing an Account within a Business Unit
33.4.3
Changing an Account by Object
33.4.4
Changing a Single Account
33.4.5
Changing a Business Unit on Multiple Accounts
33.4.6
Changing Accounts by Object
33.4.7
Changing Accounts by Subsidiary
33.5
Updating Account Ledger and Account Balances Tables
33.6
Updating AAIs
33.7
Revising Business Unit Security
33.8
Revising Old Business Unit Information
33.9
Updating Reports and Allocations
34
Work with Account Information
34.1
Changing Account Information
34.1.1
Processing Options
34.1.2
Data Selection for Change Account Information
34.2
Changing Budget Pattern Codes
34.3
Updating Model/Consolidated Field
34.3.1
Processing Options
34.4
Updating Category Codes
34.4.1
Before You Begin
35
Increase the Length of Object Accounts
35.1
Increasing the Length of Object Accounts
36
Update Batch Header Amounts
36.1
Updating Batch Header Amounts
37
Repost the Account Ledger
37.1
Reposting the Account Ledger
37.1.1
Examples: Reposting Account Ledgers
37.1.2
What You Should Know About
37.1.3
Processing Options
37.1.4
Data Selection and Sequence for Repost Account Ledger
38
Change Date Patterns
38.1
Changing Date Patterns
38.2
Changing from a Calendar Year to a Fiscal Year Date Pattern
38.3
Changing from a Fiscal Year to a Calendar Year Date Pattern
39
Revise Entries Split Between Two Periods
39.1
Identifying Split Entries
39.2
Correcting Split Entries
Part VIII Data Removal
40
Overview to Data Removal
40.1
Objectives
40.2
About Data Removal
40.2.1
What is the Difference Between Delete and Purge?
40.2.2
What Information Can You Delete or Purge?
41
Summarize the Account Ledger (F0911) Prior to Purge
41.1
Summarizing the Account Ledger
41.2
Automatic Accounting Instruction (AAI)
41.3
Periods to Retain Processing Option
41.4
Record Structure after Summarization
41.5
Accounts Ledger Reports
42
Retain Periods When Summarizing Transactions
42.1
Retaining Periods When Summarizing Transactions
43
Create Balance Forward Records
43.1
Creating Balance Forward Records
43.1.1
Before You Begin
43.1.2
What You Should Know About
43.1.3
Processing Options
43.1.4
What You Should Know About
44
Purge Prior Year Journal Entries
44.1
Purging Prior Year Journal Entries
44.1.1
Processing Options
44.1.2
Data Selection for Purge Prior Year Journal Entries
45
Restore Purged Data to the Account Ledger (F0911)
45.1
Restoring Purged Data
46
Purge Prior Year Account Balances (P09912)
46.1
Purging Prior Year Account Balances
46.1.1
How It Works
46.1.2
Post Purge
47
Restore Purged Data to the Account Balance File (F0902)
47.1
Restoring Purged Data
48
Delete Account Master Records
48.1
Deleting Account Master Records
48.1.1
Processing Options
49
Delete Business Units and Companies
49.1
Deleting Business Units and Companies
49.1.1
Processing Options
50
Purge Bank Statement Information
50.1
Purging Bank Statement Information
50.2
Purging Bank Statement Header Information
50.2.1
Data Selection for Purge Statement Header
50.3
Purging Bank Statement Detail Information
50.3.1
Data Selection for Purge Statement Detail
Part IX Bank Statement Processing
51
Overview to Bank Statement Processing
51.1
Objectives
51.2
About Bank Statement Processing
51.2.1
Bank Statement Processing Using Electronic Data Interchange (EDI)
51.2.2
What You Should Know About
52
Understand Transaction Codes
52.1
About Transaction Codes
52.1.1
How Do You Use Transaction Codes?
52.1.2
What You Should Know About
53
Work with Bank Statements
53.1
Entering Bank Statements
53.1.1
What Should You Consider For Multi-Currency Bank Statements?
53.1.2
Entering Bank Statement Information
53.1.3
Entering Detail Information
53.1.4
Processing Options
53.2
Locating and Revising Bank Statements
53.2.1
What You Should Know About
53.3
Reviewing Bank Statements
53.3.1
What You Should Know About
53.3.2
What You Should Know About
53.3.3
Processing Options
54
Update the Reconciliation Table
54.1
Updating the Reconciliation Table
54.1.1
Before You Begin
54.1.2
Processing Options
55
Reconcile Bank Statements
55.1
Reconciling Bank Statements
55.1.1
Before You Begin
55.1.2
What You Should Know About
55.2
Reviewing the Proof Report
55.2.1
What You Should Know About
55.3
Reviewing the Bank Reconciliation Report
55.3.1
What You Should Know About
55.4
Reviewing the Cleared Not Issued Report
55.4.1
What You Should Know About
55.5
Reviewing the Cleared Before Issued Report
55.5.1
What You Should Know About
55.6
Reviewing the Amounts Not Equal Report
55.6.1
What You Should Know About
55.7
Reviewing the Unreconciled Items Report
55.7.1
What You Should Know About
55.7.2
Processing Options
55.7.3
Data Sequence for Reconcile Bank Statements
56
Post Bank Statement Transactions
56.1
Posting Automatic Receipts for Bank Statements
56.1.1
Before You Begin
56.2
Posting General Journal Batches for Bank Statements
56.2.1
Before You Begin
56.3
Posting Manual Payments for Bank Statements
56.4
Posting Manual Receipts for Bank Statements
56.4.1
Before You Begin
56.4.2
What You Should Know About
57
Reconcile Bank Statements Manually
57.1
Reconciling Bank Statements Manually
58
Print Bank Statement Reports
58.1
Overview
58.1.1
Before You Begin
58.1.2
What You Should Know About
Part X Batch Journal Entry Processing
59
Overview to Batch Journal Entry Processing
59.1
Objectives
59.2
About Batch Journal Entry Processing
59.2.1
What Do You Need to Do to Prepare Journal Entries?
59.2.2
Before You Begin
59.2.3
What You Should Know About
60
Review Batch Journal Entries
60.1
Overview
61
Revise Batch Journal Entries
61.1
Revising Batch Journal Entries
61.1.1
What You Should Know About
61.2
Adding Batch Journal Entries
61.2.1
What You Should Know About
61.3
Correcting Unprocessed Batch Journal Entries
61.3.1
Processing Options
62
Process Batch Journal Entries
62.1
Processing Batch Journal Entries
62.2
Submitting Batches
62.3
Verifying Batch Information
62.3.1
What You Should Know About
62.4
Correcting Proof Batch Journal Entries
62.4.1
What You Should Know About
62.4.2
Processing Options
63
Purge Processed Journal Entries (F0911Z1)
63.1
Purging Processed Journal Entries
63.1.1
What You Should Know About
63.1.2
Processing Options
Part XI Journal Entry and Batch Maintenance
64
Overview to Journal Entry and Batch Maintenance
64.1
Objectives
64.2
About Journal Entry and Batch Maintenance
64.2.1
Before You Begin
65
Revise a Journal Entry by Line Number
65.1
Overview
65.1.1
What You Should Know About
66
Revise a Journal Entry
66.1
Overview
66.1.1
What You Should Know About
67
Work with Batch Headers
67.1
Working with Batch Headers
67.1.1
What You Should Know About
67.2
Adding Batch Headers
67.3
Locating Batch Headers
67.4
Revising Batch Headers
67.5
Revising Batches to Post Out-of-Balance
67.5.1
Reasons to Post Out-of-Balance
67.5.2
Results of Posting Out-of-Balance
Part XII Business Unit Supplemental Data
68
Overview to Business Unit Supplemental Data
68.1
Objectives
68.2
About Business Unit Supplemental Data
68.2.1
Example: Supplemental Data for a Construction Company
68.2.2
Before You Begin
69
Set Up Business Unit Supplemental Data Types
69.1
Overview
69.1.1
Example: Setting Up Data Types
69.1.2
Before You Begin
70
Work with Business Unit Supplemental Data
70.1
Working with Business Unit Supplemental Data
70.1.1
Before You Begin
70.2
Entering Coded Entries
70.2.1
Example: Entering Coded Entries
70.3
Copying Coded Entries
70.3.1
What You Should Know About
70.4
Entering Narrative Text
70.4.1
Example: Entering Narrative Text
70.5
Copying Narrative Text
71
View Business Unit Supplemental Data
71.1
Viewing Data by Business Unit
71.2
Viewing Data by Data Type
72
Print Business Unit Supplemental Data
72.1
Printing Business Unit Supplemental Data
72.1.1
Before You Begin
72.2
Printing the Data by Data Type Report
72.2.1
What You Should Know About
72.2.2
Processing Options
72.2.3
Data Sequence for Data by Data Type
72.3
Printing the Data by Business Unit Report
72.3.1
Processing Options
72.3.2
Data Sequence for Data by Business Unit
73
Set Up Business Unit Supplemental Data Security
73.1
Overview
73.1.1
Before You Begin
Part XIII 52 Period Accounting
74
Overview to 52 Period Accounting
74.1
Objectives
74.2
About 52 Period Accounting
74.2.1
How Does 52 Period Accounting Differ from 12-to-14 Period Accounting?
74.2.2
Can You Change to 52 Period Accounting?
75
Set Up 52 Period Accounting
75.1
Setting Up Fiscal Date Patterns
75.1.1
What You Should Know About
75.2
Setting Up Financial Reporting Dates
76
Close a 52 Period Year
76.1
Overview
76.1.1
Before You Begin
76.1.2
Data Selection
77
Change to 52 Period Accounting
77.1
Overview
77.1.1
Before You Begin
77.1.2
Data Selection for Repost for 52 Period
Part XIV Processing Options
78
Allocations Processing Options
78.1
Cost Allocations (P0912)
78.2
Allocations Review (P09220)
78.3
Allocations Journal (P09302)
78.4
Allocations Review (P09220)
78.5
Allocate General Payroll to Marketing (P093022)
79
Integrity Report Processing Options
79.1
Trans w/o Batch Header - Unposted Only (P007021)
79.2
Batches Posted Out of Balance (P007031)
79.3
Batch and Company w/in Batch Out of Balance (P09706)
79.4
Intercompany Out of Balance (P097011)
79.5
Account Master without Business Unit Master (P097041)
79.6
Transaction without Account Master (P097021)
79.7
Compare Account Balances to Transactions (P09705)
80
Organization Report Structure Processing Options
80.1
Business Unit Organization Structure Rev (P0050)
80.2
Business Unit Org. Structure Review (P00250)
80.3
Structure - Organizational - Top Only (P00425)
81
Account Consolidation Processing Options
81.1
Consolidated Trial Balance (P09218)
81.2
Refresh Consolidations (P10862)
81.3
Account Balance Comparison (P092121)
81.4
Delete Prior Consolidations (P10861)
82
Multi-Site Consolidation Processing Options
82.1
Business Unit Structure Build (P10450)
82.2
Account Structure Build (P10430)
82.3
Build Stand Alone Elimination Transfer File (P10550)
82.4
Consolidation File Control (P10610)
82.5
Previous Balance Integrity (P10700)
82.6
Create UDC Control File (P10005)
82.7
UDC Value Control (P107011)
82.8
Obj/Sub Value Control (P107021)
82.9
Obj/Sub Value Control (P107021)
82.10
Business Units & Accounts This Period Not Last (P10701)
82.11
Business Units & Accounts This Period Not Last (P10701)
82.12
Multi-Site Simple Balance Sheet (P10150)
82.13
Multi-Site Simple Income Statement (P10250)
82.14
Consolidation File Control (P10610)
82.15
Journalize Consolidation Balances (P10480)
82.16
Stand Alone Eliminations (P10570)
83
Account Structures Revisions Processing Options
83.1
Change Account Information (P09813)
83.2
Update Model/Consolidated Field (P0006QD)
83.3
Repost Account Ledger (P099105)
84
Data Removal Processing Options
84.1
Summarize Account Ledger - All Companies (P09811)
84.2
Purge - All Companies (P09911)
84.3
Delete All Account Master Records - Proof (P09814)
84.4
Delete Business Unit or Company (P09925)
85
Bank Statement Processing Options
85.1
Bank Statement Entry - Default Options (P09160)
85.2
Review Bank Statement - Default Options (P09181)
85.3
Refresh Reconciliation File (P09130)
85.4
Create Bank Statement Batches (P09170)
86
Batch Journal Entry Processing Options
86.1
Journal Entry Batch Maintenance (P0901Z1)
86.2
JE Batch File Processing - In Balance (P09110Z)
86.3
Batch File Purge (P00PURGE)
87
Business Unit Supplemental Data Processing Options
87.1
All Business Unit by Data Type - Alpha (P00640)
87.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.