Contents
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
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
4 Understanding Data Selection for One View Financial Statements
- Data Selection for One View Financial Statements
- 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
6 Creating Column Definitions
- Understanding Column Definitions
- Creating Column Definitions
- Adding Data Selection to Column Definitions (Optional)
- Determining Where Column Definitions are Used
7 Creating Row Definitions
- Understanding 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
- Understanding the Subtotal Row Definition Type
- Understanding the Numeric Value Row Definition Type
- Understanding the Text Value Row Definition Type
- Creating Row Definitions
- Adding Data Selection to Row Definitions (Optional)
- Determining Where Row Definitions are Used
8 Creating Statement Definitions
- Understanding 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
- Understanding Statement Definition Creation
- Previewing Report Definitions
9 Creating Versions
- Understanding Layout Versions and Statement Versions
- Creating Layout Versions
- Creating Statement Versions
- Adding Data Selection to Layout and Statement Versions (Optional)
10 Creating Layouts in the BI Publisher Layout Editor
- Understanding BI Publisher Layout Editor for OVFS
- 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
- Viewing Generated Financial Statements
- Purging OVFS Workfiles
12 Managing OVFS Components
13 Using Export and Import Functionality in OVFS
- Understanding Export and Import Functionality
- Exporting OVFS Records
- Importing OVFS Records (Release 9.2 Update)
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
- Balance Sheet Case Study: Set Up Column Definitions
- Balance Sheet Case Study: Set Up the Row Definition
- Balance Sheet Case Study: Set Up the Statement Definition
- Balance Sheet Case Study: 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: 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: 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
- Consolidated Income Statement Case Study: Set Up Column Definitions
- Consolidated Income Statement Case Study: Set Up Row Definitions
- Consolidated Income Statement Case Study: Set Up the Statement Definition
- Consolidated Income Statement Case Study: 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: Modify Layout and Column Headers
- 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: Generate the 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