Contents

• Title and Copyright Information
• Preface

1 Introduction to JD Edwards EnterpriseOne Financial Management Fundamentals

• JD Edwards EnterpriseOne Financial Management Fundamentals Overview
• JD Edwards EnterpriseOne Financial Management Fundamentals Implementation
  • Global Implementation Steps
  • Implementation Steps

2 Setting Up Batch Approval and Post Security

• Setting Up Management Approval by System
  • Forms Used to Set Up Management Approval by System
  • Setting Up Manager Approval of Batches
• Setting Up Batch Security by System
  • Form Used to Set Up Batch Security by System
  • Setting Up Batch Security
• Setting Up Approved and Secured Users
  • Understanding Approved and Secured Users
  • Forms Used to Set Up Approved and Secured Users
  • Setting Up Approved Users
  • Setting Up Secured Users
• Setting Up Workflow for Batch Approval and Post
  • Understanding Workflow Setup

3 Setting Up Organizations

• Understanding Organization Setup
• Setting Up Fiscal Date Patterns
  • Understanding Fiscal Date Pattern Setup
  • Forms Used to Set Up Fiscal Date Patterns
  • Setting Up a Fiscal Date Pattern
• Setting Up Companies
  • Understanding Company Setup
  • Form Used to Set Up Companies
  • Setting Up a Company
• Setting Up Business Units
  • Understanding Business Unit Setup
    • Business Unit Category Codes
    • Business Unit Translation
  • Understanding Business Units and Data Relationships
  • Forms Used to Set Up Business Units
  • Setting Processing Options for Business Unit Master (P0006)
    • Required Fields
  • Setting Up Business Units
    • Revise Single BU
    • More Detail
    • Cat Codes
    • Additional Address Numbers
  • Revising Business Units
  • Translating Business Units
• Setting Up Organizational Structures
  • Understanding Organizational Structures
    • Example: Organizational Structure
    • Date-Effective Organizational Structures
  • Prerequisites
  • Forms Used to Set Up Organizational Structures
  • Defining Organizational Structures
  • Setting Processing Options for Business Unit Structure Tree View (P0006A)
    • Business Unit
    • BU Structure
  • Reviewing Organizational Structures
  • Rearranging Organizational Structure Components
  • Revising Business Units Within an Organizational Structure
  • Building a Date-Effective Organizational Structure
  • Setting Processing Options for Build Date-Effective Bus. Unit Master (R0006S)
    • Process
  • Revising a Date-Effective Organizational Structure

4 Importing and Exporting Business Unit and Company Records

• Business Unit and Company Import and Export Overview
  • Business Unit Import and Export Interface Components
  • Company Import and Export Interface Components
• Using the Business Unit Import and Export Interface Components
  • Forms Used to Access Business Unit Import and Export Interface Components
  • Adding Business Unit Records Using the Business Unit Interface
  • Entering Translation Information for Business Units Using the Business Unit Interface
  • Setting Processing Options for the Business Unit Batch Inbound Program (R0006ZI)
    • Versions Tab
  • Running the Business Unit Batch Inbound Program (R0006ZI)
  • Running the Business Unit Inbound Purge Program (R0006ZP)
• Using the Company Import and Export Interface Components
  • Forms Used to Access Company Import and Export Interface Components
  • Adding Company Records Using the Company Interface
  • Running the Company Batch Inbound Program (R0010ZI)
  • Running the Company Inbound Purge Program (R0010ZP)
  • Running the Company Batch Outbound Program (R0010ZO)

5 Setting Up Next Numbers

• Understanding Next Numbers
• Setting Up Next Numbers by System
  • Forms Used to Set Up Next Numbers by System
  • Setting Up System Next Numbers
• Setting Up Next Numbers by Company and Fiscal Year
  • Prerequisite
  • Forms Used to Set Up Next Numbers by Company and Fiscal Year
  • Selecting a Method for Next Numbers by Company and Year
  • Setting Up Next Numbers by Company and Year
  • Adding a Fiscal Year to an Existing Record
  • Removing a Fiscal Year from an Existing Record

6 Understanding the Chart of Accounts

• Business Unit.Object.Subsidiary Format
  • Business Unit - The Where
  • Object.Subsidiary - The What
• Chart of Accounts
• Category Codes 21–43
  • Example: Category Code 21
• Level of Detail
• Posting Edit Codes
• Differences Between Subledger and Subsidiary Accounting
  • Example: Subledger Accounting
  • Example: Subsidiary Accounting

7 Creating the Chart of Accounts

• Setting Up Accounts
  • Understanding Chart of Accounts Revisions
  • Forms Used to Set Up Accounts
  • Defining Account Segments
    • B, O, and S Fields
  • Setting Processing Options for Review and Revise Accounts (P0901)
    • Security
  • Setting Up an Account
    • 2-More Detail
• Revising Accounts
  • Understanding Account Revisions
    • Account Revision
    • Account Inactivation
    • Account Deletion
  • Forms Used to Revise Accounts
  • Revising Accounts by Business Unit
  • Revising Accounts by Object
  • Updating Your Chart of Accounts
  • Building the Account - Word Search Table
  • Setting Processing Options for Build Account Master Word Search Table (R0901WS)
    • Mode
  • Searching for Accounts
  • Reviewing Your Chart of Accounts
• Assigning Subledger Posting Edit Codes to Accounts
  • Understanding Subledgers
    • Posting Edit Codes
    • Additional Subledger Types
    • Inactivating Subledgers
  • Forms Used to Assign Posting Edit Codes to Subledgers
  • Assigning a Subledger Posting Edit Code to an Account
    • Multiple Accounts
  • Inactivating an Address Book Record from Use as a Subledger
• Creating a Model Chart of Accounts
  • Understanding a Model Chart of Accounts
    • Example: Model Business Unit
  • Prerequisite
  • Form Used to Create a Model Chart of Accounts
  • Creating a Chart of Accounts Based on a Model
• Copying Accounts to Business Units
  • Understanding Copying Accounts to Business Units
  • Prerequisite
  • Form Used to Copy Accounts to Business Units
  • Copying Accounts to Business Units
• Defining an Alternate Chart of Accounts for Statutory Reporting
  • Understanding Alternate Charts of Accounts
  • Forms Used to Define an Alternate Chart of Accounts for Statutory Reporting
  • Defining Alternate Accounts
  • Reviewing Alternate Account Information
• Assigning Third GL Account Numbers
  • Understanding Third GL Account Numbers
  • Form Used to Assign Third GL Account Numbers
  • Assigning a Third GL Account Number
• Translating Accounts
  • Understanding Account Translation
  • Prerequisite
  • Form Used to Translate Accounts
  • Translating Account Descriptions
• Reviewing and Revising the Structure of Your Organization
  • Understanding Organization Structure Revisions
  • Prerequisite
  • Form Used to Review and Revise the Structure of Your Organization
  • Revising the Structure of Your Organization

8 Setting Up Bank Accounts

• Understanding Bank Account Setup
• Understanding How to Set Up Bank Account Records as SEPA Accounts
• Setting Up GL Bank Accounts
  • Forms Used to Set Up GL Bank Accounts
  • Setting Up GL Bank Account Information
    • Set Up G/L Bank Account Form
    • Revise Bank Information Form
    • Revise BACS Information Form
    • Set Up Bank Account X12 Information Form
  • Setting Processing Options for Bank Account Information program (P0030G) (Release 9.2 Update)
    • Workflow
• Setting Up Customer Bank Accounts
  • (BEL and FRA) Prerequisites
  • Forms Used to Set Up Customer Bank Information
  • Setting Up Customer Bank Account Information
  • Setting Processing Options for Bank Account by Address (P0030A) (Release 9.2 Update)
    • Process
    • Workflow
• Setting Up Supplier Bank Accounts
  • Understanding Supplier Bank Accounts
  • (BEL and FRA) Prerequisites
  • Forms Used to Set Up Bank Information for Suppliers
  • Setting Up Supplier Bank Account Information
  • (CAN, DEU, FIN, GBR, NOR, SWE, and USA) Setting Up Country-Specific Supplier Bank Account Information
    • (FIN, NOR, and SWE) Field-Specific Information
    • (CAN, DEU, GBR, and USA) Field-Specific Information
• Setting Up Bank Account Cross-References
  • Understanding Bank Account Cross-References
  • Forms Used to Set Up a Bank Account Cross-Reference
  • Setting Up a Bank Account Cross-Reference
• Setting Up SEPA and US Bank Accounts Using Personal Forms (Release 9.2 Update)
• Setting Up Workflow for Bank Account Details Approval (Release 9.2 Update)
  • Prerequisites
  • Understanding Workflow Setup
• Printing Bank Account Exception Reports
  • Understanding the Bank Account Exception Report (R00310)
  • Understanding the Address Book Exception Report (R00311A)
  • Printing the Bank Account Exception Report
  • Printing the Address Book Exception Report

9 Setting Up Automatic Accounting Instructions

• Understanding AAIs
  • AAI Prefixes and Suffixes
  • Default AAIs
  • Example: AAI Item PC
  • Account Ranges
  • Translated AAIs
• Prerequisite
• Setting Up AAIs
  • Understanding AAI Setup
  • Forms Used to Set Up AAIs
  • Setting Up a Single AAI Item
  • Setting Up an AAI Item for Multiple Companies
  • Translating AAI Descriptions
  • Setting Processing Options for Automatic Accounting Instructions (P0012)
    • Sequence No.

10 Understanding Data Relationships

• Data Relationships
  • Example: Data Relationships
    • Setup: Data Relationship Between City and State
    • Setup: Data Relationship Between State and Region
    • Setup: Data Relationship Between Region and Country
    • End Result: Data Entry Program
• Data Relationships Terminology
• Data Relationships Setup
• UDCs for Data Relationships

11 Setting Up Data Relationships

• Understanding Data Relationships Rules
• Activating Data Relationships Functionality
  • Forms Used to Activate Data Relationships Functionality
  • Activating Data Relationships Functionality for a Table
• Reviewing Supported Data Relationships Columns
  • Understanding Supported Data Relationship Columns
    • F0006 Table
    • F5201 Table
  • Forms Used to Review Supported Data Relationships Columns
  • Reviewing Supported Data Relationships Columns for a Table
• Defining Column Relationships
  • Understanding Column Relationships
    • Column Relationships Rules
  • Understanding the Enforce Rule and Blanks Allowed Check Boxes
  • Understanding Destination Columns That Are Check Boxes
  • Prerequisite
  • Forms Used to Define Column Relationships
  • Defining Column Relationships for a Column Set
  • Revising a Column Set
  • Deleting a Column Set
• Defining Value Relationships
  • Understanding Value Relationships
  • Prerequisite
  • Forms Used to Define Value Relationships
  • Defining Value Relationships for a Column Set
    • Column Set
    • Value Set — Date Selection
    • Value Set — Defaults
    • Detail Area

12 Updating F0006 and F5201 Records with Data Relationships Rules

• Understanding Data Relationships Rules and Updating F0006 and F5201 Records
  • Update Data Relationships Program
• Automatically Updating F0006 and F5201 Records with Data Relationships Rules
  • Understanding Data Selection for the Update Data Relationships Program
  • Setting Data Selection for Update Data Relationships (R00422)
  • Setting Processing Options for Update Data Relationships (R00422)
    • Select
    • Process
  • Running the Update Data Relationships Program
• Manually Updating F0006 and F5201 Records with Data Relationships Rules
  • Understanding Data Relationships Rules and Manually Updates to F0006 and F5201 Records
  • Manually Updating F0006 Records with Data Relationships Rules

13 Understanding Intercompany Settlements

• Intercompany Settlements
• Hub Method
  • Examples for the Hub Method
    • Example: Journal Entry Between Two Companies
    • Example: Journal Entry Among Three Companies
    • Example: Two Journal Entries in One Batch
• Detail Method
  • Examples for the Detail Method
    • Example: Journal Entry Between Two Companies
    • Example: Journal Entry Among Three Companies
    • Example: Two Journal Entries in One Batch
• Configured Hub Method
  • Examples for the Configured Hub Method
    • Example: Configured Hub with Hub Company
    • Example: Configured Hub without Hub Company

14 Setting Up Intercompany Settlements

• Understanding Intercompany Settlement Setup
  • Intercompany Settlement Constant
  • Intercompany Settlement Accounts
    • Example: Intercompany Accounts
  • Intercompany Settlement AAIs
    • AAIs for the Hub Method
    • Example: AAIs for the Hub Method
    • AAIs for the Detail and Configured Hub Methods
    • Example: AAIs for the Detail and Configured Hub Methods
• Understanding Error Messages Caused By Incorrect Intercompany Setup
  • Error Message: Subledger X (Where X Equals the Company Number) Invalid
  • Error Message: Intercompany Settlement AAI Error
  • Error Message: Interco Settlement Acct Error
  • Error Message: Incompatible Posting Methods
• Prerequisite
• Setting Up Companies for Intercompany Settlements
• Setting Up Configured Hub Relationships
  • Understanding Configured Hub Setup
    • Guidelines for Configured Hubs
    • Configured Hub Verification
  • Forms Used to Set Up Configured Hubs
  • Adding Companies to Configured Hubs
  • Verifying Configured Hubs

15 Understanding Payment Terms

• Payment Terms
  • Commonly Used Payment Terms
  • Types of Payment Terms
• Standard Payment Terms
  • Standard Payment Term Codes
    • Due Upon Receipt Payment Terms
    • Fixed Payment Terms
    • Net Payment Terms
    • Proximate Date Payment Terms
    • Split Payment Terms
• Advanced Payment Terms
  • Work Day Calendars and Rules
  • Due Date Rules
    • Due Date Rule Components
    • Date Ranges
  • Advanced Payment Term Codes
    • Installment Payment Terms
    • Multitiered Discount Payment Terms
• Examples: Advanced Payment Terms and Due Date Rules
  • Example: Invoice Date
  • Example: GL Date
  • Example: Prior to Invoice Date

16 Setting Up Payment Terms

• Understanding Tax Considerations for Payment Terms with Discounts
• Setting Up Standard Payment Terms
  • Forms Used to Set Up Standard Payment Terms
  • Setting Up Standard Payment Terms
  • Entering Translations for Payment Terms (Release 9.2 Update)
• Setting Up Advanced Payment Terms
  • Forms Used to Set Up Advanced Payment Terms (Release 9.2 Update)
  • Adding a Work Day Calendar
    • Payroll and Time Entry Fields
  • Setting Up Due Date Rules
  • Setting Up Date Ranges for Due Date Rules
  • Setting Up Multitiered Discounts for Due Date Rules
  • Verifying Due Date Rules
  • Setting Up Advanced Payment Term Codes
  • Setting Up Installments for Payment Term Codes
• Updating Amounts and Dates for Invoices and Vouchers with Multitiered Discounts
  • Understanding Amounts and Dates for Invoices and Vouchers with Multitiered Discounts
    • Suppress the Update on Specific Transactions
  • Example: Updating Amounts and Dates for Invoices with Multitiered Discounts
    • Payment Term Setup
    • Enter Invoice and Run the Update A/R Invoices Program
  • Running the Update A/R Invoices or Update A/P Vouchers Program
  • Setting Data Selection for Update A/R Invoices or Update A/P Vouchers
  • Setting Processing Options for Update A/R Invoices (R005142) or Update A/P Vouchers (R005141)
    • Display
    • Defaults

17 Setting Up Pay When Paid Processing

• Understanding Pay When Paid Processing
• Understanding Pay When Paid Setup
  • Voucher Payment Status Code Setup
  • Next Numbers Setup
  • Customer Master Setup
  • Accounts Payable Constants Setup
  • Subcontractor Threshold Setup
• Setting Pay When Paid Processing Options
  • Understanding Pay When Paid Processing Options
  • Setting Pay When Paid Processing Options for Voucher Entry MBF (P0400047)
    • Defaults
  • Setting Pay When Paid Processing Options for Standard Voucher Entry (P0411)
    • Versions
    • Pay When Paid
  • Setting Pay When Paid Processing Options for Voucher Match (P4314)
    • Process

18 Processing Pay When Paid Transactions

• Understanding the Pay When Paid Process
  • Accounts Payable
  • Procurement and Subcontract Management
• Understanding Features of Pay When Paid Processing
• Understanding How to Link Invoices to Pay When Paid Vouchers
• Entering Pay When Paid Vouchers
  • Forms Used to Enter Pay When Paid Vouchers
  • Entering Pay When Paid Vouchers
• Creating and Revising Pay When Paid Groups
  • Understanding the Pay When Paid Manual Link Program
  • Forms Used to Create and Revise Pay When Paid Groups
  • Setting Processing Options for Pay When Paid Manual Link (P03B470)
    • Defaults
  • Creating a Pay When Paid Group Manually
  • Revising an Existing Pay When Paid Group
• Releasing Pay When Paid Vouchers for Payment
  • Understanding Pay When Paid Group Statuses
  • Understanding Voucher Release
  • Running the Pay When Paid Automatic Release Program
  • Setting Processing Options for Pay When Paid Automatic Release (R03B470)
    • Process
• Verifying Pay When Paid Integrity
  • Understanding Pay When Paid Integrity Reports
    • Pay When Paid Group Header Integrity
    • Pay When Paid Customer Ledger Integrity
    • Pay When Paid Supplier Ledger Integrity
  • Running Pay When Paid Integrity Reports
  • Setting Processing Options for Pay When Paid Supplier Ledger Integrity (R03B473)
    • Process

19 Understanding Supplemental Data

• Supplemental Data
• Supplemental Data Type Formats
• Example: Supplemental Data for a Construction Company
  • Data Types
    • Data Types with a Narrative Format
    • Data Types with a Code Format

20 Setting Up Supplemental Data

• Understanding Supplemental Data Setup
• Setting Up Supplemental Database Codes
  • Forms Used to Set Up Database Codes
  • Setting Up UDCs for Supplemental Database Codes
  • Setting Up a Supplemental Database Code
• Setting Up Supplemental Data Types
  • Understanding Supplemental Data Type Setup
  • Forms Used to Set Up Supplemental Data Types
  • Setting Up a Supplemental Data Type with a Code or Narrative Format
    • Header Fields
    • UDC and Remark Headings/Validation Fields
    • Column Headings
  • Setting Up a Supplemental Data Type Code with a Program Format
• Setting Up Language Overrides
  • Form Used to Set Up Language Overrides
  • Setting Up a Language Override

21 Entering Supplemental Data

• Entering Supplemental Data
  • Understanding Supplemental Data Entry
  • Forms Used to Enter Supplemental Data
  • Entering Supplemental Data
  • Entering Supplemental Data in the Code Format
  • Setting Processing Options for Supplemental Data (P00092)
    • Processing
• Copying Supplemental Data Types
  • Understanding Supplemental Data Type Copying
  • Form Used to Copy Supplemental Data Types
  • Copying Supplemental Data Type Information
• Reviewing Supplemental Data
  • Forms Used to Review Supplemental Data
  • Setting Processing Options for Inquiry by Business Unit (P00620)
    • SDB Code
  • Reviewing Supplemental Data
• Printing Supplemental Data Reports
  • Understanding Supplemental Data Reports for Business Units
    • Report Headings and Column Titles
  • Setting Processing Options for Data by Data Type (R00640) and Data by Business Unit (R00650)
    • Generic Text
    • SDB Code
  • Running Supplemental Data Reports for Business Units

22 Using Batch Control to Manage the Entry Process

• Understanding Batch Control
• Entering Batch Control Information
  • Understanding Batch Control Entry
  • Prerequisite
  • Form Used to Enter Batch Control Information
  • Entering Batch Information
• Reviewing Batch Control Information
  • Understanding Batch Control Review
  • Reviewing Control Information for a Batch

23 Understanding GL Date Warnings and Errors

• GL Date Warnings and Errors
  • Warning and Error Messages

24 Understanding Rounding Versus Soft Rounding

• Rounding and Soft Rounding Comparison
  • Rounding
  • Soft Rounding

25 Posting Financial Transactions

• Understanding the Financial Post Process
  • 1. Selects Data to Post
  • 2. Validates Information and Performs Error Processing
  • 3. Creates Automatic Entries
  • 4. Updates the Taxes Table
  • 5. Updates Posted Codes and Posts to F0902 table
  • 6. Updates the Batch Status
  • 7. Initiates Programs Defined in Processing Options
• Understanding Tax Amounts
• Prerequisites
• Posting Financial Batches
  • Understanding Methods for Posting Financial Batches
  • Setting Up UDC for Post Version by Batch Type (09/PV)
  • Understanding General Ledger Post Versions
    • General Accounting System
    • Accounts Payable System
    • Accounts Receivable System
  • Posting Financial Batches
  • Setting Processing Options for General Ledger Post (R09801)
    • Print
    • Versions
    • Edits
    • Taxes
    • Process
    • Cash Basis
• Verifying the Results of the Post
  • Reviewing Workflow Messages
  • Reviewing the Post Detail Error Report
  • Reviewing the General Ledger Post Report

26 Working with Batches

• Understanding the Batch Review Program
  • Batch Review and Approval
  • Mobile Applications to Review and Approve Batches
• Working with Batches of Transactions
  • Forms Used to Work with Batches of Transactions
  • Setting Processing Options for Batches (P0011)
    • Batch Type
    • Versions
  • Setting Processing Options for Voucher Batch Review Program (P0411B)
    • Versions for Select Mode
    • Versions for Add Mode
  • Setting Processing Options for General Journal Review Program (P0911B)
    • Versions
  • Setting Processing Options for Invoice Journal Review Program (P03B11A)
    • Versions
    • Process
  • Setting Processing Options for Payment Batch Review Program (P0413C)
    • Versions
  • Setting Processing Options for Draft Journal Review Program (P03B613)
    • Draft
    • Versions for Select Mode
    • Versions for Add mode
  • Setting Processing Options for Receipts Journal Review Program (P03B212)
    • Default
    • Versions
  • Reviewing a Batch
    • Difference Columns
  • Reviewing Transaction Detail
  • Revising Transactions in an Existing Batch
    • Adding Transactions to an Existing Batch
  • Approving Batches
• Understanding the G/L Batch Status History (Release 9.2 Update)
  • Activating the G/L Batch Status History
    • Forms Used to Activate the G/L Batch Status History Functionality
    • Activating the G/L Batch Status History Functionality
  • Understanding the G/L Batch Status History Inquiry (P00119)
    • Running the G/L Batch Status History Inquiry (P00119)

27 Working with the Text File Processor

• Understanding the Text File Processor
• Copying, Importing, and Resetting Text Files
  • Understanding the Copy Text Function
  • Understanding the Import Process
  • Prerequisite
  • Forms Used to Copy, Import, and Reset Text Files
  • Setting Processing Options for Text File Processor (P007101)
    • Process
  • Copying Text
  • Importing Text
  • Resetting a Text Batch in the Text File Processor
• Purging a Text Batch in the Text File Processor
  • Understanding the Purge Process
  • Form Used to Purge a Text Batch
  • Setting Processing Options for Purge Processed Transactions (R007102)
    • Process
  • Purging a Text Batch

28 Appendix A - JD Edwards EnterpriseOne Financial Management Fundamentals Reports

• JD Edwards EnterpriseOne Financial Management Reports: A to Z

29 Appendix B - Delivered Workflow for JD Edwards EnterpriseOne Financial Management

• Delivered Workflow for JD Edwards EnterpriseOne Financial Management
  • Bank Account Details Approval
    • Description
    • Workflow Objects

30 Glossary

• Account Number
• Discount Available
• Due Date
• G/L Offset (general ledger offset)
• Gross Amount
• Ledger Type and LT
• Level of Detail
• Open Amount
• Pay Item and Pay Itm
• Payment Terms, Pymt Terms, and Default Payment Terms
• Pay Status, Pay Stat, and PS (payment status)
• Posted Code and PC (posted code)
• Posting Edit Code
• Service/Tax Date
• Subledger and Sub-ledger
• Subledger Type and Sub Type
• Subsidiary and Sub
• Tax Ex, Tax Expl, and Tx Ex (tax explanation)
• Tax Amount
• Taxable Amount
• Tax Area and Tax Rate/Area