1 Introduction to JD Edwards EnterpriseOne Financial Management and Compliance Console

This chapter contains the following topics:

1.1 JD Edwards EnterpriseOne Financial Management and Compliance Console Overview

The Financial Management and Compliance Console (FMCC) provides customers with a set of blended analytic components. The blend covers high-level analytics in addition to daily metrics, which highlight actions to be taken by management. The different metric groupings are categorized by typical job roles within an organization. Executives need to see metrics that show the overall performance of the organization, including financial trending data, key performance indicators (KPIs), and organizational compliance. Financial managers work with different performance objectives and, therefore, need to review daily performance in addition to tactical alerts that require action. The console equips an organization with the data to make high-level management decisions that can reduce costs, maximize productivity, analyze risk factors, analyze payment trends, maximize profitability, and maintain high-quality standards.

A consistent, comprehensive, and timely view of the performance metrics saves both time and money. JD Edwards EnterpriseOne FMCC provides metrics that are pertinent to a variety of roles within organizations, including customer, supplier, operations, and financial managers. The metrics use existing data within JD Edwards EnterpriseOne to provide visibility to the information and enable analysis and evaluation of the information. FMCC includes 42 financial metrics and compliance alerts. JD Edwards EnterpriseOne FMCC supplies metrics across the key areas that define the financial performance of companies:

  • Accounts Payable

  • Accounts Receivable

  • Activity Ratios

  • Cash Flow

  • Leverage Ratios

  • Liquidity Ratios

  • Profit (actual versus planned)

  • Profitability Management

  • Profitability Ratios

  • Revenue Trends

  • Corporate Governance

Each of these key areas includes a number of metrics for analyzing business performance.


Note:

This implementation guide uses a generic set of metric groups based on the key areas. Each metric is included in one of the key area groups. Metric groups are user-defined; the groups in this implementation guide are for example purposes only.

1.1.1 Metrics

The JD Edwards EnterpriseOne FMCC system provides 42 different metrics, six compliance alerts, and a segregation of duties system to help analyze financial performance.

These tables list the metrics in each key area, the type of default display for each metric, and if goals are allowed:

Accounts Payable Activity Metric Type of Default Display Goals Allowed
Amount of Discounts Available, Taken, and Not Taken Cluster bar chart No
Percentage of Discounts Lost Grid Yes
Amount Vouchered and Paid for the Day Cluster bar chart No
Number of Vouchers and Payments Entered for the Day Cluster bar chart No
Amount of Open Vouchers and Open Vouchers That are Past Due Cluster bar chart No
Number of Open Vouchers and Open Vouchers That are Past Due Cluster bar chart No
Amount of Vouchers Paid Late Bar chart No
Number of Vouchers Paid Late Bar chart No

AR and Collections Activity Metric Type of Default Display Goals Allowed
Total Chargeback Amount and Total Chargeback Amount by Reason Code Bar chart No
Open Chargeback Amount and Open Chargeback Amount by Reason Code Bar chart No
Amount of Open Invoices Bar chart No
Number of Open Invoices Bar chart No
Amount Invoiced and Received for the Day Cluster bar chart No
Average Amount Invoiced for the Day Bar chart No
Number of Invoices and Receipts Entered for the Day Cluster bar chart No
Open Amount of Past Due Invoices and Amount of Open Delinquency Fees Cluster bar chart No
Number of Past Due Invoices and Number of Customers with Past Due Invoices Cluster bar chart with goal marker Yes
Discounts Available, Taken, and Unearned Discounts Taken Stacked bar chart No
Percentage of Invoices for Which a Discount was Taken, Percentage of Invoices for Which a Unearned Discount was Taken, and Percentage of Invoices for Which a Discount was Available but not Taken Pie chart No
Days Sales Outstanding Combo bar with goal marker Yes

Activity Ratios Metric Type of Default Display Goals Allowed
Fixed Asset Turnover Combo bar with goal marker Yes
Inventory Turnover Combo bar with goal marker Yes
Total Asset Turnover Combo bar with goal marker Yes

Profit Metric Type of Default Display Goals Allowed
Actual and Planned Operating Income Amounts Cluster chart No
Actual and Planned Operating Expense Amounts Cluster chart No
Actual and Planned Operating Profit Cluster chart No
Forecasted Cash Flow Combo bar with goal marker Yes
Total Unposted Expenses and Income Cluster bar chart No

Leverage and Liquidity Ratios Metric Type of Default Display Goals Allowed
Debt to Total Assets Combo bar with goal marker Yes
Times Interest Earned Combo bar with goal marker Yes
Current Ratio Combo bar with goal marker Yes
Quick Acid Test Combo bar with goal marker Yes

Profitability with ACA (Advanced Cost Accounting) Metric Type of Default Display Goals Allowed
Most Profitable Customer Bar chart No
Most Profitable Brand Bar chart No
Most Profitable Product Bar chart No

Profitability Ratios Metric Type of Default Display Goals Allowed
Profit Margin on Sales Combo bar with goal marker Yes
After Tax Profit on Sales Combo bar with goal marker Yes
Return on Net Worth Combo bar with goal marker Yes
Return on Total Assets Combo bar with goal marker Yes

Revenue Management Metric Type of Default Display Goals Allowed
Revenue by Brand Bar chart No
Revenue by Division Bar chart No
Revenue by Product Bar chart No

Corporate Governance Issue Type of Default Display Goals Allowed
Whistleblower Email No
System Settings Alert No
AR Settings Alert No
AP Audit Match Settings Alert No
Credit Limit Settings Alert No
Expense Management Settings Alert No
Segregation of Duties Alert No

1.2 JD Edwards EnterpriseOne Financial Management and Compliance Console Integrations

The JD Edwards EnterpriseOne FMCC system integrates with these JD Edwards EnterpriseOne systems from Oracle:

  • JD Edwards EnterpriseOne Accounts Payable

  • JD Edwards EnterpriseOne Accounts Receivable

  • JD Edwards EnterpriseOne Advanced Cost Accounting.

  • JD Edwards EnterpriseOne General Accounting

  • JD Edwards EnterpriseOne Sales Order Management

Accurate and timely information in these systems is critical to the success of the JD Edwards EnterpriseOne FMCC system.

1.2.1 JD Edwards EnterpriseOne Accounts Payable

JD Edwards EnterpriseOne FMCC integrates with JD Edwards EnterpriseOne Accounts Payable to determine the number and amount of open and paid vouchers, discounts taken and lost, and the number and amount of vouchers paid late. The system also uses accounts payable information to calculate financial ratios such as Debt to Total Assets and Quick Acid Test.

1.2.2 JD Edwards EnterpriseOne Accounts Receivable

JD Edwards EnterpriseOne FMCC integrates with JD Edwards EnterpriseOne Accounts Receivable to determine the number and amount of open and paid invoices, earned and unearned discounts taken, delinquency and chargeback information, and days sales outstanding (DSO). The system also uses account receivable information to calculate financial ratios such as Return on Total Assets and After Tax Profit on Sales.

1.2.3 JD Edwards EnterpriseOne Advanced Cost Accounting

The JD Edwards EnterpriseOne FMCC system uses data from the JD Edwards EnterpriseOne Advanced Cost Accounting (ACA) to determine Most Profitable Customers, Most Profitable Brands, and Most Profitable Products metrics. The JD Edwards EnterpriseOne ACA system enables you to determine the indirect costs of business.

1.2.4 JD Edwards EnterpriseOne General Accounting

JD Edwards EnterpriseOne FMCC integrates with JD Edwards EnterpriseOne General Accounting to gather the base data for metrics. The system loads the data from the account balances into the JD Edwards EnterpriseOne FMCC tables to use for calculating the financial ratio performance metrics. Additionally, using the Cash Forecasting applications, the system can display cash flow information.

1.2.5 JD Edwards EnterpriseOne Sales Order Management

JD Edwards EnterpriseOne FMCC integrates with JD Edwards EnterpriseOne Sales Order Management to gather the base data for metrics. The system loads the data from the sales order tables into the JD Edwards EnterpriseOne FMCC tables to use for metric tracking. The system uses sales order information to determine current and projected revenue trends.

1.3 JD Edwards EnterpriseOne Financial Management and Compliance Console Implementation

Implementation tasks are common to all consoles in the JD Edwards EnterpriseOne Console system. The steps to implement the system are documented in the JD Edwards EnterpriseOne Console Fundamentals Implementation Guide.

See "Getting Started with JD Edwards EnterpriseOne Consoles" in the JD Edwards EnterpriseOne Applications Console Fundamentals Implementation Guide