Contents

• Title and Copyright Information
• Preface

1 Introduction to One View Financial Statements

• JD Edwards EnterpriseOne One View Financial Statements Overview
• JD Edwards EnterpriseOne One View Financial Statements Integrations
• One View Financial Statements Implementation
  • Global Implementation Steps

2 Understanding One View Financial Statements

• Overview of One View Financial Statements
• Building One View Financial Statements
• Data Selection Using Queries
• Data Extraction
• BI Publisher Layout Editor
• Export and Import Function
• Delivered Financial Statements
• Financial Statements Security
• Prerequisites

3 Understanding Security for One View Financial Statements

• Security Setup for One View Financial Statements
  • User Profiles and Roles for OVFS
  • Object-Level Security for OVFS
  • BI Publisher Security for OVFS
  • One View Reporting Security for OVFS
• Using OVFS Category Codes for Security

4 Understanding Data Selection for One View Financial Statements

• Data Selection for One View Financial Statements
  • Requirements for Data Selection
  • How the System Uses Data Selection
    • Commonality of Data
    • Avoiding Conflicts in Data Selection
  • Query Manager Tool for One View Financial Statements
    • Comparison Types
• Example of Data Selection Setup for a Balance Sheet Statement
• Example of a Statement of Operations

5 Setting Up Your System for One View Financial Statements

• Setting Up OVFS Constants
  • Understanding OVFS Constants
  • Form Used to Set Up OVFS Constants
  • Setting Up OVFS Constants
• Setting Up OVFS Category Codes

6 Creating Column Definitions

• Understanding Column Definitions
  • Column Definition Usage in Financial Statements
  • UDCs Used in Column Definitions
  • Process Flow to Create Column Definitions
• Creating Column Definitions
  • Understanding Column Definition Setup
    • Column Definition Names, Descriptions, and Titles
    • Ledger Types
    • Currency Codes
    • Financial Statement Category Codes
    • Copying Column Definitions (Release 9.2 Update)
  • Examples of Column Definitions
  • Prerequisites
  • Forms Used to Create Column Definitions
  • Creating a Column Definition
• Adding Data Selection to Column Definitions (Optional)
  • Understanding Data Selection for Column Definitions
  • Forms Used to Add Data Selection to Column Definitions
  • Adding Data Selection to a Column Definition
• Determining Where Column Definitions are Used
  • Form Used to Determine Where Columns are Used

7 Creating Row Definitions

• Understanding Row Definitions
  • Row Definition Usage in Financial Statements
  • Factors for Determining How to Set Up Row Definitions
  • UDCs Used by Row Definitions
  • Process Flow to Create Row Definitions
• Understanding the Data with Grouping Elements Row Definition Type
  • Grouping Elements
  • Grouping Elements that Return Additional Elements
  • Return Description for Grouping Elements
  • Including GLG AAI Item Numbers
  • Enabling Level Of Detail (LOD) Rollup
  • Reverse Sign
  • Example of Financial Statement Output with Balances Summarized by Grouping Elements
  • Example of Financial Statement Output with Data Row Definition Type with Account ID in a Grouping Element
• Understanding the Data without Grouping Elements Row Definition Type
  • Example of Financial Statement Output for Data Row Definition Type With No Grouping Elements
• Understanding the Subtotal Row Definition Type
  • Example of Financial Statement Output for a Subtotal Row Definition
• Understanding the Numeric Value Row Definition Type
  • Example of Financial Statement Output for a Numeric Value Row
• Understanding the Text Value Row Definition Type
  • Example of Financial Statement Output for Text Value Row Definitions
• Creating Row Definitions
  • Understanding Row Definition Setup
    • Row Definition Names, Descriptions, and Titles
    • Adding Financial Statement Category Codes to Row Definitions
    • Copying Row Definitions (Release 9.2 Update)
  • Prerequisites
  • Forms Used to Create Row Definitions
  • Creating a Data Row Definition
  • Creating a Subtotal-Type Row Definition
  • Creating a Text Value-Type Row Definition
  • Creating a Numeric Value-Type Row Definition
• Adding Data Selection to Row Definitions (Optional)
  • Understanding Data Selection for Row Definitions
  • Forms Used to Add Data Selection to a Row Definition
  • Adding Data Selection to a Row Definition
• Determining Where Row Definitions are Used
  • Understanding How to Determine Where a Row Definition is Used
  • Forms Used to Determine Where a Row Definition is Used

8 Creating Statement Definitions

• Understanding Statement Definitions
  • Process Flow for Creating Statement Definitions
• Understanding Consolidated Financial Statements
• Understanding Balance Sheet Statements with Net Income or Loss
• Creating a Statement Definition
  • Understanding Statement Definition Creation
    • Statement Definition Names and Descriptions
    • Validations for Sections in Statement Definitions
    • Reviewing Row and Column Definition Information
    • Using Subtotal Row Definitions
    • Adding Category Codes to Statement Definitions
    • Copying Statement Definitions (Release 9.2 Update)
    • Re-sequencing Statement Definition Records
  • Prerequisites
  • Forms Used to Create a Statement Definition
  • Creating a Statement Definition
• Previewing Report Definitions
  • Understanding Report Definition Previews
  • Previewing Elements in a Statement Definition

9 Creating Versions

• Understanding Layout Versions and Statement Versions
  • Version Names and Descriptions
  • Process to Create Versions
  • Prerequisites
• Creating Layout Versions
  • Understanding Layout Versions
    • Category Codes for Layout and Statement Versions
    • Copying Versions (Release 9.2 Update)
  • Forms Used to Create Layout Versions
  • Creating a Layout Version
• Creating Statement Versions
  • Understanding Statement Versions
    • Statement Version Names and Descriptions
  • Forms Used to Create Statement Versions
  • Creating a Statement Version
• Adding Data Selection to Layout and Statement Versions (Optional)
  • Understanding Data Selection for Versions
  • Form Used to Add Data Selection to a Version
  • Adding Data Selection to a Version

10 Creating Layouts in the BI Publisher Layout Editor

• Understanding BI Publisher Layout Editor for OVFS
  • OVFS Components in the Data Model
    • System
    • Reportvariables (Report Variables)
    • Statement Sections
    • Reportdefinitionforbip (Report Definition for BIP)
• Applying Formatting for Financial Statements
• Adding Columns for Calculated Amounts

11 Generating and Managing One View Financial Statements

• Understanding One View Financial Statement Validations
• Understanding Delivered One View Financial Statements
• Generating a Financial Statement
  • Understanding How to Generate a Financial Statement
  • Statement Statuses and Error Handling
  • Prerequisites
  • Forms Used to Generate Financial Statements
  • Generating a Financial Statement
• Viewing Generated Financial Statements
  • Understanding How to View Generated Financial Statements
  • Forms Used to View Generated Financial Statements
  • Viewing a Generated Financial Statement
• Purging OVFS Workfiles
  • Understanding the OVFS Purge Process
  • Running the OVFS Purge Process
  • Setting Processing Options for OVFS Purge Process (R09300P)
    • Select

12 Managing OVFS Components

• Managing OVFS Components
  • Modifying and Deleting OVFS Components
    • Component Security
    • OVFS Constants
    • Where Used
    • Validity of Modified Row and Column Definitions
    • Validity of the Layout
  • Modifying Data Selection for Row and Column Definitions
  • Deleting OVFS Components
  • Working with E1 Pages
  • Working with One View Watchlists
• Generating the Statement Validation Report (Release 9.2 Update)
  • Understanding the Statement Validation Report
  • Running the Statement Validation Report

13 Using Export and Import Functionality in OVFS

• Understanding Export and Import Functionality
• Exporting OVFS Records
  • Understanding the OVFS Export Function
    • Contents of the Export Zip File for Row and Column Definitions
    • Contents of Export File for Statement Definitions
  • Forms Used to Create OVFS Export Files
  • Creating OVFS Export Files
• Importing OVFS Records (Release 9.2 Update)
  • Understanding the OVFS Import Function
  • Forms Used to Import OVFS Component Files
  • Importing OVFS Component Files

14 Appendix A - OVFS Balance Sheet Statement Case Study

• Understanding How to Use Delivered Content with the Balance Sheet Case Study
• Understanding the Balance Sheet Case Study
• Planning Your Balance Sheet Statement
  • What Row Definitions Do I Need to Set Up?
  • Which Accounts Balances Will Columns Include?
  • Which Elements Do I Need to Specify in the Statement Definition and Versions?
  • What Elements Do I Set Up in the BI Publisher Layout Editor?
• Balance Sheet Case Study: Set Up Column Definitions
  • Balance Sheet Case Study Task: Set Up Column Definitions
• Balance Sheet Case Study: Set Up the Row Definition
  • Balance Sheet Case Study Task: Create Data Row Definitions
• Balance Sheet Case Study: Set Up the Statement Definition
  • Balance Sheet Case Study Task: Set Up the Statement Definition
• Balance Sheet Case Study: Create a Layout Version and Extract the Data Sample
  • Balance Sheet Case Study Task: Create a Layout Version and Extract the Data Sample
• Balance Sheet Case Study: Set Up the Statement Layout in the BI Publisher Layout Editor
  • Balance Sheet Case Study Task: Accessing an Existing Layout
  • Balance Sheet Case Study Task: Add OVFS Components and Elements to the Layout
  • Balance Sheet Case Study Task: Replace Default Text and Format the Statement Header
  • Balance Sheet Case Study Task: Remove the Layout Editor Totals from the Grid
  • Balance Sheet Case Study Task: Sequence Accounts
  • Balance Sheet Case Study Task: Hide a Column in the Layout
  • Balance Sheet Case Study Task: Format the Account Descriptions Text
  • Balance Sheet Case Study Task: Format Account Balances Columns
• Balance Sheet Case Study: Add Calculated Columns to the Layout
  • Balance Sheet Case Study Task: Change the Width of Columns
  • Balance Sheet Case Study Task: Add Calculated Columns to the Layout
  • Balance Sheet Case Study Task: Format the Calculation Columns
• Balance Sheet Case Study: Reverse the Sign of Account Balances by Using a Calculation
  • Balance Sheet Case Study Task: Copy the Layout Table to Create a Second Table
  • Balance Sheet Case Study Task: Filter the Table Results
  • Balance Sheet Case Study Task: Reverse the Sign of OVFS Account Balances Columns
  • Balance Sheet Case Study Task: Reverse the Sign of Calculated Columns Using a Nested Formula
• Balance Sheet Case Study: Preview and Modify Your Balance Sheet Statement
  • Balance Sheet Case Study Task: Preview the Report
  • Balance Sheet Case Study Task: Create Column Titles in the Statement Header
  • Balance Sheet Case Study Task: Hide the Column Titles in the Layout Tables
• Balance Sheet Case Study: Generate and Review the Balance Sheet Statement
  • Balance Sheet Case Study Task: Set Up Statement Version for the Final Statement
  • Balance Sheet Case Study Task: Generate and Review the Balance Sheet Statement

15 Appendix B - OVFS Consolidated Income Statement Case Study (Release 9.2 Update)

• Understanding How to Use Delivered Content with the Consolidated Income Statement Case Study
• Understanding the Consolidated Income Statement Case Study
• Planning Your Consolidated Income Statement
  • What Columns Definitions Will I Need to Set Up?
  • What Rows Definitions Do I Need to Set Up?
  • Which Elements Do I Need to Specify in the Statement Definition and Versions?
  • What Elements Do I Set Up in the BI Publisher Layout Editor?
• Consolidated Income Statement Case Study: Set Up Column Definitions
  • Consolidated Income Statement Case Study Task: Set Up the Column Definitions
• Consolidated Income Statement Case Study: Set Up Row Definitions
  • Consolidated Income Statement Case Study Task: Create Row Definitions and Add Data Selection
• Consolidated Income Statement Case Study: Set Up the Statement Definition
  • Consolidated Income Statement Case Study Task: Create the Statement Definition
• Consolidated Income Statement Case Study: Create a Layout Version and Extract the Data Sample
  • Consolidated Income Statement Case Study Task: Create a Layout Version and Extract the Data Sample
• Consolidated Income Statement Case Study: Set Up Layout Sections
  • Consolidated Income Statement Case Study Task: Accessing an Existing Layout (Optional)
  • Consolidated Income Statement Case Study Task: Review the Data Model
  • Consolidated Income Statement Case Study Task: Add OVFS Components and Elements
  • Consolidated Income Statement Case Study Task: Remove BI Publisher Layout Editor Totals from the Grid
  • Consolidated Income Statement Case Study Task: Change the Width of Columns
  • Consolidated Income Statement Case Study Task: Sequence Accounts
  • Consolidated Income Statement Case Study Task: Remove Grid Lines
  • Consolidated Income Statement Case Study Task: Hide a Column in the Layout
  • Consolidated Income Statement Case Study Task: Add the Percent of Revenue Columns
  • Consolidated Income Statement Case Study Task: Add the Percent of Change Calculated Column
• Consolidated Income Statement Case Study: Format the Columns in the Layout Tables
  • Consolidated Income Statement Case Study Task: Format the Object Account Descriptions Text
  • Consolidated Income Statement Case Study Task: Format Account Balances Columns
    • Consolidated Income Statement Task: Hide Zero Balances
    • Consolidated Income Statement Case Study Task: Apply Column Masks
    • Consolidated Income Statement Case Study Task: Format Numeric Columns
• Consolidated Income Statement Case Study: Modify Layout and Column Headers
  • Consolidated Income Statement Case Study Task: Add, Delete, and Format Headers Elements
  • Consolidated Income Statement Case Study Task: Remove Column Headings from the Layout Table
• Consolidated Income Statement Case Study: Add Additional Sections to the Layout
  • Consolidated Income Statement: List of Tasks for Non-Subtotal Sections
  • Consolidated Income Statement: List of Tasks for Subtotal Sections
  • Consolidated Income Statement Case Study Task: Add a New Section in the Layout
  • Consolidated Income Statement Case Study Task: Add the Percent of Revenue Columns in Subtotal Sections
  • Consolidated Income Statement Case Study Task: Add the Percent Change Column for Subtotal Sections
• Consolidated Income Statement Case Study: Preview the Statement
  • Consolidated Income Statement Case Study Task: Preview the Statement
• Consolidated Income Statement Case Study: Generate the Statement
  • Consolidated Income Statement Case Study: Set Up Statement Version for the Final Statement
  • Consolidated Income Statement Case Study Task: Generate and Review the Consolidated Income Statement

16 Balance Sheet by Business Unit Statement Definition

• Column Definitions for the Balance Sheet by Business Unit Statement Definition
• Row Definition for the Balance Sheet by Business Unit Statement Definition
• Statement Versions for the Balance Sheet by Business Unit Statement Definition

17 Consolidated Balance Sheet Statement Definition

• Column Definitions for the Consolidated Balance Sheet Statement Definition
• Row Definition for the Consolidated Balance Sheet Statement Definition
• Statement Versions for the Consolidated Balance Sheet Statement Definition

18 Income Statement by Business Unit Statement Definition (Release 9.2 Update)

• Columns for Income Statement by Business Unit
• Row Definition for Income Statement by Business Unit Statement Definition
• Sections for the Income Statement by Business Unit Statement Definition
• Statement Versions for the Income Statement by Business Unit Statement Definition

19 Consolidated Income Statement Statement Definition (Release 9.2 Update)

• Column Definitions for the Consolidated Income Statement Statement Definition
• Row Definitions for the Consolidated Income Statement Statement Definition
• Sections for the Consolidated Income Statement Statement Definition
• Statement Versions for the Consolidated Income Statement Statement Definition