Go to main content
1/13
Contents
List of Figures
Title and Copyright Information
Preface
Audience
JD Edwards EnterpriseOne Products
JD Edwards EnterpriseOne Application Fundamentals
Documentation Accessibility
Related Documents
Conventions and Screen Images
1
Introduction to JD Edwards EnterpriseOne Financial Management and Compliance Console
1.1
JD Edwards EnterpriseOne Financial Management and Compliance Console Overview
1.1.1
Metrics
1.2
JD Edwards EnterpriseOne Financial Management and Compliance Console Integrations
1.2.1
JD Edwards EnterpriseOne Accounts Payable
1.2.2
JD Edwards EnterpriseOne Accounts Receivable
1.2.3
JD Edwards EnterpriseOne Advanced Cost Accounting
1.2.4
JD Edwards EnterpriseOne General Accounting
1.2.5
JD Edwards EnterpriseOne Sales Order Management
1.3
JD Edwards EnterpriseOne Financial Management and Compliance Console Implementation
2
Loading Data for JD Edwards EnterpriseOne Financial Management and Compliance Console
2.1
Understanding JD Edwards EnterpriseOne Financial Management and Compliance Console Data Loading
2.1.1
Prerequisite
3
Managing Segregation of Duties
3.1
Understanding Segregation of Duties
3.2
Understanding Application Security for Users and Roles
3.2.1
SOD Violations
3.2.2
Example of SOD Violations
3.3
Setting Up SOD Rules
3.3.1
Understanding SOD Rules
3.3.1.1
Copy
3.3.1.2
Deactivate Versus Delete
3.3.2
Forms Used to Set Up Segregation of Duties Rules
3.3.3
Reviewing SOD Rules
3.3.4
Creating and Updating SOD Rules
3.3.5
Creating Groups
3.3.6
Copying SOD Rules
3.3.7
Deleting SOD Rules
3.4
Generating SOD Alerts
3.4.1
Setting Processing Options for the Process SOD Violations Program (R80D112)
3.4.1.1
Defaults
3.4.1.2
Environments
3.4.2
Running the Process SOD Violations Program
3.4.3
Reviewing the SOD Report
4
Monitoring Financial Metrics
4.1
Understanding the JD Edwards EnterpriseOne Financial Management and Compliance Console Components
4.2
Understanding Automatic Accounting Instructions
4.3
Prerequisites
4.4
Managing Accounts Payable
4.4.1
Understanding AP Metrics
4.4.2
Setting Processing Options for the AP Discount Information Data Load Program (R80D254)
4.4.2.1
Defaults
4.4.2.2
Display
4.4.3
Running the AP Discount Information Data Load Program
4.4.3.1
AP Discounts Calculation Example
4.4.4
Analyzing AP Discounts
4.4.5
Setting Processing Options for the AP Daily Counts and Amounts Program (R80D253)
4.4.5.1
Defaults
4.4.5.2
Display
4.4.6
Running the AP Daily Counts and Amounts Program
4.4.7
Analyzing AP Daily Counts and Amounts
4.4.8
Setting Processing Options for the AP Open Payables Data Load Program (R80D255)
4.4.8.1
Display
4.4.9
Running the AP Open Payables Data Load Program
4.4.9.1
Open Payables Amount Example
4.4.9.2
Open Payables Count Example
4.4.10
Analyzing AP Open Payables
4.4.11
Setting Processing Options for the AP Vouchers Paid Late Data Load Program (R80D256)
4.4.11.1
Defaults
4.4.11.2
Display
4.4.12
Running the AP Vouchers Paid Late Data Load Program
4.4.12.1
Amount of Vouchers Paid Late Example
4.4.12.2
Number of Vouchers Paid Late Example
4.4.13
Analyzing AP Vouchers Paid Late
4.5
Managing Accounts Receivable
4.5.1
Understanding Accounts Receivable Metrics
4.5.2
Understanding Days Sales Outstanding
4.5.3
Analyzing Days Sales Outstanding
4.5.4
Setting Processing Options for the AR Discount Information Data Load Program (R80D282)
4.5.4.1
Defaults
4.5.4.2
Display
4.5.5
Running the AR Discount Information Data Load Program
4.5.5.1
Discount Information Example
4.5.5.2
Discount Percentage Calculation Example
4.5.6
Analyzing AR Discounts
4.5.7
Setting Processing Options for the AR Daily Counts and Amounts Program (R80D280)
4.5.7.1
Defaults
4.5.7.2
Display
4.5.8
Running the AR Daily Counts and Amounts Program
4.5.9
Analyzing AR Daily Counts and Amounts
4.5.10
Setting Processing Options for the AR Open Receivables Data Load Program (R80D284)
4.5.10.1
Display
4.5.11
Running the AR Open Receivables Data Load Program
4.5.11.1
Amount of Open Invoices Example
4.5.11.2
Number of Open Invoices Example
4.5.12
Analyzing AR Open Receivables
4.5.13
Setting Processing Options for the AR Delinquency Data Load Program (R80D281)
4.5.13.1
Display
4.5.14
Running the AR Delinquency Data Load Program
4.5.14.1
Delinquency Amounts Example
4.5.14.2
Delinquency Counts Example
4.5.15
Analyzing AR Delinquency Information
4.5.16
Setting Processing Options for the AR Open Chargeback Information Data Load Program (R80D283)
4.5.16.1
Display
4.5.17
Running the AR Open Chargeback Information Data Load Program
4.5.17.1
Open Chargebacks Example
4.5.17.2
Open Chargebacks by Reason Code Example
4.5.18
Analyzing AR Open Chargebacks
4.5.19
Setting Processing Options for the AR Total Chargeback Information Data Load Program (R80D285)
4.5.19.1
Defaults
4.5.19.2
Display
4.5.20
Running the AR Total Chargeback Information Data Load Program
4.5.20.1
Total Chargebacks Example
4.5.21
Analyzing AR Total Chargebacks
4.6
Managing Account Balance Information
4.6.1
Understanding the General Ledger Balances Fact Load Programs
4.6.1.1
Object Accounts
4.6.1.2
Balance Sheet Accounts
4.6.1.3
Income Statement Accounts
4.6.1.4
Metrics
4.6.2
Understanding Activity Ratios
4.6.3
Understanding Leverage Ratios
4.6.4
Understanding Liquidity Ratios
4.6.5
Understanding Actual Versus Planned Operating Income, Operating Expense, and Operating Profit
4.6.6
Understanding Profitability Ratios
4.6.7
Prerequisites
4.6.8
Setting Processing Options for the G/L Balances Fact Full Load UBE Program (R80D0201)
4.6.8.1
Display
4.6.8.2
Defaults
4.6.9
Setting Processing Options for the G/L Balances Fact Rebuild UBE Program (R80D0202)
4.6.9.1
Display
4.6.9.2
Defaults
4.6.10
Running the General Ledger Balances Fact Load Programs
4.6.11
Analyzing Fixed Asset Turnover
4.6.12
Analyzing Inventory Turnover
4.6.13
Analyzing Total Asset Turnover
4.6.14
Analyzing Debt to Total Assets
4.6.15
Analyzing Times Interest Earned
4.6.16
Analyzing Current Ratio
4.6.17
Analyzing Quick Acid Test
4.6.18
Analyzing Actual Versus Planned Operating Income, Expense, and Profit
4.6.19
Analyzing Profit Margin on Sales
4.6.20
Analyzing After Tax Profit on Sales
4.6.21
Analyzing Return on Net Worth
4.6.22
Analyzing Return on Total Assets
4.7
Managing Profitability Management
4.7.1
Understanding Profitability Management
4.7.2
Understanding Period Balances
4.7.3
Prerequisites
4.7.4
Setting Processing Options for the ACA Most Profitable Brands Data Load Program (R80D274)
4.7.4.1
Defaults
4.7.4.2
Display
4.7.5
Running the ACA Most Profitable Brands Data Load Program
4.7.6
Analyzing Most Profitable Brands
4.7.7
Setting Processing Options for the ACA Most Profitable Customers Data Load Program (R80D272)
4.7.7.1
Defaults
4.7.7.2
Display
4.7.8
Running the ACA Most Profitable Customers Data Load Program
4.7.9
Analyzing Most Profitable Customers
4.7.10
Setting Processing Options for the ACA Most Profitable Products Data Load Program (R80D273)
4.7.10.1
Defaults
4.7.10.2
Display
4.7.11
Running the ACA Most Profitable Products Data Load Program
4.7.12
Analyzing Most Profitable Products
4.8
Managing Revenue Trends
4.8.1
Understanding Sales Revenue
4.8.2
Understanding Prerequisite Batch Programs
4.8.2.1
Sales Order Fact Data Load Program
4.8.2.2
Shipped Orders Processing Program
4.8.3
Prerequisites
4.8.4
Running the Shipped Orders Processing Program (R80D241)
4.8.5
Analyzing Revenue by Brand
4.8.6
Analyzing Revenue by Division
4.8.7
Analyzing Revenue by Product
4.8.8
Setting Processing Options for the Forecasted Cash Flow Data Load Program (R80D203)
4.8.8.1
Display
4.8.9
Running the Forecasted Cash Flow Data Load Program
4.8.9.1
Forecasted Cash Flow Example
4.8.10
Analyzing Forecasted Cash Flow
4.9
Managing Unposted Transactions
4.9.1
Understanding Unposted Transactions
4.9.2
Setting Processing Options for the Unposted Transaction Data Load Program (R80D701)
4.9.2.1
Display
4.9.3
Running the Unposted Transaction Data Load Program
4.9.3.1
Unposted Income Example
4.9.3.2
Unposted Expense Example
4.9.4
Analyzing Unposted Transactions
5
Working With the FMCC Account Configuration
5.1
Understanding Automatic Accounting Instructions for FMCC
5.2
Associating Account Dimensions to AAIs
5.2.1
Understanding How to Associate Account Dimensions to AAIs
5.2.2
Form Used to AAIs with Account Dimensions
5.2.3
Associating AAIs with Account Dimensions
6
Managing Compliance
6.1
Understanding Compliance Alerts
6.2
Changing System Constants Settings
6.2.1
Understanding GA Settings that Trigger Alerts
6.2.2
Understanding AP Settings that Trigger Alerts
6.2.3
Understanding the AR Settings that Trigger Alerts
6.2.4
Forms Used to Change System Constants Settings
6.2.5
Changing GA Settings
6.2.6
Changing AP Settings
6.2.7
Changing AR Settings
6.3
Changing AP Audit Match Settings
6.3.1
Understanding the AP Audit Match Settings that Trigger Alerts
6.3.2
Forms Used to Change AP Audit Match Settings
6.3.3
Changing AP Audit Match Settings
6.4
Updating Credit Limits
6.4.1
Understanding Credit Limit Settings that Trigger Alerts
6.4.2
Forms Used to Update Credit Limits
6.4.3
Updating Credit Limits
6.5
Updating Expense Policy Settings
6.5.1
Understanding Expense Management Policy Settings that Trigger Alerts
6.5.2
Forms Used to Update Expense Policy Settings
6.5.3
Updating Expense Policy Settings
6.6
Configuring Whistleblower Emails
6.6.1
Understanding Whistleblowing
6.6.2
Prerequisites
6.6.3
Forms Used to Configure Whistleblower
6.6.4
Defining Recipients of Whistleblower Emails
6.6.5
Creating Whistleblower Messages
A
Appendix: JD Edwards EnterpriseOne Financial Management and Compliance Console Table Mappings
A.1
Table Mappings for JD Edwards EnterpriseOne FMCC
A.1.1
Sales Order Fact Table
A.1.2
GL Account Balances Fact Table
A.1.3
Forecasted Cash Flow Aggregate Table
A.1.4
Shipped Orders Aggregate Table
A.1.5
AP Daily Counts and Amounts Aggregate Table
A.1.6
AP Discount Information Aggregate Table
A.1.7
AP Open Payables Aggregate Table
A.1.8
AP Vouchers Paid Late Aggregate Table
A.1.9
Most Profitable Customer Aggregate Table
A.1.10
Most Profitable Product Aggregate Table
A.1.11
Most Profitable Brand Aggregate Table
A.1.12
AR Daily Counts and Amounts Aggregate Table
A.1.13
AR Delinquency Information Aggregate Table
A.1.14
AR Discount Information Aggregate Table
A.1.15
AR Open Chargeback Amounts Aggregate Table
A.1.16
AR Open Receivables Aggregate Table
A.1.17
AR Total Chargeback Aggregate Table
A.1.18
Metric ID Time Dimension Cross Reference Table
A.1.19
Unposted Transaction Aggregate Table
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.