Go to main content
1/57
Contents
List of Figures
Title and Copyright Information
Preface
Audience
JD Edwards EnterpriseOne Products
JD Edwards EnterpriseOne Application Fundamentals
Documentation Accessibility
Related Documents
Conventions
1
Introduction to JD Edwards EnterpriseOne General Accounting
1.1
JD Edwards EnterpriseOne General Accounting Overview
1.2
JD Edwards EnterpriseOne General Accounting Business Processes
1.3
JD Edwards EnterpriseOne General Accounting Integrations
1.3.1
JD Edwards EnterpriseOne Workforce Management
1.3.2
JD Edwards EnterpriseOne Financial Management
1.3.3
JD Edwards EnterpriseOne Localization
1.3.4
JD Edwards EnterpriseOne Capital Asset Management
1.3.5
JD Edwards EnterpriseOne Logistics Management
1.3.6
JD Edwards EnterpriseOne Multi-mode Manufacturing
1.3.7
JD Edwards EnterpriseOne Homebuilder Management
1.3.8
JD Edwards EnterpriseOne Real Estate Management
1.3.9
JD Edwards EnterpriseOne Service Management
1.4
JD Edwards EnterpriseOne General Accounting Implementation
1.4.1
Global Implementation Steps
1.4.2
JD Edwards EnterpriseOne General Accounting Implementation Steps
1.5
Business Interface Integration Objects
2
Understanding the General Accounting System
2.1
General Accounting Features
3
Setting Up the General Accounting System
3.1
Understanding General Accounting System Setup
3.2
Prerequisite
3.3
Setting Up Constants for General Accounting
3.3.1
Understanding General Accounting Constants
3.3.2
Prerequisite
3.3.3
Forms Used to Set Up General Accounting Constants
3.3.4
Setting Up General Accounting Constants
3.4
Setting Up User-Defined Codes for General Accounting
3.4.1
Business Unit Category Codes (00/01–50)
3.4.2
Account Category Codes (09/01–43)
3.4.3
Business Unit Type Codes (00/MC)
3.4.4
Subledger Type Codes (00/ST)
3.4.5
Reconciliation Codes (09/RC)
3.4.6
Transaction Codes (09/BJ)
3.4.7
Acceptable Adjustment Document Types (09/AA)
3.4.8
Burden Category (48S/BC)
3.4.9
Burden Rate Type (48S/RT)
3.4.10
Segment ID (48S/SI)
3.5
Setting Up Ledger Types for General Accounting
3.5.1
Example: Ledger Types
3.6
Setting Up Ledger Type Rules for General Accounting
3.6.1
Understanding Ledger Type Rules
3.6.2
Forms Used to Set Up Ledger Type Rules
3.6.3
Setting Up a Ledger Type Rule
3.7
Setting Up AAIs for General Accounting
3.7.1
Understanding General Purpose Accounts
3.7.2
Understanding Retained Earnings Accounts
3.7.3
Understanding Financial Statement Totals
3.7.3.1
AAI Item FS99
3.7.4
Understanding Speed Codes
3.7.5
Understanding Account Summarization
3.7.6
Understanding Reconcilable Ranges
3.7.7
Understanding Prior Year Account Purges
3.8
Setting Up Business Unit Supplemental Data
3.8.1
Prerequisite
3.9
Setting Up Vertex Sales Tax
4
Setting Up Burdening
4.1
Understanding Burdening Setup
4.2
Setting Up Segment Information
4.2.1
Understanding Segments and Burdening Categories
4.2.2
Understanding Burden Computation Methods
4.2.3
Understanding Burden Base Rules
4.2.4
Prerequisites
4.2.5
Forms Used to Set Up Segment Information
4.2.6
Setting Up Segment Definitions
4.2.7
Setting Up Burden Computation Methods
4.2.8
Setting Up Burden Base Rules
4.3
Setting Up Pool Information
4.3.1
Understanding Pool Definitions
4.3.2
Understanding Pool Grouping Codes
4.3.3
Prerequisites
4.3.4
Forms Used to Set Up Pool Information
4.3.5
Adding Pool Definitions
4.3.6
Adding Pool Grouping Codes
4.4
Setting Up Burdening Rates
4.4.1
Understanding Burdening Rates
4.4.2
Forms Used to Set Up Burdening Rates
4.4.3
Adding Burdening Rates
5
Setting Up Advanced Variable Numerator Allocations
5.1
Understanding Setup for Advanced Variable Numerator Allocations
5.1.1
Understanding Burdening-Based Allocations
5.2
Setting Up Business Unit Overrides
5.2.1
Understanding Business Unit Overrides
5.2.2
Forms Used to Set Up Business Unit Overrides
5.2.3
Example: Business Unit Overrides for Account Balance-Based Allocations
5.2.4
Example: Business Unit Overrides for Burdening-Based Allocations
5.2.5
Setting Up Business Unit Overrides
5.3
Setting Up Versions for Account Balance-Based Allocations
5.3.1
Understanding Version Setup for Account Balance-Based Allocations
5.4
Setting Up Versions for Burdening-Based Allocations
5.4.1
Understanding Version Setup for Burdening-Based Allocations
5.5
Setting Up Specifications for Advanced Variable Numerator Allocations
5.5.1
Understanding the Specifications for Advanced Variable Numerator Allocations
5.5.2
Forms Used to Set Up Specifications for Advanced Variable Numerator Allocations
5.5.3
Understanding the Work With Advanced Variable Numerator Form
5.5.3.1
Row Menu
5.5.3.2
Report Menu
5.5.4
Setting Processing Options for Advanced Variable Numerator (P09123)
5.5.4.1
Select
5.5.5
Setting Up the Specifications for an Account Balance-Based Allocation
5.5.5.1
Identification
5.5.5.2
Source / Basis
5.5.5.3
Destination
5.5.6
Setting Up the Specifications for a Burdening-Based Allocation
5.5.6.1
Source / Basis Tab
5.5.6.2
Fields for Burdening-Based Allocations
5.5.6.3
Destination Tab
5.5.6.4
Fields for Burdening-Based Allocations
6
Setting Up Account Reconciliation
6.1
Understanding Account Reconciliation
6.2
Setting Up AAIs for Account Reconciliation
6.3
Setting Up Reconciliation Codes
7
Setting Up Automatic Bank Statement Processing
7.1
Setting Up UDCs for Automatic Bank Statement Processing
7.1.1
Understanding UDC Setup for Automatic Bank Statement Processing
7.1.2
Setting Up UDCs for Automatic Bank Statements
7.1.2.1
09/TT - Auto Bank Statement Transaction Types
7.1.2.2
09/DT - Default Date
7.1.2.3
09/FT - E Bank Statement Format
7.1.2.4
09/TD - Transaction Debit/Credit Indicator
7.1.2.5
09/RR - Reconciled Reason Code
7.1.2.6
09/RU - Reconciled Code
7.1.2.7
09/UR - Unreconciled Reason Code
7.1.2.8
09/BA - BAI2 Transaction Types
7.1.2.9
09/ST - SWIFT Transaction Types
7.1.2.10
09/BU - Offset Business Unit
7.2
Setting Up Cross References
7.2.1
Understanding Cross References
7.2.2
Forms Used to Set Up Cross References
7.2.3
Setting Up Cross References for a Bank Account
7.2.4
Setting Up a Cross Reference for a Transaction Type
7.3
Setting Up Automatic Bank Account Reconciliation
7.3.1
Understanding Automatic Bank Account Reconciliation
7.3.1.1
Reconciliation Rules
7.3.1.2
Reconciliation Groups
7.3.1.3
Automatic Bank Statements
7.3.2
Forms Used to Set Up Automatic Bank Account Reconciliation
7.3.3
Setting Up Automatic Reconciliation Rules
7.3.3.1
Payment Clear
7.3.3.2
Receipt Clear
7.3.3.3
Journal Entry Create
7.3.3.4
Journal Entry Reconcile
7.3.3.5
Draft Paid
7.3.4
Assigning Automatic Reconciliation Rules to Groups
7.3.5
Assigning Groups to Automatic Bank Statement Accounts
8
Setting Up Budget Forecasting and Planning
8.1
Understanding Budget Forecasting and Planning Setup
8.2
Setting Up Growth Patterns
8.2.1
Understanding Growth Patterns
8.2.2
Forms Used to Set Up Growth Patterns
8.2.3
Setting Up a Growth Pattern
8.2.4
Assigning a Growth Pattern to Business Units
8.2.4.1
Revise Business Unit
8.2.4.2
Growth Patterns
8.2.4.3
Budget Codes
9
Setting Up Cash Forecasting
9.1
Understanding Cash Forecasting Setup
9.2
Understanding Cash Type Codes
9.3
Setting Up Cash Type Rules
9.3.1
Understanding Cash Type Rules
9.3.2
Forms Used to Set Up Cash Type Forecasting
9.3.3
Setting Up Cash Type Rules for Accounts Receivable and Accounts Payable
9.3.3.1
Header Area Fields
9.3.3.2
A/R or A/P Tab
9.3.4
Setting Up Cash Type Rules for General Ledger
9.3.4.1
Header Fields
9.3.4.2
G/L Tab
9.4
Defining a Cash Forecast Report Structure
9.4.1
Understanding Cash Forecast Report Structures
9.4.2
Prerequisites
9.4.3
Forms Used to Define Cash Forecast Reports
9.4.4
Setting Processing Options for the Cash Forecast Report Structures Setup Program (P09523)
9.4.4.1
Default Tab
9.4.5
Defining a Cash Forecast Report Structure
10
Setting Up Statements of Cash Flow
10.1
Understanding Cash Management
10.2
Understanding Cash Flow Statements
10.3
Setting Up Cash Flow Activity Codes
10.4
Setting Up Normal Balance Codes
10.5
Setting Up Cash Flow Rules
10.5.1
Understanding Cash Flow Rules
10.5.2
Forms Used to Set Up Cash Flow Rules
10.5.3
Setting Up Cash Flow Rules
10.5.3.1
Activity Code 10
10.5.3.2
Activity Codes 20–70
10.5.4
Assigning Accounts to Cash Flow Activity Codes
11
Setting Up Cash Basis Accounting
11.1
Understanding Cash Basis Accounting Setup
11.2
Setting Up Cash Basis Document Types
11.2.1
Forms Used to Set Up Cash Basis Document Types
11.2.2
Setting Up Document Types for Cash Basis Entries
11.2.3
Setting Up Document Types to Exclude for Cash Basis Entries
11.2.4
Assigning Cash Basis Document Types to the AA Ledger
11.3
Setting Up AAIs for Cash Basis Accounting
11.3.1
Setting Up AAIs for Unapplied Receipts
11.3.2
Setting Up AAIs for Balancing Accounts
12
Setting Up 52 Period Accounting
12.1
Setting Up 52 Period Fiscal Date Patterns
12.1.1
Understanding 52 Period Fiscal Date Patterns
12.1.2
Forms Used to Set Up 52 Period Fiscal Date Patterns
12.1.3
Defining 52 Period Fiscal Date Patterns
12.2
Setting Up 52 Period Reporting Dates
12.2.1
Understanding 52 Period Reporting Dates
12.2.2
Forms Used to Set Up 52 Period Reporting Dates
12.2.3
Assigning 52 Period Reporting Dates to a Company
12.2.3.1
52 Period Accounting
12.3
Changing to 52 Period Accounting
12.3.1
Understanding the Repost for 52 Period Program (R0902B)
12.3.2
Prerequisite
12.3.3
Running the Repost for 52 Period Program
12.3.4
Setting Data Selection for the Repost for 52 Period Program
13
Processing Journal Entries
13.1
Understanding the Journal Entry Process
13.2
Understanding Other Methods of Entering Journal Entries
13.3
Working with Journal Entries
13.3.1
Understanding the Journal Entry Program
13.3.2
Understanding Types of Journal Entries
13.3.3
Understanding Journal Entry Features
13.3.3.1
Duplicating Account Number Segments
13.3.3.2
Using Speed Account Entry for Journal Entries for Work Orders
13.3.4
Understanding Temporary Invalid Account Numbers
13.3.5
Forms Used to Work with Journal Entries
13.3.6
Setting Processing Options for Journal Entry (P0911)
13.3.6.1
Defaults
13.3.6.2
Display
13.3.6.3
Versions
13.3.6.4
Edits
13.3.7
Setting Processing Options for Journal Entry Master Business Function (P0900049)
13.3.7.1
Defaults
13.3.7.2
Currency
13.3.7.3
Zero Amounts
13.3.7.4
Interop
13.3.8
Entering a Basic Journal Entry
13.3.8.1
Header Area
13.3.8.2
Detail Area
13.3.8.3
Additional Fields
13.3.8.4
Error Message: Amount Does Not Balance to Gross
13.3.9
Adding an Attachment to a Journal Entry
13.3.10
Entering a Journal Entry with an Invalid Account Number
13.3.11
Entering a Percent Journal Entry
13.3.12
Copying a Journal Entry
13.3.13
Revising an Unposted Journal Entry
13.3.14
Deleting an Unposted Journal Entry
13.4
Working with Reversing Journal Entries
13.4.1
Understanding Reversal Entries
13.4.2
Entering a Reversing Entry
13.4.3
Reviewing a Reversing Journal Entry
13.4.4
Changing a Posted Journal Entry to a Reversing Entry
13.5
Working with Model Journal Entries
13.5.1
Understanding Model Journal Entries
13.5.2
Creating a Model Journal Entry
13.5.3
Creating a Model Journal Entry from an Existing Journal Entry
13.5.4
Entering a Journal Entry Based on a Model by Copying the Model
13.5.5
Entering a Journal Entry Based on a Model by Selecting the Model
13.6
Reviewing Journal Entries
13.6.1
Forms Used to Review Journal Entries
13.6.2
Setting Processing Options for General Journal Review (P0011)
13.6.3
Reviewing a Journal Entry
13.7
Posting Journal Entries
13.7.1
Understanding the General Ledger Post Process
13.7.2
Setting Processing Options for General Ledger Post (R09801)
13.7.2.1
Print
13.7.2.2
Versions
13.7.2.3
Edits
13.7.2.4
Taxes
13.7.2.5
Process
13.7.2.6
Cash Basis
13.7.3
Posting Journal Entries
13.8
Revising and Voiding Journal Entries
13.8.1
Understanding Revisions and Voids to Journal Entries
13.8.1.1
Populate F0911 Void Column report (R890911V)
13.8.2
Forms Used to Revise and Void Journal Entries
13.8.3
Revising a Posted Journal Entry
13.8.4
Voiding a Posted Journal Entry
13.8.5
Voiding a Reversal Journal Entry
14
Processing Batch Journal Entries
14.1
Understanding Journal Entry Batch Processing
14.2
Uploading Batch Journal Entry
14.2.1
Understanding the Journal Entry Batch Upload Process
14.2.1.1
Errors in Processing
14.2.2
Running the Journal Entries Batch Processor
14.2.3
Setting Processing Options for Journal Entries Batch Processor (R09110Z)
14.2.3.1
Version
14.2.3.2
Process
14.2.3.3
Messages
14.2.3.4
Edits
14.3
Working with Batch Journal Entries
14.3.1
Understanding the Journal Entry Revisions Program
14.3.2
Forms Used to Work with Batch Journal Entries
14.3.3
Setting Processing Options for Journal Entry Revisions (P0911Z1)
14.3.3.1
Entry Type
14.3.4
Adding Batch Journal Entries
14.4
Posting Processed Batch Journal Entries
14.5
Purging Processed Batch Journal Entries
15
Processing Allocations
15.1
Understanding Allocations
15.2
Understanding the Process for Creating Allocations
15.3
Understanding Multitiered Allocations
15.4
Common Elements Used in This Chapter
15.5
Processing Recurring Journal Entries
15.5.1
Understanding Recurring Journal Entries
15.5.2
Understanding the Recurring JE Compute & Print Program
15.5.3
Prerequisite
15.5.4
Forms Used to Process Recurring Journal Entries
15.5.5
Creating Recurring Journal Entries
15.5.6
Running the Recurring JE Compute & Print Program
15.5.7
Setting Data Selection for Recurring JE Compute & Print
15.5.8
Setting Processing Options for Recurring JE Compute & Print (R09302)
15.5.8.1
Thru Date
15.5.8.2
Mode
15.6
Processing Indexed Allocations
15.6.1
Understanding Indexed Allocations
15.6.1.1
Example: Indexed Allocations
15.6.2
Understanding the Indexed Computations Compute & Print Program
15.6.3
Prerequisites
15.6.4
Forms Used to Create Indexed Allocations
15.6.5
Creating Indexed Allocations
15.6.6
Running the Indexed Computations Compute & Print Program
15.6.7
Setting Data Selection and Sequence for Indexed Computations Compute & Print
15.6.8
Setting Processing Options for Indexed Computations Compute & Print (R093021)
15.6.8.1
Mode
15.6.8.2
Audit Trail
15.6.8.3
Include Alloc
15.6.8.4
Multi-tier
15.6.8.5
Explanations
15.6.8.6
Errors
15.6.8.7
Log Warnings
15.7
Processing Advanced Variable Numerator Allocations
15.7.1
Understanding Advanced Variable Numerator Allocations
15.7.1.1
Example: Variable Numerator Allocations
15.7.2
Understanding Account Balance-Based Allocations
15.7.2.1
Running the R09123 Program for Account Balance-Based Allocations
15.7.3
Understanding Burdening-Based Allocations
15.7.3.1
Running the R09123 Program for Burden-Based Allocations
15.7.4
Prerequisites
15.7.5
Calculating Advanced Variable Numerator Allocations
15.7.6
Setting Data Selection for Compute Advanced Variable Numerator Allocations
15.7.7
Setting Processing Options for Compute Advanced Variable Numerator Allocations (R09123)
15.7.7.1
Process
15.7.7.2
Select
15.7.7.3
Display
16
Processing Burdening
16.1
Understanding the Burdening Process
16.1.1
Prerequisites
16.2
Creating Burdening Transactions
16.2.1
Understanding the Create Burdening Transactions Program
16.2.1.1
Running the Create Burdening Transactions Program During the General Ledger Post
16.2.2
Setting Processing Options for Create Burdening Transactions (R52G11)
16.2.2.1
Process
16.2.3
Running the Create Burdening Transactions Program
17
Processing Reburdening
17.1
Understanding the Reburdening Process
17.2
Processing Reburdening
17.2.1
Understanding the Process Re-burdening Transactions Program
17.2.2
Understanding the Create Re-burdening Transactions Program
17.2.3
Form Used to Set Up the Create Re-burdening Transactions Program
17.2.4
Setting Up the Create Re-burdening Transactions Program
17.2.4.1
Detail Options
17.2.5
Running the Create Re-burdening Transactions Program
17.3
Reviewing, Approving, and Deleting Reburdening Transaction Groups
17.3.1
Understanding Reviewing, Approving, and Deleting Reburdening Transaction Groups
17.3.2
Forms Used to Review, Approve, and Delete Reburdening Transaction Groups
17.3.3
Reviewing Detail for a Reburdening Transaction Group
17.3.4
Approving a Reburdening Transaction Group
17.3.5
Deleting a Reburdening Transaction Group
17.4
Updating the Billing Detail Workfile Table with Reburdening Transactions
17.4.1
Understanding the Re-burdening Workfile Generation Program
17.4.2
Running the Re-burdening Workfile Generation Program
18
Processing Actual Rate Calculation
18.1
Understanding Actual Rate Calculation
18.2
Prerequisite
18.3
Calculating Actual Rates
18.3.1
Form Used to Calculate Actual Rates
18.3.2
Setting Processing Options for Process Actual Rate Calculations (P52G60)
18.3.2.1
Defaults
18.3.3
Setting Up the Actual Rate Calculations Program
18.3.4
Running the Actual Rate Calculations Program
18.4
Reviewing Actual Rate Calculation Reference IDs
18.4.1
Understanding the Review Actual Rate Calculation Reference ID's Program
18.4.2
Forms Used to Review Actual Rate Calculation Reference IDs
18.4.3
Reviewing a Reference ID
18.4.4
Deleting a Reference ID
18.4.5
Reviewing Details for a Reference ID
19
Reconciling Bank Account Transactions
19.1
Understanding Bank Account Reconciliation
19.2
Reconciling Voided Payments and Receipts
19.2.1
Understanding the Auto Reconciliation Void Programs
19.2.2
Reconciling Voided Payments
19.2.3
Reconciling Voided Receipts
19.3
Refreshing Account Reconciliation Information
19.3.1
Understanding the Refresh Reconciliation File Program
19.3.2
Prerequisite
19.3.3
Running the Refresh Reconciliation File Program
19.3.4
Setting Data Selection for Refresh Reconciliation File
19.3.5
Setting Processing Options for Refresh Reconciliation File (R09130)
19.3.5.1
Select
19.3.5.2
Default
19.3.5.3
Display
19.3.5.4
Print
19.4
Reconciling Bank Account Transactions Manually
19.4.1
Understanding Manual Bank Account Reconciliation
19.4.2
Understanding the Reconciliation Report
19.4.3
Forms Used to Reconcile Bank Account Transactions Manually
19.4.4
Setting Processing Options for Manual Reconciliation (P09131)
19.4.4.1
Defaults
19.4.4.2
Process
19.4.5
Reconciling Bank Account Transactions Manually
19.5
Changing a Reconciled Transaction to Unreconciled
20
Reconciling Debit and Credit Amounts
20.1
Understanding the Debit and Credit Reconciliation Process
20.2
Prerequisites
20.3
Reconciling Debit and Credit Transactions (Release 9.1 Update)
20.3.1
Forms Used to Reconcile Debit and Credit Transactions
20.3.2
Setting Processing Options for Manual Reconciliation (P09131)
20.3.2.1
Process
20.3.3
Reconciling Debit and Credit Transactions Manually
21
Reconciling Bank Tapes
21.1
Understanding the Bank Tape Reconciliation Process
21.2
Reformatting the Bank Tape
21.2.1
Understanding the Program Used to Reformat Bank Tapes
21.2.2
Running the Custom Reformat UBE Program
21.2.3
Setting Processing Options for Custom Reformat UBE (R09501)
21.2.3.1
Purge
21.3
Refreshing Account Reconciliation Information
21.4
Matching the Bank Tape to the Reconciliation Workfile
21.4.1
Understanding the Program Used to Reconcile Transactions
21.4.2
Running the Match Tape File To Recon File Program
21.4.3
Setting Processing Options for Match Tape File To Recon File (R09510)
21.4.3.1
Select
21.5
Verifying the Bank Tape Reconciliation
22
Reconciling Clearing Accounts
22.1
Understanding the Clearing Account Reconciliation Process (Release 9.1 Update)
22.2
Prerequisites
22.3
Automatically Reconciling Clearing Accounts (Release 9.1 Update)
22.3.1
Understanding the G/L Account Reconciliation Program (R09150)
22.3.1.1
Accounts Payable Trade Accounts
22.3.1.2
Accounts Receivable Trade Accounts
22.3.1.3
Voucher Logging Accounts
22.3.1.4
RNV Accounts
22.3.1.5
Performance Liability Accounts (Release 9.1 Update)
22.3.2
Prerequisite
22.3.3
Setting Processing Options for the G/L Account Reconciliation Program (R09150) (Release 9.1 Update)
22.3.3.1
Process
22.3.3.2
Options
22.3.4
Running the G/L Account Reconciliation Program
23
Processing Bank Statements Manually
23.1
Understanding Manual Bank Statement Processing
23.1.1
Common Elements Used in This Chapter
23.2
Understanding Transaction Codes
23.2.1
Transactions That Cleared Your Bank Account and Have Been Entered in the System
23.2.2
Transactions That Cleared Your Bank Account and Have Not Been Entered in the System
23.3
Understanding Transit Accounts
23.4
Entering Bank Statement Transactions
23.4.1
Understanding Bank Statement Transactions
23.4.2
Forms Used to Enter Bank Statement Transactions
23.4.3
Setting Processing Options for Bank Statement Entry (P09160)
23.4.3.1
Criteria
23.4.3.2
Defaults
23.4.3.3
Journal Entry
23.4.3.4
Dates Tab
23.4.3.5
Document Type
23.4.3.6
Display 1
23.4.3.7
Display 2
23.4.3.8
Versions
23.4.3.9
Entry Mode
23.4.3.10
Prev Balance
23.4.3.11
Transaction Codes
23.4.4
Entering Bank Statement Transactions
23.4.4.1
Header Area Fields
23.4.4.2
Detail Area Fields
23.5
Refreshing Account Reconciliation Information
23.5.1
Understanding the Refresh Reconciliation File Program
23.5.2
Prerequisite
23.5.3
Running the Refresh Reconciliation File Program
23.5.4
Setting Data Selection for Refresh Reconciliation File
23.5.5
Setting Processing Options for Refresh Reconciliation File (R09130)
23.5.5.1
Select
23.5.5.2
Default
23.5.5.3
Display
23.5.5.4
Print
23.6
Running the Bank Journal Statement Process Program
23.6.1
Understanding the Bank Journal Statement Process Program
23.6.2
Prerequisite
23.6.3
Running the Bank Journal Statement Process Program
23.6.4
Setting Data Sequence for Bank Journal Statement Process
23.6.5
Setting Processing Options for Bank Journal Statement Process (R09170)
23.6.5.1
Proof/Final
23.6.5.2
Document Type
23.6.5.3
Variance
23.6.5.4
Realized Gain/Loss
23.6.5.5
Date
23.6.5.6
Reconciliation
23.6.5.7
Statement
23.6.6
Reviewing the Bank Statement Processing Reports
23.6.7
Processing Batch Cash Receipt Transactions
24
Processing Bank Statements Automatically
24.1
Understanding the Automatic Bank Statement Process
24.2
Processing Flat Files from the Bank
24.2.1
Understanding the Process Automatic Bank Statements Flat File Program
24.2.2
Setting Processing Options for the Process Automatic Bank Statements Flat File Program (R09600)
24.2.2.1
Processing
24.2.3
Running the Process Automatic Bank Statements Flat File Program (R09600)
24.3
Revising Data in the Staging Tables
24.3.1
Understanding Data Revisions to the Staging Tables
24.3.2
Forms Used to Revise Data in Staging Tables
24.3.3
Setting Processing Options for Revise Electronic Bank Statement Staging (P09610)
24.3.3.1
Update
24.3.4
Revising Staging Data
24.3.4.1
Header Fields
24.3.4.2
Detail Fields
24.4
Loading Data into the Bank Statement Tables
24.4.1
Understanding the Load Bank Statement Program
24.4.2
Running the Load Bank Statement Program
24.4.3
Setting Processing Options for Load Bank Statement (R09612)
24.4.3.1
Process
24.5
Revising Data in the Bank Statement Tables
24.5.1
Understanding Data Revisions to the Bank Statement Tables
24.5.2
Forms Used to Revise Data in the Bank Statement Tables
24.5.3
Setting Processing Options for Revise Automatic Bank Statement (P09616)
24.5.3.1
Revise Fields
24.5.4
Revising Bank Statement Data
24.5.4.1
Header Fields
24.5.4.2
Detail Fields
24.5.5
Revising Transactions without a Customer Number
24.6
Processing Automatic Bank Statements
24.6.1
Understanding the Automatic Bank Statement Program
24.6.1.1
Journal Entry Reconciliation Only
24.6.2
Understanding Automatic Bank Statement Reports and Messages
24.6.3
Running the Process Automatic Bank Statements Program
24.6.4
Setting Processing Options for Process Automatic Bank Statements (R09616)
24.6.4.1
Select
24.6.4.2
Print
24.7
Reconciling Unreconciled Bank Statement Transactions
24.7.1
Understanding the Manual Bank Statement Reconciliation Program
24.7.2
Form Used to Manually Reconcile Bank Statement Transactions
24.7.3
Setting Processing Options for Manual Bank Statement Reconciliation (P09631)
24.7.3.1
Defaults
24.7.4
Reconciling Unreconciled Bank Transactions
24.7.4.1
Bank Statement Detail
24.7.4.2
Account Ledger
24.7.4.3
Cleared Date
24.8
Purging Bank Statement Tables
24.8.1
Understanding the Bank Statement Purge Programs
24.8.1.1
Purge Staging Tables
24.8.1.2
Purge Automatic Bank Statement Tables
24.8.2
Purging Staging Tables
24.8.3
Setting Processing Options for Purge Staging Tables (R09610)
24.8.3.1
Select
24.8.3.2
Print
24.8.4
Purging Automatic Bank Statement Tables Program
24.8.5
Setting Processing Options for Purge Automatic Bank Statement Tables (R09615)
24.8.5.1
Select
24.8.5.2
Report Output
25
Creating Budgets
25.1
Understanding Budgets
25.1.1
Budget Methods
25.2
Understanding Budget Patterns
25.2.1
Example: Default Pattern
25.2.2
Example: Seasonal Pattern
25.2.3
Example: Do Not Spread Pattern
25.3
Creating Budget Pattern Codes
25.3.1
Forms Used to Create Budget Pattern Codes
25.3.2
Creating a Budget Pattern Code
25.4
Changing Budget Pattern Codes for a Group of Accounts
25.4.1
Understanding Budget Pattern Code Changes
25.4.2
Form Used to Change Budget Pattern Codes for a Group of Accounts
25.4.3
Changing a Budget Pattern Code for a Group of Accounts
25.5
Entering Annual Budgets
25.5.1
Understanding Annual Budgets
25.5.2
Understanding Budget Cycles
25.5.2.1
Example: Using Annual Budget Cycles
25.5.3
Prerequisite
25.5.4
Forms Used to Enter Annual Budget Amounts
25.5.5
Setting Processing Options for Requested by Business Unit (P14102) and Requested by Account (P14103)
25.5.5.1
Budget by Business Unit
25.5.5.2
Spread Budget
25.5.6
Entering Annual Budget Amounts by Business Unit
25.5.7
Entering Annual Budget Amounts by Account
25.6
Spreading Annual Budget Amounts to Periods
25.6.1
Understanding the Methods for Annual Budget Spreads
25.6.1.1
Interactively During Budget Entry
25.6.1.2
Automatically by Running a Program
25.6.2
Understanding How the System Spreads Annual Budget Amounts
25.6.3
Spreading Annual Budget Amounts to Periods During Budget Entry
25.6.4
Running the Spread Annual to Periods Program
25.6.5
Setting Processing Options for Spread Annual to Periods (R14801)
25.6.5.1
Budget Spread
25.7
Generating Budget Worksheets
25.7.1
Understanding Budget Worksheets
25.7.2
Running the Budget Worksheet
25.7.3
Setting Data Selection and Sequence for Budget Worksheet
25.7.4
Setting Processing Options for Budget Worksheet (R14113)
25.7.4.1
Date
25.7.4.2
Ledger Types
25.7.4.3
LOD
25.7.4.4
Signs
25.7.4.5
Computations
25.7.4.6
Headings
25.8
Reviewing Budget Comparisons Online
25.8.1
Understanding the Online Budget Comparison Program
25.8.1.1
AAIs Used by Online Budget Comparison
25.8.2
Form Used to Review Budget Comparisons Online
25.8.3
Setting Processing Options for Online Budget Comparison (P09210A)
25.8.3.1
Default
25.8.3.2
Display
25.8.3.3
Currency
25.8.3.4
Select
25.8.4
Reviewing Budget Comparisons Online
25.9
Managing Budget Overages
25.9.1
Understanding the Management of Budget Overages
25.9.2
Understanding the Budget Checking Calculation
25.9.2.1
Example: Budget Checking Calculation
25.9.2.2
Amounts and Encumbrances
25.9.3
Running the G/L Budget Checking Report
25.9.4
Setting Processing Options for G/L Budget Checking Report (R14115)
25.9.4.1
Ledger Type
25.9.4.2
Budget Year
25.9.4.3
Calculation Methods
25.9.4.4
LOD
25.9.4.5
Subledger
25.10
Entering Detailed Budget Amounts
25.10.1
Understanding the Detailed Budget by Account Program
25.10.2
Forms Used to Enter Detailed Budget Amounts
25.10.3
Entering Detailed Budget Amounts by Account
25.11
Entering Journalized Budgets
25.11.1
Understanding Journalized Budgets
25.11.2
Prerequisites
25.11.3
Forms Used to Enter Journalized Budgets
25.11.4
Entering Budget Journal Entries
26
Uploading Budget Data
26.1
Understanding the Budget Upload Process
26.2
Importing Budget Data from Spreadsheets
26.2.1
Understanding the Import Budget Process for Spreadsheets
26.2.2
Forms Used to Import Budget Data From a Spreadsheet
26.2.3
Setting Processing Options for Upload/Conversion Revisions (P0902Z1)
26.2.3.1
Default
26.2.3.2
Account Number
26.2.4
Importing Budget Data From a Spreadsheet
26.3
Importing Budget Data from Text Files
26.3.1
Understanding the Budget Import Process for Text Files
26.3.2
Prerequisites
26.3.3
Copying Budget Data into the F0902Z2 Text File
26.3.3.1
Adding Column Headings
26.3.4
Running the Budget Import Field Mapping Program
26.3.5
Setting Processing Options for Budget Import Field Mapping (R14110M)
26.3.5.1
Ledger Type
26.3.5.2
Account Number
26.4
Revising Imported Budget Data
26.4.1
Understanding Revisions to Imported Budget Data
26.4.2
Form Used to Revise Imported Budget Data
26.4.3
Revising Imported Budget Data
26.5
Uploading Budget Data to the F0902 Table
26.5.1
Understanding the Upload/Conversion Program
26.5.2
Running the Upload/Conversion Program
26.5.3
Setting Processing Options for Upload/Conversion (R14110)
26.5.3.1
Period
26.5.3.2
Budget Cycle
26.5.3.3
Replace Entries
26.5.3.4
Reverse Sign
26.5.3.5
Job Cost
26.5.3.6
Mode
26.5.3.7
Purge
26.6
Purging Processed Records in the F0902Z1 Table
26.6.1
Understanding the Processed Upload Purge Program
26.6.2
Running the Processed Upload Purge Program
27
Forecasting and Planning Budgets
27.1
Understanding Budget Forecasting and Planning
27.2
Defining Accounts and Retrieving Basis Amounts
27.2.1
Understanding Account Definition and Basis Amounts
27.2.1.1
Manual Account and Basis Amount Retrieval
27.2.1.2
Automatic Account and Basis Amount Generation
27.2.2
Forms Used to Manually Define Accounts and Retrieve Basis Amounts
27.2.3
Defining Accounts and Retrieving Basis Amounts Manually
27.2.4
Generating Accounts and Basis Amounts Automatically
27.2.5
Setting Processing Options for Generate Forecast Basis (R1403)
27.2.5.1
Process
27.3
Revising Accounts and Basis Amounts
27.3.1
Understanding Account and Basis Amount Revisions
27.3.2
Forms Used to Revise Accounts and Basis Amounts
27.3.3
Revising Accounts and Basis Amounts
27.4
Generating Budget Forecast Amounts
27.4.1
Understanding Budget Forecast Amount Generation
27.4.2
Prerequisite
27.4.3
Running the Generate Forecast Results Program
27.4.4
Setting Data Selection for Generate Forecast Basis
27.4.5
Setting Processing Options for Generate Forecast Results (R1404)
27.4.5.1
Process
27.5
Revising Budget Forecast Amounts
27.5.1
Understanding Budget Forecast Amount Revisions
27.5.2
Forms Used to Revise Budget Forecast Amounts
27.5.3
Revising Budget Forecast Amounts
27.6
Updating Budget Forecast Records
27.6.1
Understanding the Budget Forecast Update Program
27.6.2
Prerequisite
27.6.3
Running the Apply Forecast to Budget Program
27.6.4
Setting Data Selection for Apply Forecast to Budget
27.6.5
Setting Processing Options for Apply Forecast to Budget (R1407)
27.6.5.1
Budget Ledger
27.7
Purging Budget Forecast Records
27.7.1
Understanding the Budget Forecast Purge Programs
27.7.2
Running the Purge Forecast Basis and Purge Forecast Results Programs
27.7.3
Setting Data Selection for Purge Forecast Basis and Purge Forecast Results
28
Processing Cash Forecast Data
28.1
Refreshing Cash Forecast Data
28.1.1
Understanding the Refresh Cash Forecast Data Program
28.1.1.1
Extract A/R Cash Forecast Data and Extract A/P Cash Forecast Data Programs
28.1.1.2
Extract G/L Cash Forecast Data Program
28.1.2
Refreshing Cash Forecast Data
28.1.3
Setting Processing Options for Refresh Cash Forecast Data (R00522)
28.1.3.1
Process
28.1.3.2
Version
28.1.3.3
Purge
28.2
Analyzing Cash Forecast Information
28.2.1
Understanding Cash Forecast Information
28.2.2
Understanding Bank Account Opening Balances
28.2.3
Prerequisites
28.2.4
Form Used to Analyze Cash Forecast Information
28.2.5
Setting Processing Options for Cash Forecast Analysis (P09522)
28.2.5.1
Display
28.2.5.2
Options
28.2.5.3
Version
28.2.6
Analyzing Cash Forecast Information
28.2.6.1
Error Message: G/L Cash Type Rule Not Found for [Account]
28.3
Purging Forecast Data
28.3.1
Understanding the Cash Forecast Purge
28.3.2
Purging Cash Forecast Data
28.3.3
Setting Processing Options for Purge Cash Forecast Data (R09522B)
28.3.3.1
Select
29
Creating Cash Basis Entries
29.1
Understanding Cash Basis Accounting
29.1.1
Using the AZ Ledger for Mexican IETU Calculations
29.2
Understanding Accrual Entries
29.3
Understanding Cash Basis Entries
29.3.1
Cash Basis Entries for Account Ledger Records
29.3.2
Cash Basis Entries for Units
29.3.3
Cash Basis Entries for Accounts Payable and Accounts Receivable
29.3.4
Example: How Cash Basis Entries Are Created
29.4
Running the Cash Basis Program from the Menu
29.4.1
Understanding When to Run the Cash Basis Program from the Menu
29.4.2
Understanding Multithreaded Job Queues
29.4.3
Running the Create Cash Basis Entries Program from the Menu
29.4.4
Setting Processing Options for the Create Cash Basis Entries Program (R11C850)
29.4.4.1
Process Tab
29.4.4.2
Defaults Tab
29.4.4.3
Versions Tab
29.5
Running the Cash Basis Program from the Post
29.5.1
Understanding When to Run the Cash Basis Program from the Post
29.5.2
Running the Cash Basis Entries Program from the General Ledger Post Program (R09801)
29.5.3
Setting Processing Options for General Ledger Post (R09801)
29.5.3.1
Cash Basis Tab
29.6
Reviewing Exception Reports
29.7
Reviewing Cash Basis Entries
29.7.1
Setting Data Selection for Unposted Cash Basis Report
29.7.2
Printing the Unposted Cash Basis Report
29.8
Posting Cash Basis Entries
30
Using 52 Period Accounting
30.1
Posting 52 Period Accounting Entries
30.1.1
Understanding the 52 Period Accounting Post Program
30.1.1.1
Multithreaded Job Queues
30.1.2
Running the 52 Period Accounting Post Program
30.1.3
Setting the Processing Options for 52 Period Accounting Post (R098011)
30.1.3.1
Versions Tab
30.2
Closing a 52 Period Year
30.2.1
Understanding the Annual Close for 52 Period Program
30.2.2
Prerequisite
30.2.3
Running the Annual Close for 52 Period Program
30.2.4
Setting Data Selection for Annual Close for 52 Period (R09820B)
30.3
Producing a 52 Period Income Statement
30.3.1
Prerequisites
30.3.2
Setting Data Selection and Sequence for 52 Period Income Statement
30.3.3
Setting Processing Options for 52 Period Income Statement (R10252)
30.3.4
Generating the 52 Period Income Statement
31
Understanding Account Consolidations
31.1
Account Consolidations
31.1.1
Online Consolidation Method
31.1.2
High-Volume Consolidation Method
31.1.2.1
Example: High-Volume Consolidation
31.1.3
Multisite Consolidation Method
32
Processing Online Consolidations
32.1
Understanding Organization Report Structures
32.1.1
Hierarchical Organization Report Structures
32.1.2
Organization Report Structures Without Category Codes
32.2
Prerequisites
32.3
Creating Hierarchical Organization Report Structures
32.3.1
Understanding How to Define and Build Organization Report Structures
32.3.2
Forms Used to Create Hierarchical Organization Report Structures
32.3.3
Defining Organization Report Structures
32.3.4
Building Organization Report Structures
32.3.5
Setting Processing Options for Business Unit Structure Build (R10450)
32.3.5.1
Mode
32.3.5.2
Structure Name
32.3.5.3
BU Creation
32.4
Adding Organization Report Structures Without Using Category Codes
32.4.1
Understanding Organization Report Structures Without Category Codes
32.4.2
Forms Used to Add Organization Report Structures Without Category Codes
32.4.3
Adding an Organization Report Structure Without Using Category Codes
32.5
Reviewing and Rearranging Organization Report Structures
32.5.1
Understanding Organization Report Structure Revisions
32.5.2
Form Used to Review and Rearrange Organization Report Structures
32.5.3
Reviewing and Rearranging Organization Report Structure Components
32.6
Creating Additional Business Units and Copying Report Structures
32.6.1
Forms Used to Create Additional Business Units and Copy Report Structures
32.6.2
Setting Processing Options for Organization Structure Inquiry/Revisions (P0050)
32.6.2.1
Structure Type
32.6.2.2
Manager Name
32.6.3
Creating Additional Child Business Units
32.6.4
Copying Organization Report Structures
32.7
Creating Online Consolidations
32.7.1
Understanding Online Consolidation Creation
32.7.1.1
Example: Consolidating Business Units by Category Code
32.7.1.2
Example: Consolidating Business Units by Organization Report Structure
32.7.2
Forms Used to Create Online Consolidations
32.7.3
Consolidating Business Units
32.7.3.1
Menu Selections
32.8
Reviewing Online Consolidations
32.8.1
Forms Used to Review Online Consolidations
32.8.2
Setting Processing Options for Online Consolidations (P09218)
32.8.2.1
Ledger Type
32.8.2.2
Balances
32.8.2.3
Additional LT
32.8.2.4
Subledger
32.8.2.5
Account LOD
32.8.2.6
Currency Code
32.8.2.7
BU Detail
32.8.2.8
Process Mode
32.8.2.9
Date Effective
32.8.2.10
Job Cost
32.8.3
Reviewing Consolidated Financial Statements Online
33
Processing High-Volume Consolidations
33.1
Understanding High-Volume Consolidation Processing
33.2
Deleting Prior High-Volume Consolidations
33.2.1
Understanding the Delete Prior Consolidation Program
33.2.2
Deleting Prior Consolidations
33.2.3
Setting Processing Options for Delete Prior Consolidations (R10861)
33.2.3.1
Default PO
33.3
Creating High-Volume Consolidations
33.3.1
Understanding the Refresh Consolidation Program
33.3.2
Understanding the Structure of Fictitious Business Units
33.3.2.1
Example: Fictitious Business Units
33.3.3
Understanding Records Created by the Refresh Consolidation Program
33.3.4
Prerequisites
33.3.5
Form Used to Review High-Volume Consolidations
33.3.6
Running the Refresh Consolidation Program
33.3.7
Setting Data Selection and Sequence for Refresh Consolidations
33.3.8
Setting Processing Options for Refresh Consolidation (R10862)
33.3.8.1
Default PO
33.3.8.2
Performance
33.4
Reviewing High-Volume Consolidations
33.4.1
Understanding High-Volume Consolidation Review
33.4.2
Setting Processing Options for Consolidation Review (P09210A)
33.4.2.1
Default
33.4.2.2
Display
33.4.2.3
Currency
33.4.2.4
Select
33.4.3
Reviewing High-Volume Consolidations
34
Processing Multisite Consolidations
34.1
Understanding Source and Target Site Tasks
34.1.1
Source Site Tasks
34.1.2
Target Site Tasks
34.2
Understanding Multiple Consolidation Tiers
34.3
Understanding Multisite Consolidation Structures and Tables
34.4
Running Control File Reports
34.4.1
Understanding Control File Reports
34.4.2
Prerequisites
34.4.3
Running the Create UDC Control File Report
34.4.4
Setting Processing Options for Create UDC Control File (R10005)
34.4.4.1
Version
34.4.5
Running the Create Obj/Sub Control File Report
34.4.6
Setting Processing Options for Create Obj/Sub Control File (R10909)
34.4.6.1
Data Selection
34.5
Creating Organizational Structures
34.5.1
Understanding Organizational Structures
34.5.2
Forms Used to Create Organizational Structures
34.5.3
Defining Organizational Structures
34.6
Creating Account Structures
34.6.1
Understanding Account Structure Components
34.6.1.1
Account Structure Definition
34.6.1.2
Account Structure Build
34.6.2
Forms Used to Define an Account Structure
34.6.3
Defining an Account Structure
34.6.4
Building Account Structures
34.6.5
Setting Data Sequence for Account Structure Build
34.6.6
Setting Processing Options for Account Structure Build (R10430)
34.6.6.1
Process
34.6.6.2
Structure Name
34.6.6.3
Target Object
34.6.6.4
Target Sub
34.6.6.5
LOD
34.7
Revising and Printing Account Structures
34.7.1
Understanding Account Structure Revisions
34.7.2
Forms Used to Revise Account Structures
34.7.3
Revising Account Structures
34.7.4
Printing the Account Structure Report
34.7.5
Setting Processing Options for Account Structure Report (R10445)
34.7.5.1
LOD
34.8
Defining Multisite Consolidation Rules
34.8.1
Understanding Components of Multisite Consolidation Rules
34.8.2
Understanding Consolidation Rules
34.8.3
Understanding Elimination Rules
34.8.4
Forms Used to Define Consolidation and Elimination Rules
34.8.5
Defining Consolidation Rules
34.8.5.1
Business Unit Structure
34.8.5.2
Additional Setup
34.8.6
Defining Elimination Rules
34.9
Creating Consolidated Balances
34.9.1
Understanding the Process Consolidations Program
34.9.1.1
Reports Created by the Process Consolidations Program
34.9.2
Processing Consolidations
34.9.3
Setting Processing Options for Process Consolidations (R10550)
34.9.3.1
Process
34.9.3.2
BU Creation
34.9.3.3
Business Unit Type
34.9.3.4
Site ID
34.9.3.5
Variance
34.9.3.6
Eliminations
34.9.3.7
Currency
34.10
Running the Multisite Consolidations Reports
34.10.1
Understanding Multisite Consolidation Integrity Reports
34.10.2
Understanding the BU/Accounts Monthly Comparison Report
34.10.3
Running the Prior Period Balance Integrity Report
34.10.4
Setting Processing Options for Prior Period Balance Integrity (R10700)
34.10.4.1
Status
34.10.5
Running the UDC Value Control Exceptions Report
34.10.6
Setting Processing Options for UDC Value Control Exceptions (R107011)
34.10.6.1
Version
34.10.7
Running the Object/Subsidiary Value Control Exceptions Report
34.10.8
Setting Processing Options for Object/Subsidiary Value Control Exceptions Report (R107021)
34.10.8.1
Data Selection
34.10.9
Running the BU/Accounts Monthly Comparison Report (R10701)
34.10.10
Setting Data Selection and Sequence for BU/Accounts Monthly Comparison Report
34.10.11
Setting Processing Options for BU/Accounts Monthly Comparison Report (R10701)
34.10.11.1
Process
34.10.12
Running the Consolidated Balance Sheet Report
34.10.13
Setting Processing Options for Consolidated Balance Sheet (R10150)
34.10.13.1
Signs
34.10.13.2
Accounts
34.10.14
Running the Consolidated Income Statement Report
34.10.15
Setting Processing Options for Consolidated Income Statement (R10250)
34.10.15.1
Signs
34.10.15.2
Accounts
34.11
Reviewing Consolidation Statuses
34.11.1
Understanding the Consolidation Console Program
34.11.2
Form Used to Review Consolidation Statuses
34.11.3
Reviewing Consolidation Statuses
34.12
Sending Consolidated Balances by Batch to the Target Company
34.12.1
Understanding the Process to Send Consolidated Balances to the Target Company
34.12.2
Understanding the MSC Data Transmission Program
34.12.3
Prerequisites
34.12.4
Running the MSC Data Transmission Program
34.12.5
Setting Processing Options for MSC Data Transmission (R10610)
34.12.5.1
Integrities
34.13
Sending Consolidated Balances Interactively to the Target Company
34.13.1
Understanding the Process to Send Consolidated Balances to the Target Company
34.13.2
Understanding the Consolidation Console Program
34.13.3
Form Used to Send Consolidated Balances Interactively to the Target Company
34.13.4
Setting Processing Options for Consolidation Console (P10610)
34.13.4.1
Integrities
34.13.5
Sending Consolidated Balances Interactively to the Target Company
34.14
Processing Consolidated Balances from Non-EnterpriseOne Source Sites
34.14.1
Understanding Inbound Multisite Consolidations
34.14.2
Understanding the Inbound Multisite Consolidations Process
34.14.3
Processing Inbound Consolidations Data
34.14.4
Setting Processing Options for Process Inbound Consolidations Data (R1002Z1)
34.14.4.1
Mode
34.14.4.2
JE Processing
34.14.4.3
Purge Data
34.15
Revising Inbound Consolidations
34.15.1
Understanding Inbound Consolidations Revisions
34.15.2
Forms Used to Revise Inbound Consolidations
34.15.3
Revising an Inbound Consolidation
34.16
Purging Inbound Consolidations Data
34.16.1
Purging Inbound Consolidations
34.17
Generating Multisite Batch Journal Entries
34.17.1
Understanding the Journalize Consolidation Balances Program
34.17.2
Prerequisites
34.17.3
Generating Multisite Batch Journal Entries
34.17.4
Setting Data Selection for Journalize Consol. Balances
34.17.5
Setting Processing Options for Journalize Consol. Balances (R10480)
34.17.5.1
Mode
34.17.5.2
Company
34.17.5.3
Ledger Type
34.17.5.4
Prior Period
34.17.5.5
Business Unit
34.17.5.6
Account Number
34.17.5.7
JE Processing
34.18
Processing and Purging Multisite Batch Journal Entries
34.18.1
Understanding Multisite Batch Journal Entry Processing and Purging
34.18.2
Processing Batch Journal Entries
34.18.3
Purging Processed Multisite Journal Entries
35
Reviewing Balances and Transactions
35.1
Understanding Online Inquiries
35.2
Understanding Statutory Inquiries
35.3
Understanding Trial Balance Inquiries
35.4
Understanding Account Ledger and Balance Inquiries
35.5
Reviewing Trial Balances, Ledgers, and Subledgers
35.5.1
Understanding Trial Balance and Ledger Comparisons
35.5.2
Forms Used to Review Balances, Ledgers, and Subledgers
35.5.3
Setting Processing Options for Trial Balance/Ledger Comparison (P09210A)
35.5.3.1
Default
35.5.3.2
Display
35.5.3.3
Currency
35.5.3.4
Select
35.5.4
Reviewing Trial Balances and Ledger Comparisons
35.5.4.1
Access to Other Programs from the Row Menu
35.5.5
Reviewing Trial Balance Subledger Information
35.6
Reviewing Trial Balances
35.6.1
Understanding Trial Balance Review
35.6.2
Forms Used to Review Trial Balances
35.6.3
Setting Processing Options for T/B by Object Account (P09214)
35.6.3.1
Select
35.6.3.2
Default
35.6.3.3
Display
35.6.4
Setting Processing Options for T/B by Company (P09216)
35.6.4.1
Display
35.6.5
Setting Processing Options for T/B by Subledger (P09215)
35.6.6
Reviewing Balances by Object Account
35.6.6.1
Access to Other Programs from the Row Menu
35.6.7
Reviewing Balances by Company
35.6.8
Reviewing Balances by Subledger
35.6.8.1
Access to Other Programs from the Row Menu
35.7
Reviewing Account Ledgers
35.7.1
Understanding Account Ledger Inquiry
35.7.2
Understanding Account Ledger by Object Account
35.7.3
Understanding Account Ledger by Category Code
35.7.4
Prerequisite
35.7.5
Forms Used to Review Account Ledgers
35.7.6
Setting Processing Options for Account Ledger Inquiry (P09200)
35.7.6.1
Defaults
35.7.6.2
Select
35.7.6.3
Display
35.7.6.4
Process
35.7.6.5
Currency
35.7.7
Using Real-Time Summarization in the Account Ledger Inquiry Program (P09200)
35.7.8
Reviewing Account Ledger Transactions
35.7.9
Setting Processing Options for Account Inquiry by Object Account (P09201)
35.7.9.1
Defaults
35.7.10
Using Real-Time Summarization in the Account Inquiry by Object Account Program (P09201)
35.7.11
Reviewing Ledgers by Object Account
35.7.12
Setting Processing Options for Account Inquiry by Category Code (P09202)
35.7.12.1
Category Code
35.7.12.2
Defaults
35.7.13
Using Real-Time Summarization in the Account Inquiry by Category Code Program (P09202)
35.7.14
Reviewing Ledgers by Category Code
35.8
Reviewing Account Balances by Month
35.8.1
Understanding Account Balances Review
35.8.2
Forms Used to Review Account Balances
35.8.3
Setting Processing Options for Account Balance by Month (P0902P1)
35.8.3.1
Defaults
35.8.4
Reviewing Monthly Account Balances
35.8.5
Reviewing Balances by Subledger
36
Generating Financial Reports
36.1
Understanding Financial Reports
36.1.1
Types of Financial Reports
36.2
Setting Up Data Selection and Data Sequence for the Simple Income Statement and Simple Balance Sheet
36.3
Generating a Simple Income Statement
36.3.1
Understanding the Simple Income Statement
36.3.2
Prerequisites
36.3.3
Printing a Simple Income Statement
36.3.4
Setting Data Selection for Simple Income Statement
36.3.5
Setting Processing Options for Simple Income Statement (R10211B)
36.3.5.1
Date
36.3.5.2
LOD
36.3.5.3
Signs
36.3.5.4
Calculations
36.3.5.5
Headings
36.4
Generating a Simple Balance Sheet
36.4.1
Understanding the Simple Balance Sheet
36.4.1.1
How Net Income Is Calculated
36.4.1.2
Example: Net Income Calculation
36.4.2
Prerequisites
36.4.3
Printing a Simple Balance Sheet
36.4.4
Setting Data Selection for Simple Balance Sheet
36.4.5
Setting Processing Options for Simple Balance Sheet (R10111B)
36.4.5.1
Signs
36.4.5.2
Computations
36.5
Generating a Statement of Cash Flow
36.5.1
Understanding the Statement of Cash Flow
36.5.1.1
Example: Statement of Cash Flow
36.5.2
Prerequisites
36.5.3
Printing the Statement of Cash Flow
36.5.4
Setting Data Selection for Statement of Cash Flow Report
36.5.5
Setting Processing Options for Statement of Cash Flow Report (R10521)
36.5.5.1
Select
36.5.5.2
Display
36.6
Generating Consolidated Financial Reports
36.6.1
Understanding Consolidated Financial Reports
36.6.2
Prerequisite
36.6.3
Printing a Consolidated Income- 7 Column Statement
36.6.4
Setting Data Selection and Sequence for Consolidated Income-7 Column
36.6.5
Setting Processing Options for Consolidated Income-7 Column (R103121A)
36.6.5.1
Amounts
36.6.5.2
Calculations
36.6.6
Printing a Consolidated Balance Sheet
36.6.7
Setting Data Selection and Sequence for Consolidated Balance Sheet
36.6.8
Setting Processing Options for Consolidated Balance Sheet (R10311A)
36.6.8.1
Calculations
36.6.8.2
Signs
36.7
Generating Monthly Spreadsheets
36.7.1
Understanding Monthly Spreadsheets
36.7.2
Prerequisite
36.7.3
Printing the Monthly Spreadsheet
36.7.4
Setting Processing Options for Monthly Spreadsheet (R10412A)
36.7.4.1
Signs
36.7.4.2
Calculations
36.7.4.3
Columns
36.8
Generating Variance Analysis Reports
36.8.1
Printing the Variance Analysis Report
36.8.2
Setting Processing Options for Variance Analysis (R10212A)
36.8.2.1
Dates
36.8.3
Printing the Variance Analysis w/5 Months Report
36.8.4
Setting Processing Options for Variance Analysis w/5 Months (R10411A)
37
Verifying Data Integrity for General Accounting
37.1
Understanding General Accounting Integrity Reports and Programs
37.1.1
Batch Header Reports and Programs
37.1.2
Out-of-Balance Reports and Programs
37.1.3
Chart of Accounts Reports and Programs
37.2
Running the Transactions to Batch Headers Report
37.2.1
Understanding the Transactions To Batch Headers Report
37.2.2
Printing the Transactions to Batch Headers Report
37.2.3
Setting Processing Options for Transactions to Batch Headers (R007021)
37.2.3.1
Post/Unposted
37.2.3.2
Select
37.2.3.3
G/L
37.2.3.4
A/R
37.2.3.5
A/P
37.2.3.6
Options
37.2.4
Correcting Discrepancies on the Transactions To Batch Headers Report
37.2.4.1
Missing Batch Header Records
37.2.4.2
Posted Batch Header Record, No Posted Detail
37.3
Working with the Transactions to Batch Headers Program
37.3.1
Understanding the Transactions to Batch Headers Program
37.3.2
Forms Used to Review Transactions to Batch Headers
37.3.3
Setting Processing Options for the Transactions to Batch Headers Program (P0072131)
37.3.3.1
Defaults
37.3.3.2
Process
37.3.3.3
Version
37.3.4
Reviewing Transactions to Batch Header
37.4
Running the Batch to Detail Report
37.4.1
Understanding the Batch to Detail Report
37.4.2
Prerequisite
37.4.3
Printing the Batch to Detail Report
37.4.4
Setting Processing Options for Batch to Detail (R007031)
37.4.4.1
Date Range
37.4.4.2
A/R
37.4.4.3
A/P
37.4.4.4
Batch
37.5
Running the Unposted Batches Report
37.5.1
Understanding the Unposted Batches Report
37.5.2
Prerequisite
37.5.3
Printing the Unposted Batches Report
37.6
Running the Batches Out of Balance Report
37.6.1
Understanding the Batches Out of Balance Report
37.6.2
Printing the Batches Out of Balance Report
37.6.3
Setting Data Selection for Batches Out of Balance
37.6.4
Setting Processing Options for Batches Out of Balance (R007032)
37.6.4.1
Date Range
37.6.4.2
Ledger Type
37.6.5
Correcting Discrepancies on the Batches Out of Balance Report
37.6.5.1
Batches Posted Out of Balance
37.6.5.2
Batch is Partially Posted
37.7
Working with the Batches Out of Balance Program
37.7.1
Understanding the Batches Out of Balance Program
37.7.2
Prerequisite
37.7.3
Form Used to Resolve Batch Out of Balance Errors
37.7.4
Setting Processing Options for the Batches Out of Balance Program (P007032)
37.7.4.1
Defaults
37.7.4.2
Versions
37.7.5
Reviewing Batches Out of Balance
37.8
Running the Company by Batch Out of Balance Report
37.8.1
Understanding the Company by Batch Out of Balance Report
37.8.2
Prerequisite
37.8.3
Printing the Company by Batch Out of Balance Report
37.8.4
Setting Processing Options for Company by Batch Out of Balance (R09706)
37.8.4.1
Additional Ledger
37.8.5
Correcting Discrepancies on the Company by Batch Out of Balance Report
37.8.5.1
A Batch is Out of Balance by Batch and Company
37.9
Working with the Companies by Batch Out of Balance Program
37.9.1
Understanding the Companies by Batch Out of Balance Program
37.9.2
Prerequisite
37.9.3
Forms Used to Resolve Companies by Batch Out of Balance Errors
37.9.4
Setting Processing Options for the Companies by Batch Out of Balance Program (P09706)
37.9.4.1
Defaults
37.9.4.2
Versions
37.9.5
Reviewing Companies by Batch Out of Balance
37.10
Running the Companies in Balance Report
37.10.1
Understanding the Companies in Balance Report
37.10.2
Printing the Companies in Balance Report
37.10.3
Locating Out-of-Balance Companies
37.10.4
Correcting Discrepancies on the Companies in Balance Report
37.10.4.1
Company is Out of Balance in YTD Column
37.10.4.2
Two Companies are Out of Balance by the Same Amount in the YTD Column
37.10.4.3
Amount in PACO (Post After Cut Off) Column
37.10.4.4
Prior Year Total for a Company That is Out of Balance
37.10.4.5
Missing Company
37.11
Working with the Companies Out of Balance Program
37.11.1
Understanding the Companies Out of Balance Program
37.11.2
Forms Used to Review Companies Out of Balance
37.11.3
Setting Processing Options for the Companies Out of Balance Program (P097001)
37.11.3.1
Defaults
37.11.3.2
Display
37.11.4
Reviewing Companies Out of Balance
37.12
Running the Intercompany Accounts in Balance Report
37.12.1
Understanding the Intercompany Accounts in Balance Report
37.12.2
Printing the Intercompany Accounts in Balance Report
37.12.3
Setting Processing Options for Intercompany Accounts in Balance (R097011)
37.12.3.1
Ledger Type
37.12.4
Locating Out-of-Balance Intercompany Accounts
37.12.5
Correcting Discrepancies on the Intercompany Accounts in Balance Report
37.12.5.1
Intercompany Accounts Do Not Balance
37.13
Running the Account Balance to Transactions Report
37.13.1
Understanding the Account Balance to Transactions Report
37.13.2
Printing the Account Balance to Transactions Report
37.13.3
Setting Processing Options for Account Balance to Transactions (R09705)
37.13.3.1
Select
37.13.3.2
Options
37.13.3.3
Units
37.13.4
Correcting Discrepancies on the Account Balance to Transactions Report
37.13.4.1
Account Balance and Detail Columns are Out of Balance
37.13.4.2
Balance Column Has an Amount and Detail Column Does Not Have an Amount
37.13.4.3
Date Pattern is Incorrect
37.14
Running the Accounts without Business Units Report
37.14.1
Understanding the Accounts without Business Units Report
37.14.2
Printing the Accounts without Business Units Report
37.14.3
Setting Processing Options for Accounts w/o Business Units (R097041)
37.14.3.1
Update
37.15
Working with the Accounts to Business Units Program
37.15.1
Understanding the Accounts to Business Units Program
37.15.2
Prerequisite
37.15.3
Forms Used to Resolve Account to Business Unit Errors
37.15.4
Setting Processing Options for the Accounts to Business Units Program (P097041)
37.15.4.1
Defaults
37.15.4.2
Versions
37.15.5
Reviewing Errors Between Accounts and Business Units
37.15.5.1
Header
37.15.5.2
Grid
37.16
Running the Account Balance without Account Master Report
37.16.1
Understanding the Account Balance without Account Master Report
37.16.2
Prerequisite
37.16.3
Printing the Account Balance without Account Master Report
37.16.4
Setting Processing Options for Account Balance without Account Master (R097031)
37.16.4.1
Update
37.16.5
Correcting Discrepancies on the Account Balance without Account Master Report
37.16.5.1
Account Master Company Column is Blank
37.16.5.2
Company Number is Not in the Account Balances Table
37.17
Working with the Account Balance to Account Master Program
37.17.1
Understanding the Account Balance to Account Master Program
37.17.2
Prerequisite
37.17.3
Forms Used to Resolve Account Balance to Account Master Errors
37.17.4
Setting Processing Options for the Account Balance to Account Master Program (P097031)
37.17.4.1
Defaults
37.17.4.2
Versions
37.17.5
Reviewing Account Balance to Account Master Errors
37.17.5.1
Header
37.17.5.2
Grid
37.18
Running the Transactions without Account Master Report
37.18.1
Understanding the Transactions without Account Master Report
37.18.2
Prerequisite
37.18.3
Printing the Transactions without Account Master Report
37.18.4
Setting Processing Options for Transactions w/o Acct Master (R097021)
37.18.4.1
Update
37.18.5
Correcting Discrepancies on the Transactions without Account Master Report
37.18.5.1
Company Number is Not in the Account Ledger Table
37.19
Working with the Account Ledger to Account Master Program
37.19.1
Understanding the Account Ledger to Account Master Program
37.19.2
Prerequisite
37.19.3
Forms Used to Resolve Account Ledger to Account Master Errors
37.19.4
Setting Processing Options for the Account Ledger to Account Master Program (P097021)
37.19.4.1
Defaults
37.19.4.2
Versions
37.19.5
Reviewing Account Ledger to Account Master Errors
37.19.5.1
Header
37.19.5.2
Grid
37.20
Running the Financial Integrities Work Table Purge
37.20.1
Understanding the Financial Integrities Work Table Purge Report
37.20.2
Running the Financial Integrities Work Table Purge Report
37.20.3
Setting Processing Options for the Financial Integrities Work Table Purge (R007013)
37.20.3.1
Select
38
Maintaining Batch Headers
38.1
Understanding Batch Header Revisions
38.2
Prerequisite
38.3
Working with Batch Headers
38.3.1
Forms Used to Work with Batch Headers
38.3.2
Reviewing Batch Headers
38.3.3
Adding and Revising Batch Headers
38.3.4
Revising Batches to Post Out of Balance
39
Reposting the Account Ledger and Recalculating a Fiscal Year
39.1
Understanding the Repost Programs
39.2
Prerequisites
39.3
Reposting the Account Ledger
39.3.1
Understanding When to Repost the Account Ledger
39.3.1.1
Example: F0911 and F0902 Tables Are Out of Balance
39.3.1.2
Example: Batch Is Partially Posted
39.3.1.3
Example: After Recalculating Fiscal Year and Period
39.3.2
Prerequisite
39.3.3
Running the Repost Account Ledger Program
39.3.4
Setting Data Selection and Sequence for Repost Account Ledger
39.3.5
Setting Processing Options for Repost Account Ledger (R099102)
39.3.5.1
Mode
39.4
Recalculating the Fiscal Year and Period
39.4.1
Understanding When to Recalculate the Fiscal Year and Period
39.4.1.1
Example: Fiscal Date Pattern Changes to a Calendar Date Pattern
39.4.1.2
Example: Calendar Date Pattern Changes to a Fiscal Date Pattern
39.4.2
Running the Calculate Fiscal Year and Period Program
39.4.3
Setting Data Selection and Sequence for Calculate Fiscal Year and Period
39.4.4
Setting Processing Options for Calculate Fiscal Year and Period (R099103)
39.4.4.1
Mode
40
Reposting the Burdening Ledger and Recalculating a Fiscal Year
40.1
Reposting the Burdening Ledger
40.1.1
Understanding the Burdening Ledger Repost Program
40.1.2
Prerequisite
40.1.3
Setting Processing Options for Repost Burdening Ledger (R52G102)
40.1.3.1
Mode
40.1.4
Running the Repost Burdening Ledger Program
40.2
Recalculating a Fiscal Year and Period Number
40.2.1
Understanding Recalculating the Fiscal Year and Period Number
40.2.2
Prerequisites
40.2.3
Setting Processing Options for Recalculate Fiscal Year and Period Number Program (R52G103)
40.2.3.1
Mode
40.2.4
Running the Recalculate Fiscal Year and Period Number Program
41
Revising an Organization
41.1
Understanding Organization Revisions
41.2
Understanding Account Structure Revisions
41.3
Understanding Tables Affected by Account Structure Revisions
41.4
Prerequisite
41.5
Changing a Business Unit on Multiple Accounts
41.5.1
Understanding Changes to a Business Unit
41.5.2
Prerequisite
41.5.3
Form Used to Change a Business Unit on Multiple Accounts
41.5.4
Changing a Business Unit on Multiple Accounts
41.6
Changing Accounts by Object
41.6.1
Understanding Changes to Accounts by Object
41.6.2
Form Used to Change Accounts by Object
41.6.3
Changing Accounts by Object
41.7
Changing Accounts by Subsidiary
41.7.1
Understanding Changes to Accounts by Subsidiary
41.7.2
Form Used to Change Accounts by Subsidiary
41.7.3
Changing Subsidiary Accounts
41.8
Updating the F0911, F0902, F03B117 Tables
41.8.1
Understanding the Process to Update the F0911, F0902, F03B117 Tables
41.8.2
Prerequisites
41.8.3
Running the Update BU.Obj.Sub to Jrnl Ent Program
41.8.4
Tasks to Complete After Running the Update BU.Obj.Sub to Jrnl Ent Program
41.9
Updating the Burdening Tables with Account Revisions
41.9.1
Understanding the Global Update BU/OBJ/SUB to F52G11/F52G02 Program
41.9.2
Setting Processing Options for Global Update BU/OBJ/SUB to F52G11/F52G02 (R52G806)
41.9.2.1
Print
41.9.3
Running the Global Update BU/OBJ/SUB to F52G11/F52G02 Program
41.10
Changing the Company Number on a Business Unit
41.10.1
Understanding Changes to the Company Number on a Business Unit
41.10.2
Moving a Business Unit to a Different Company
41.11
Changing Account Information
41.11.1
Understanding Account Information Changes
41.11.2
Running the Change Account Information Program
41.11.3
Setting Data Selection for Change Account Information
41.11.4
Setting Processing Options for Change Account Information (R09813)
41.11.4.1
Global Update
41.11.4.2
Account Info
41.11.4.3
ACA
41.11.4.4
Alt Desc
41.12
Updating the Model/Consolidated Field
41.12.1
Understanding Model/Consolidated Field Updates
41.12.2
Running the Update Model/Consolidated Field Program
41.13
Updating Category Codes for Business Units
41.13.1
Understanding Category Code Updates
41.13.2
Prerequisite
41.13.3
Running the Update Cat Codes F0101>F0006 Program
42
Closing Accounting and Reporting Periods
42.1
Understanding Period-End Close Tasks
42.2
Closing the Accounting Period
42.2.1
Understanding How to Close an Accounting Period
42.2.2
Understanding the Effect of Closing an Accounting Period
42.2.3
Forms Used to Close the Accounting and Reporting Period
42.2.4
Closing an Accounting Period for a Company
42.2.4.1
General Accounting
42.2.4.2
Accounts Payable
42.2.4.3
Accounts Receivable
42.2.5
Closing the Accounting Period and Year for a Company
42.2.6
Closing an Accounting Period for Multiple Companies
42.3
Changing Financial Reporting Periods
42.3.1
Understanding Financial Reporting Dates
42.3.2
Changing a Financial Reporting Period
42.3.2.1
Financial Reporting
43
Closing the Fiscal Year
43.1
Understanding the Fiscal Year Close
43.1.1
Retained Earnings
43.1.2
Balance Sheet Entries
43.1.3
Intercompany Settlements
43.1.4
Prerequisites
43.2
Understanding Setup Requirements and Common Tasks
43.2.1
Understanding Fiscal Year Setup Requirements
43.2.2
Understanding Common Tasks for the Year-End Close
43.3
Closing a Fiscal Year
43.3.1
Understanding the Annual Close Program
43.3.1.1
Error Messages on the Annual Close Report
43.3.2
Running the Annual Close Program
43.3.3
Setting Data Selection and Sequence for Annual Close
43.3.4
Setting Processing Options for Annual Close (R098201)
43.3.4.1
Profit/Loss
43.3.4.2
Orig Budget
43.3.4.3
Print
43.4
Closing a Fiscal Year for Budgets
43.4.1
Understanding the Fiscal Year Close for Budget Ledger Types
44
Summarizing Records and Purging Records
44.1
Understanding Summarizations, Deletions and Purges
44.2
Summarizing Account Ledger Records
44.2.1
Understanding the Summarize Transactions Program
44.2.2
Prerequisites
44.2.3
Summarizing Transactions
44.2.4
Setting Processing Options for Summarize Transactions (R09811)
44.2.4.1
Select
44.3
Purging Prior-Year Records
44.3.1
Understanding the Purge Prior Year JEs Program
44.3.2
Prerequisites
44.3.3
Purging Prior-Year Records
44.3.4
Setting Data Selection for Purge Prior Year JEs
44.3.5
Setting Processing Options for Purge Prior Year JEs (R09911)
44.3.5.1
Delete Options
44.4
Purging Prior-Year Account Balances
44.4.1
Understanding the Purge Prior Year Account Balances Program
44.4.2
Prerequisite
44.4.3
Purging Account Balances for Prior Years
44.5
Deleting Account Master Records
44.5.1
Understanding Deleting Account Master Records
44.5.2
Prerequisite
44.5.3
Running the Delete Account Master Records Program
44.5.4
Setting Processing Options for Delete Account Master Records (R09814)
44.5.4.1
Mode
44.6
Deleting Business Units and Companies
44.6.1
Understanding the Delete Business Unit/Company Program
44.6.2
Prerequisites
44.6.3
Running the Delete Business Unit/Company Program
44.6.4
Setting Processing Options for Delete Business Unit/Company (R09925)
44.6.4.1
Delete Records
A
General Accounting Tables
A.1
Primary Tables
A.2
Supplemental Tables
B
Mapping Fields for Journal Entry Batch Processing
B.1
Mapping Fields in the F0911Z1 Table
B.1.1
Required Fields
B.2
Mapping Fields in the F0911Z1 Table for Burdening
B.2.1
Fields for Burdening
B.3
Mapping Fields in the F0911Z1 Table for Advanced Cost Accounting
B.3.1
Required Fields for the Advanced Cost Accounting System
B.3.2
Optional Fields
B.3.3
Ignored Fields
B.4
Mapping Fields in the F0911Z1 Table for Externally Reconciled Transactions
B.4.1
Required Fields
B.4.2
Updating Reconciled Transactions in EnterpriseOne
C
Field Mapping for Automatic Bank Statement Processing
C.1
Mapping BAI2 Fields to the F09610 and F09611 Tables
C.1.1
Records
C.1.2
Example: BAI2 Text File
C.1.3
Record 01
C.1.4
Record 02
C.1.5
Record 03
C.1.6
Record 16
C.1.7
Record 88
C.1.8
Record 49
C.1.9
Record 98
C.1.10
Record 99
C.2
Mapping SWIFT Fields to the F09610 and F09611 Tables
C.2.1
Blocks
C.2.2
Example: SWIFT Text File
C.2.3
Block 2
C.2.4
Block 4
D
Mapping Fields for Budget Data Import
D.1
Mapping Fields in the F0902Z1 Table
D.1.1
Fields Updated by the Spreadsheet
D.1.2
Fields Updated by the System
E
Mapping Fields for Inbound Multisite Consolidations
E.1
Mapping Fields in the F1001Z1 Table
E.1.1
Required Fields in the F1001Z1 Table
E.1.2
Optional Fields in the F1001Z1 Table
E.1.3
Ignored Fields in the F1001Z1 Table
E.2
Mapping Fields in the F1002Z1 Table
E.2.1
Required Fields in the F1002Z1 Table
E.2.2
Optional Fields in the F1002Z1 Table
E.2.3
Ignored Fields in the F1002Z1 Table
F
Delivered Workflow for JD Edwards EnterpriseOne General Accounting
F.1
Delivered Workflow for JD Edwards EnterpriseOne General Accounting
F.1.1
Journal Entry Batch Approval
F.1.1.1
Description
F.1.1.2
Workflow Objects
F.1.2
Route Expense Report
F.1.2.1
Description
F.1.2.2
Workflow Objects
G
JD Edwards EnterpriseOne General Accounting Reports
G.1
Types of General Accounting Reports
G.1.1
General Journal Reports
G.1.2
Trial Balance Reports
G.2
JD Edwards EnterpriseOne General Accounting Reports: A to Z
G.3
JD Edwards EnterpriseOne General Accounting Reports: Selected Reports
G.3.1
R00650 - Data by Business Unit
G.3.2
Processing Options for Data by Business Unit (R00650)
G.3.2.1
Generic Text
G.3.2.2
SDB Code
G.3.3
R09205P, R09206, R09207- Account Master Reports
G.3.4
Processing Options for the Account Master Reports (R09205P, R09206, R09207)
G.3.4.1
Print
G.3.5
R09301 - Unposted General Journal, General Journal by Batch, Unposted Cash Basis
G.3.5.1
Unposted Cash Basis Report
G.3.5.2
Data Selection and Sequence for the Unposted Cash Basis Report
G.3.6
Processing Options for Unposted General Journal and Unposted Cash Basis Report (R09301)
G.3.6.1
Account Mode
G.3.6.2
Units
G.3.7
R09311 - General Journal by Account
G.3.8
Processing Options for General Journal by Account (R09311)
G.3.9
R09321 - Transaction Journal
G.3.10
Processing Options for Transaction Journal (R09321)
G.3.10.1
Display
G.3.10.2
Print
G.3.11
R09410 - Trial Balance Report
G.3.12
Processing Options for Trial Balance Report (R09410)
G.3.12.1
Period
G.3.12.2
Print
G.3.12.3
LOD
G.3.12.4
Ledger
G.3.12.5
Subledger
G.3.12.6
Currency
G.3.13
R094121 - Trial Balance by Object Report
G.3.14
Processing Options for Trial Balance By Object Report (R094121)
G.3.14.1
Select
G.3.14.2
Print
G.3.14.3
Currency
G.3.14.4
Summarize
G.3.15
R09421 - G/L by Object Account
G.3.16
Processing Options for G/L by Object Account (R09421)
G.3.16.1
Select
G.3.16.2
Print
G.3.16.3
Summarize
G.3.16.4
Currency
G.3.17
R09422 - G/L with Subledger Totals
G.3.18
Processing Options for G/L with Subledger Totals (R09422)
G.3.18.1
Display
G.3.18.2
Print
G.3.18.3
Summarization
G.3.18.4
Currency
G.3.19
R09423 - Transactions by Object
G.3.20
Data Selection for the Transactions by Object
G.3.21
Processing Options for Transactions by Object (R09423) and Transactions by Subsidiary (R09424)
G.3.21.1
Period
G.3.21.2
Ledger
G.3.21.3
Print
G.3.22
R09424 - Transactions by Subsidiary
G.3.23
Data Selection for the Transactions by Subsidiary
G.3.24
Processing Options Transactions by Subsidiary (R09424)
G.3.25
R09451 - Account Totals by Supplier/Customer
G.3.26
Processing Options for Account Totals by Supplier/Customer (R09451)
G.3.26.1
Report Detail
G.3.26.2
Document
G.3.26.3
Currency
G.3.27
R09470 - G/L by Category Code
G.3.28
Processing Options for G/L by Category Code (R09470)
G.3.28.1
Select
G.3.28.2
Print
G.3.28.3
Currency
G.3.29
R09472 - Debit/Credit T/B by Category Code
G.3.30
Processing Options for Debit/Credit T/B by Category Code (R09472)
G.3.30.1
Select
G.3.31
R11C750 - Cash Basis Integrity Test
G.3.32
Data Selection and Sequence for the Cash Basis Integrity Report
G.3.33
Processing Options for the Cash Basis Integrity Test (R11C750)
G.3.33.1
Select
G.3.33.2
Process
G.3.34
R11C760 - Cash Basis Audit Report
G.3.35
Data Selection and Data Sequencing for the Cash Basis Audit Report
G.3.36
Processing Options for Cash Basis Audit Report (R11C760)
G.3.36.1
Display
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.