Contents
1 Introduction to JD Edwards EnterpriseOne General Accounting
- JD Edwards EnterpriseOne General Accounting Overview
- JD Edwards EnterpriseOne General Accounting Business Processes
- JD Edwards EnterpriseOne General Accounting Integrations
- JD Edwards EnterpriseOne Workforce Management
- JD Edwards EnterpriseOne Financial Management
- JD Edwards EnterpriseOne Localization
- JD Edwards EnterpriseOne Capital Asset Management
- JD Edwards EnterpriseOne Logistics Management
- JD Edwards EnterpriseOne Multi-mode Manufacturing
- JD Edwards EnterpriseOne Homebuilder Management
- JD Edwards EnterpriseOne Real Estate Management
- JD Edwards EnterpriseOne Service Management
- JD Edwards EnterpriseOne General Accounting Implementation
- Business Interface Integration Objects
2 Understanding the General Accounting System
3 Setting Up the General Accounting System
- Understanding General Accounting System Setup
- Prerequisite
- Setting Up Constants for General Accounting
- Setting Up User-Defined Codes for General Accounting
- Business Unit Category Codes (00/01–50)
- Account Category Codes (09/01–43)
- Business Unit Type Codes (00/MC)
- Subledger Type Codes (00/ST)
- Reconciliation Codes (09/RC)
- Transaction Codes (09/BJ)
- Acceptable Adjustment Document Types (09/AA)
- Burden Category (48S/BC)
- Burden Rate Type (48S/RT)
- Segment ID (48S/SI)
- Setting Up Ledger Types for General Accounting
- Setting Up Ledger Type Rules for General Accounting
- Setting Up AAIs for General Accounting
- Setting Up Business Unit Supplemental Data
- Setting Up Vertex Sales Tax
4 Setting Up Burdening
- Understanding Burdening Setup
- Setting Up Segment Information
- Setting Up Pool Information
- Setting Up Burdening Rates
5 Setting Up Advanced Variable Numerator Allocations
- Understanding Setup for Advanced Variable Numerator Allocations
- Setting Up Business Unit Overrides
- Setting Up Versions for Account Balance-Based Allocations
- Setting Up Versions for Burdening-Based Allocations
- Setting Up Versions for Joint Venture-Based Allocations
- Setting Up Specifications for Advanced Variable Numerator Allocations
- Understanding the Specifications for Advanced Variable Numerator Allocations
- Forms Used to Set Up Specifications for Advanced Variable Numerator Allocations
- Understanding the Work With Advanced Variable Numerator Form
- Setting Processing Options for Advanced Variable Numerator (P09123)
- Setting Up the Specifications for an Account Balance-Based Allocation
- Setting Up the Specifications for a Burdening-Based Allocation
- Setting Up the Specifications for a Joint Venture-Based Allocation
6 Setting Up Account Reconciliation
- Understanding Account Reconciliation
- Setting Up AAIs for Account Reconciliation
- Setting Up Reconciliation Codes
7 Setting Up Automatic Bank Statement Processing
- Setting Up UDCs for Automatic Bank Statement Processing
- Understanding UDC Setup for Automatic Bank Statement Processing
- Setting Up UDCs for Automatic Bank Statements
- 09/TT - Auto Bank Statement Transaction Types
- 09/DT - Default Date
- 09/FT - E Bank Statement Format
- 09/TD - Transaction Debit/Credit Indicator
- 09/RR - Reconciled Reason Code
- 09/RU - Reconciled Code
- 09/UR - Unreconciled Reason Code
- 09/BA - BAI2 Transaction Types
- 09/ST - SWIFT Transaction Types
- 09/BU - Offset Business Unit
- Setting Up Cross References
- Setting Up Automatic Bank Account Reconciliation
8 Setting Up Budget Forecasting and Planning
9 Setting Up Cash Forecasting
- Understanding Cash Forecasting Setup
- Understanding Cash Type Codes
- Setting Up Cash Type Rules
- Defining a Cash Forecast Report Structure
10 Setting Up Statements of Cash Flow
- Understanding Cash Management
- Understanding Cash Flow Statements
- Setting Up Cash Flow Activity Codes
- Setting Up Normal Balance Codes
- Setting Up Cash Flow Rules
11 Setting Up Cash Basis Accounting
- Understanding Cash Basis Accounting Setup
- Setting Up Cash Basis Document Types
- Setting Up AAIs for Cash Basis Accounting
12 Setting Up 52 Period Accounting
- Setting Up 52 Period Fiscal Date Patterns
- Setting Up 52 Period Reporting Dates
- Changing to 52 Period Accounting
13 Processing Journal Entries
- Understanding the Journal Entry Process
- Understanding Other Methods of Entering Journal Entries
- Working with Journal Entries
- Understanding the Journal Entry Program
- Understanding Types of Journal Entries
- Understanding Journal Entry Features
- Understanding Temporary Invalid Account Numbers
- Forms Used to Work with Journal Entries
- Setting Processing Options for Journal Entry (P0911)
- Setting Processing Options for Journal Entry Master Business Function (P0900049)
- Entering a Basic Journal Entry
- Adding an Attachment to a Journal Entry
- Entering a Journal Entry with an Invalid Account Number
- Entering a Percent Journal Entry
- Copying a Journal Entry
- Revising an Unposted Journal Entry
- Deleting an Unposted Journal Entry
- Working with Reversing Journal Entries
- Working with Model Journal Entries
- Reviewing Journal Entries
- Posting Journal Entries
- Revising and Voiding Journal Entries
14 Processing Batch Journal Entries
- Understanding Journal Entry Batch Processing
- Uploading Batch Journal Entry
- Working with Batch Journal Entries
- Posting Processed Batch Journal Entries
- Purging Processed Batch Journal Entries
15 Processing Allocations
- Understanding Allocations
- Understanding the Process for Creating Allocations
- Understanding Multitiered Allocations
- Common Elements Used in This Chapter
- Processing Recurring Journal Entries
- Understanding Recurring Journal Entries
- Understanding the Recurring JE Compute & Print Program
- Prerequisite
- Forms Used to Process Recurring Journal Entries
- Creating Recurring Journal Entries
- Running the Recurring JE Compute & Print Program
- Setting Data Selection for Recurring JE Compute & Print
- Setting Processing Options for Recurring JE Compute & Print (R09302)
- Processing Indexed Allocations
- Understanding Indexed Allocations
- Understanding the Indexed Computations Compute & Print Program
- Prerequisites
- Forms Used to Create Indexed Allocations
- Creating Indexed Allocations
- Running the Indexed Computations Compute & Print Program
- Setting Data Selection and Sequence for Indexed Computations Compute & Print
- Setting Processing Options for Indexed Computations Compute & Print (R093021)
- Processing Advanced Variable Numerator Allocations
- Understanding Advanced Variable Numerator Allocations
- Understanding Account Balance-Based Allocations
- Understanding Burdening-Based Allocations
- Understanding Joint Venture-Based Allocations
- Prerequisites
- Calculating Advanced Variable Numerator Allocations
- Setting Data Selection for Compute Advanced Variable Numerator Allocations
- Setting Processing Options for Compute Advanced Variable Numerator Allocations (R09123)
16 Processing Burdening
17 Processing Reburdening
- Understanding the Reburdening Process
- Processing Reburdening
- Reviewing, Approving, and Deleting Reburdening Transaction Groups
- Updating the Billing Detail Workfile Table with Reburdening Transactions
18 Processing Actual Rate Calculation
- Understanding Actual Rate Calculation
- Prerequisite
- Calculating Actual Rates
- Reviewing Actual Rate Calculation Reference IDs
19 Reconciling Bank Account Transactions
- Understanding Bank Account Reconciliation
- Reconciling Voided Payments and Receipts
- Refreshing Account Reconciliation Information
- Reconciling Bank Account Transactions Manually
- Changing a Reconciled Transaction to Unreconciled
20 Reconciling Debit and Credit Amounts
- Understanding the Debit and Credit Reconciliation Process
- Prerequisites
- Reconciling Debit and Credit Transactions
21 Reconciling Bank Tapes
- Understanding the Bank Tape Reconciliation Process
- Reformatting the Bank Tape
- Refreshing Account Reconciliation Information
- Matching the Bank Tape to the Reconciliation Workfile
- Verifying the Bank Tape Reconciliation
22 Reconciling Clearing Accounts
- Understanding the Clearing Account Reconciliation Process (Release 9.2 Update)
- Prerequisites
- Automatically Reconciling Clearing Accounts (Release 9.2 Update)
23 Processing Bank Statements Manually
- Understanding Manual Bank Statement Processing
- Understanding Transaction Codes
- Understanding Transit Accounts
- Entering Bank Statement Transactions
- Refreshing Account Reconciliation Information
- Running the Bank Journal Statement Process Program
- Understanding the Bank Journal Statement Process Program
- Prerequisite
- Running the Bank Journal Statement Process Program
- Setting Data Sequence for Bank Journal Statement Process
- Setting Processing Options for Bank Journal Statement Process (R09170)
- Reviewing the Bank Statement Processing Reports
- Processing Batch Cash Receipt Transactions
24 Processing Bank Statements Automatically
- Understanding the Automatic Bank Statement Process
- Processing Flat Files from the Bank
- Revising Data in the Staging Tables
- Loading Data into the Bank Statement Tables
- Revising Data in the Bank Statement Tables
- Processing Automatic Bank Statements
- Reconciling Unreconciled Bank Statement Transactions
- Purging Bank Statement Tables
25 Creating Budgets
- Understanding Budgets
- Understanding Budget Patterns
- Creating Budget Pattern Codes
- Changing Budget Pattern Codes for a Group of Accounts
- Entering Annual Budgets
- Understanding Annual Budgets
- Understanding Budget Cycles
- Prerequisite
- Forms Used to Enter Annual Budget Amounts
- Setting Processing Options for Requested by Business Unit (P14102) and Requested by Account (P14103)
- Entering Annual Budget Amounts by Business Unit
- Entering Annual Budget Amounts by Account
- Spreading Annual Budget Amounts to Periods
- Generating Budget Worksheets
- Reviewing Budget Comparisons Online
- Managing Budget Overages
- Entering Detailed Budget Amounts
- Entering Journalized Budgets
26 Uploading Budget Data
- Understanding the Budget Upload Process
- Importing Budget Data from Spreadsheets
- Importing Budget Data from Text Files
- Revising Imported Budget Data
- Uploading Budget Data to the F0902 Table
- Purging Processed Records in the F0902Z1 Table
27 Forecasting and Planning Budgets
- Understanding Budget Forecasting and Planning
- Defining Accounts and Retrieving Basis Amounts
- Revising Accounts and Basis Amounts
- Generating Budget Forecast Amounts
- Revising Budget Forecast Amounts
- Updating Budget Forecast Records
- Purging Budget Forecast Records
28 Processing Cash Forecast Data
- Refreshing Cash Forecast Data
- Analyzing Cash Forecast Information
- Purging Forecast Data
29 Creating Cash Basis Entries
- Understanding Cash Basis Accounting
- Understanding Accrual Entries
- Understanding Cash Basis Entries
- Running the Cash Basis Program from the Menu
- Running the Cash Basis Program from the Post
- Reviewing Exception Reports
- Reviewing Cash Basis Entries
- Posting Cash Basis Entries
30 Using 52 Period Accounting
- Posting 52 Period Accounting Entries
- Closing a 52 Period Year
- Producing a 52 Period Income Statement
31 Understanding Account Consolidations
32 Processing Online Consolidations
- Understanding Organization Report Structures
- Prerequisites
- Creating Hierarchical Organization Report Structures
- Adding Organization Report Structures Without Using Category Codes
- Reviewing and Rearranging Organization Report Structures
- Creating Additional Business Units and Copying Report Structures
- Creating Online Consolidations
- Reviewing Online Consolidations
33 Processing High-Volume Consolidations
- Understanding High-Volume Consolidation Processing
- Deleting Prior High-Volume Consolidations
- Creating High-Volume Consolidations
- Understanding the Refresh Consolidation Program
- Understanding the Structure of Fictitious Business Units
- Understanding Records Created by the Refresh Consolidation Program
- Prerequisites
- Form Used to Review High-Volume Consolidations
- Running the Refresh Consolidation Program
- Setting Data Selection and Sequence for Refresh Consolidations
- Setting Processing Options for Refresh Consolidation (R10862)
- Reviewing High-Volume Consolidations
34 Processing Multisite Consolidations
- Understanding Source and Target Site Tasks
- Understanding Multiple Consolidation Tiers
- Understanding Multisite Consolidation Structures and Tables
- Running Control File Reports
- Creating Organizational Structures
- Creating Account Structures
- Revising and Printing Account Structures
- Defining Multisite Consolidation Rules
- Creating Consolidated Balances
- Running the Multisite Consolidations Reports
- Understanding Multisite Consolidation Integrity Reports
- Understanding the BU/Accounts Monthly Comparison Report
- Running the Prior Period Balance Integrity Report
- Setting Processing Options for Prior Period Balance Integrity (R10700)
- Running the UDC Value Control Exceptions Report
- Setting Processing Options for UDC Value Control Exceptions (R107011)
- Running the Object/Subsidiary Value Control Exceptions Report
- Setting Processing Options for Object/Subsidiary Value Control Exceptions Report (R107021)
- Running the BU/Accounts Monthly Comparison Report (R10701)
- Setting Data Selection and Sequence for BU/Accounts Monthly Comparison Report
- Setting Processing Options for BU/Accounts Monthly Comparison Report (R10701)
- Running the Consolidated Balance Sheet Report
- Setting Processing Options for Consolidated Balance Sheet (R10150)
- Running the Consolidated Income Statement Report
- Setting Processing Options for Consolidated Income Statement (R10250)
- Reviewing Consolidation Statuses
- Sending Consolidated Balances by Batch to the Target Company
- Sending Consolidated Balances Interactively to the Target Company
- Understanding the Process to Send Consolidated Balances to the Target Company
- Understanding the Consolidation Console Program
- Form Used to Send Consolidated Balances Interactively to the Target Company
- Setting Processing Options for Consolidation Console (P10610)
- Sending Consolidated Balances Interactively to the Target Company
- Processing Consolidated Balances from Non-EnterpriseOne Source Sites
- Revising Inbound Consolidations
- Purging Inbound Consolidations Data
- Generating Multisite Batch Journal Entries
- Processing and Purging Multisite Batch Journal Entries
35 Reviewing Balances and Transactions
- Understanding Online Inquiries
- Understanding Statutory Inquiries
- Understanding Trial Balance Inquiries
- Understanding Account Ledger and Balance Inquiries
- Reviewing Trial Balances, Ledgers, and Subledgers
- Reviewing Trial Balances
- Understanding Trial Balance Review
- Forms Used to Review Trial Balances
- Setting Processing Options for T/B by Object Account (P09214)
- Setting Processing Options for T/B by Company (P09216)
- Setting Processing Options for T/B by Subledger (P09215)
- Reviewing Balances by Object Account
- Reviewing Balances by Company
- Reviewing Balances by Subledger
- Reviewing Account Ledgers
- Understanding Account Ledger Inquiry
- Understanding Account Ledger by Object Account
- Understanding Account Ledger by Category Code
- Prerequisite
- Forms Used to Review Account Ledgers
- Setting Processing Options for Account Ledger Inquiry (P09200)
- Using Real-Time Summarization in the Account Ledger Inquiry Program (P09200)
- Reviewing Account Ledger Transactions
- Setting Processing Options for Account Inquiry by Object Account (P09201)
- Using Real-Time Summarization in the Account Inquiry by Object Account Program (P09201)
- Setting Processing Options for Account Inquiry by Category Code (P09202)
- Using Real-Time Summarization in the Account Inquiry by Category Code Program (P09202)
- Reviewing Ledgers by Category Code
- Reviewing Account Balances by Month
36 Generating Financial Reports
- Understanding Financial Reports
- Setting Up Data Selection and Data Sequence for the Simple Income Statement and Simple Balance Sheet
- Generating a Simple Income Statement
- Generating a Simple Balance Sheet
- Generating a Statement of Cash Flow
- Generating Consolidated Financial Reports
- Understanding Consolidated Financial Reports
- Prerequisite
- Printing a Consolidated Income- 7 Column Statement
- Setting Data Selection and Sequence for Consolidated Income-7 Column
- Setting Processing Options for Consolidated Income-7 Column (R103121A)
- Printing a Consolidated Balance Sheet
- Setting Data Selection and Sequence for Consolidated Balance Sheet
- Setting Processing Options for Consolidated Balance Sheet (R10311A)
- Generating Monthly Spreadsheets
- Generating Variance Analysis Reports
37 Verifying Data Integrity for General Accounting
- Understanding General Accounting Integrity Reports and Programs
- Running the Transactions to Batch Headers Report
- Working with the Transactions to Batch Headers Program
- Running the Batch to Detail Report
- Running the Unposted Batches Report
- Running the Batches Out of Balance Report
- Working with the Batches Out of Balance Program
- Running the Company by Batch Out of Balance Report
- Working with the Companies by Batch Out of Balance Program
- Running the Companies in Balance Report
- Working with the Companies Out of Balance Program
- Running the Intercompany Accounts in Balance Report
- Understanding the Intercompany Accounts in Balance Report
- Printing the Intercompany Accounts in Balance Report
- Setting Processing Options for Intercompany Accounts in Balance (R097011)
- Locating Out-of-Balance Intercompany Accounts
- Correcting Discrepancies on the Intercompany Accounts in Balance Report
- Running the Account Balance to Transactions Report
- Running the Accounts without Business Units Report
- Working with the Accounts to Business Units Program
- Running the Account Balance without Account Master Report
- Working with the Account Balance to Account Master Program
- Running the Transactions without Account Master Report
- Working with the Account Ledger to Account Master Program
- Running the Financial Integrities Work Table Purge
38 Maintaining Batch Headers
39 Reposting the Account Ledger and Recalculating a Fiscal Year
- Understanding the Repost Programs
- Prerequisites
- Reposting the Account Ledger
- Recalculating the Fiscal Year and Period
40 Reposting the Burdening Ledger and Recalculating a Fiscal Year
41 Revising an Organization
- Understanding Organization Revisions
- Understanding Account Structure Revisions
- Understanding Tables Affected by Account Structure Revisions
- Prerequisite
- Changing a Business Unit on Multiple Accounts
- Changing Accounts by Object
- Changing Accounts by Subsidiary
- Updating the F0911, F0902, F03B117 Tables
- Updating the Burdening Tables with Account Revisions
- Changing the Company Number on a Business Unit
- Changing Account Information
- Updating the Model/Consolidated Field
- Updating Category Codes for Business Units
42 Closing Accounting and Reporting Periods
- Understanding Period-End Close Tasks
- Closing the Accounting Period
- Understanding How to Close an Accounting Period
- Understanding the Effect of Closing an Accounting Period
- Forms Used to Close the Accounting and Reporting Period
- Closing an Accounting Period for a Company
- Closing the Accounting Period and Year for a Company
- Closing an Accounting Period for Multiple Companies
- Changing Financial Reporting Periods
43 Closing the Fiscal Year
- Understanding the Fiscal Year Close
- Understanding Setup Requirements and Common Tasks
- Closing a Fiscal Year
- Closing a Fiscal Year for Budgets
44 Summarizing Records and Purging Records
- Understanding Summarizations, Deletions and Purges
- Summarizing Account Ledger Records
- Purging Prior-Year Records
- Purging Prior-Year Account Balances
- Deleting Account Master Records
- Deleting Business Units and Companies
45 Appendix A - General Accounting Tables
46 Appendix B - Mapping Fields for Journal Entry Batch Processing
- Mapping Fields in the F0911Z1 Table
- Mapping Fields in the F0911Z1 Table for Burdening
- Mapping Fields in the F0911Z1 Table for Advanced Cost Accounting
- Mapping Fields in the F0911Z1 Table for Externally Reconciled Transactions
47 Appendix C - Field Mapping for Automatic Bank Statement Processing
- Field Mapping for Automatic Bank Statement Processing
- Mapping BAI2 Fields to the F09610 and F09611 Tables
- Mapping SWIFT Fields to the F09610 and F09611 Tables
48 Appendix D - Mapping Fields for Budget Data Import
49 Appendix E - Mapping Fields for Inbound Multisite Consolidations
50 Appendix F - Delivered Workflow for JD Edwards EnterpriseOne General Accounting
- Delivered Workflow for JD Edwards EnterpriseOne General Accounting
- Journal Entry Batch Approval
- Route Expense Report
51 Appendix G - JD Edwards EnterpriseOne General Accounting Reports
- Types of General Accounting Reports
- JD Edwards EnterpriseOne General Accounting Reports: A to Z
- JD Edwards EnterpriseOne General Accounting Reports: Selected Reports
- R00650 - Data by Business Unit
- Processing Options for Data by Business Unit (R00650)
- R09205P, R09206, R09207- Account Master Reports
- Processing Options for the Account Master Reports (R09205P, R09206, R09207)
- R09301 - Unposted General Journal, General Journal by Batch, Unposted Cash Basis
- Processing Options for Unposted General Journal and Unposted Cash Basis Report (R09301)
- R09311 - General Journal by Account
- Processing Options for General Journal by Account (R09311)
- R09321 - Transaction Journal
- Processing Options for Transaction Journal (R09321)
- R09410 - Trial Balance Report
- Processing Options for Trial Balance Report (R09410)
- R094121 - Trial Balance by Object Report
- Processing Options for Trial Balance By Object Report (R094121)
- R09421 - G/L by Object Account
- Processing Options for G/L by Object Account (R09421)
- R09422 - G/L with Subledger Totals
- Processing Options for G/L with Subledger Totals (R09422)
- R09423 - Transactions by Object
- Data Selection for the Transactions by Object
- Processing Options for Transactions by Object (R09423) and Transactions by Subsidiary (R09424)
- R09424 - Transactions by Subsidiary
- Data Selection for the Transactions by Subsidiary
- Processing Options Transactions by Subsidiary (R09424)
- R09451 - Account Totals by Supplier/Customer
- Processing Options for Account Totals by Supplier/Customer (R09451)
- R09470 - G/L by Category Code
- Processing Options for G/L by Category Code (R09470)
- R09472 - Debit/Credit T/B by Category Code
- Processing Options for Debit/Credit T/B by Category Code (R09472)
- R11C750 - Cash Basis Integrity Test
- Data Selection and Sequence for the Cash Basis Integrity Report
- Processing Options for the Cash Basis Integrity Test (R11C750)
- R11C760 - Cash Basis Audit Report
- Data Selection and Data Sequencing for the Cash Basis Audit Report
- Processing Options for Cash Basis Audit Report (R11C760)