Understanding Delivered Visualizations in FSCM

This topic provides the delivered dashboard visualizations in FSCM.

This topic breaks the delivered visualizations into these product categories:

This section lists the delivered visualizations for:

  • General Ledger

  • Payables

  • Receivables

  • Billing

  • Commitment Control

General Ledger Visualizations

Visualization

Dashboard

Search Definition

Image Added

Journals across Date/Time Entered

Journal Count by Status for Top 20 Users

Suspense Journal Count by Journal Source

Journal Line Count for Top 20 Departments

GL Operational Insights

EP_GL_JOURNAL_KIB

Update Image 37

Financial Balance Trend

Journal Amount by Department

Top 5 Expense Accounts

Top 5 Revenue Accounts

Financial Position Trending

EP_GL_JOURNAL_KIB

Update Image 37

YOY Comparison

Top 5 Expense Accounts

Top 5 Revenue Accounts

Financial Performance Analysis

EP_GL_LEDGER_KIB

Update Image 37

Actuals vs Budget

Total Actuals to Budget

Remaining Budget by Period

Top Expense Type Budgets

Top 5 Department Budgets

My Budget

EP_GL_ACT_BUDG_LEDG_KIB

Update Image 41

Expense Actuals vs Budget

Available Expense Budget by Period

Expense by Category

Revenue by Product Line

Budget Spend by top 5 Departments

Revenue by Top 5 Departments

Controllers Key Metrics

EP_GL_ACT_BUDG_LEDG_KIB

Update Image 41

Payables Visualizations

Visualization

Dashboard

Search Definition

Image Added

Voucher Source across Date/Time Entered

Gross Amount by Payment Terms and Currency

# Vouchers by Currency and Voucher Source

Early Detection and Monitoring

EP_AP_VOUCHERS

Update Image 36

Gross Amounts by Currency across Year-Month Entered

# Vouchers by Business Unit across Year-Month Entered

Trend Analysis

EP_AP_VOUCHERS

Update Image 36

Top Payment Total by Payment Term

Discount Analysis

Top Payment Total by Payment Method

Trending Payment Counts per Payment Method

Top Outstanding Prepaind Amounts by Supplier

Top Payment Total by Payment Currency

Top Suppliers by Payment Counts

Late Charges: Top Suppliers

Late Payments: Process Days Range

Cancelled Payments: Payment Status

Cancelled Payments: Cancel Reason

AP Payment Metrics

EP_AP_PAYMENTS_KIB

Update Image 46

Receivables Visualizations

Visualization

Dashboard

Search Definition

Update Image

AR Balances vs Overdue

AR Balance vs Collected

Write-off's and Deductions

Disputes by Business Unit

Top 5 Customer Risk Sources (Current)

Top 5 Customer Balances (Current)

AR Collections Analysis

EP_AR_ITEM_ACT_COLL_KIB

Update Image 38

Aging by Business Unit

Aging by Customer

Collector Effectiveness

DSO by Business Unit

Highest Balance Receivables by Customer

Highest Balance Receivables by Collector

Collections Manager

EP_AR_CUST_AGING_KIB

EP_AR_CUST_HIST_KIB

Update Image 45

Aging Balance Summary

Aging by Customer

Highest Balance Receivables by Customer

Average Days Late by Customer

Collector Dashboard

EP_AR_CUST_AGING_KIB

EP_AR_CUST_HIST_KIB

Update Image 45

AR Open vs Closed Items by Collector

Overdue Balance by Collector & Currency

Write-off's by Collector

Credit Memos by Collector

Collector Performance

EP_AR_ITEM_ACT_COLL_KIB

Update Image 38

Billing Visualizations

Visualization

Dashboard

Search Definition(s)

Update Image

Billing by Business Unit

Billing by Top Customers

Billing by Top Bill Source

Billing by Top Contracts

Billing by Industry

Billing by Top Sales Persons

Billing Analysis

EP_BI_HDR_KIB

Update Image 44

Invoices by Top Business Units

Invoices by Bill Source and Date/Time Updated

Invoices by Customers and Billing Specialist

Invoices by Bill Source and Business Unit

Invoices by Invoice Media

Invoices by Top Contracts

Period-to-Date Billing Activity by Region

Billing Operations

EP_BI_HDR_KIB

Update Image 44

Commitment Control Visualizations

Visualization

Dashboard

Search Definition(s)

Update Image

Budget Overview

Budget Entry Types

Top Spend Departments

Top Spend Expenses

Commitment Control Insights

EP_GL_KK_ACTIVITY_LOG_KIB

Update Image 48

Transactions with Budget Exceptions

Errors

Warnings

Errors by Source Transaction

Warnings by Source Transaction

Commitment Control Exceptions

EP_GL_KK_EXCEPTIONS_KIB

Update Image 49

This section lists delivered visualizations for:

  • Asset Management

  • Maintenance Management

  • Lease Administration

Asset Management Visualizations

Visualization

Dashboard

Search Definition

Update Image

Asset Count

Total Cost

Net Book Value

Top 10 Asset Types - Asset Count

Top 10 Categories - Asset Cost

Top 10 Categories - Period Depreciation/Amortization

Top 10 Categories - Net Book Value

Top 10 Asset Types - Cost versus Net Book Value

Asset Analytics

EP_AM_METRIC_KIB

Update Image 43

Year-Over-Year Asset Acquisitions

Year-Over-Year Period Depreciation/Amortization

Year-Over-Year Retirement Gain/Loss

Year-Over-Year Cost versus Net Book Value

Year-Over-Year Acquired Asset Count

Year-Over-Year Retired Asset Count

Year-Over-Year Asset Analytics

EP_AM_METRIC_KIB

Update Image 43

Maintenance Management Visualizations

Visualization

Dashboard

Search Definition

Update Image

Future Workload by Technician / Criticality

Technician Past performance

Task Status by Due Date

Unassigned Tasks by Shop / Asset Location

Overdue PMs by Technician

Overdue Unassigned PMs by Shop

Work Order Labor Assignments

EP_WM_WO_RESOURCES_KIB

Update Image 40

Top 5 Problem Codes by Asset Type

Asset Types with Highest Spend on Part

Asset Types with Highest Spend on Labor

Task Completion Performance

Task Completion by Asset Type

Work Order Asset Maintenance History

EP_WM_WO_RESOURCES_KIB

Update Image 40

Lease Administration Visualizations

Visualization

Dashboard

Search Definition

Update Image

This Month’s Payment

This Month’s Obligation Reduction

This Month’s Interest Expense

Lease Expiring in the Next 12 Months

Lease Expiring by Fiscal Year

Lease Expirations in the Next 90 Days

Lease Data

Lease Payment Insights

EP_RE_PAYMENT_INS

Update Image 50

Remaining Lease Payments

Remaining Obligation Reduction

Lease Payment Forecast

Lease Obligation Reduction Forecast

Lease Payment Forecast

EP_RE_PAYMENT_INS

Update Image 50

This topic lists the delivered visualizations for:

  • Contracts

  • Expenses

  • Project Costing

  • Grants

Contracts Visualizations

Visualization

Dashboard

Search Definition

Update Image

Number Active Contracts by Contract Administer

Number Active Contracts by BU, Region and Type

Remaining Billing by BU by Region and Type

Remaining Billing Vs Remaining Revenue by BU

Average Remaining Contract Duration by BU and Region

Top 5 Contracts with Longest Remaining Duration by Customers

Largest 30 Contracts Started in the Last 30 Days

Contract Analytics

EP_CA_HDR_KIB

Update Image 37

Expenses Visualizations

Visualization

Dashboard

Search Definition

Update Image

Top Travel Policy Violations

Top Expense Policy Violations

Activity with Non-Preferred Merchants by Employee

Activity with Non-Preferred Merchant by Expense Type

Employees Using Corporate Card for Personal Expenses

Travel Policy Violations

EP_EX_SRCH_RISK_EXCP_KIB

Update Image 40

Top Travel Policy Violations

Expense Reports by Status

Non-Reimbursable Expenses on Corporate Card

Average Days to Expense Credit Card Transactions

Expense Report Denied by Expense Type

My Proxy Expense Activity

EP_EX_SRCH_EMP_EXCP_KIB

Update Image 41

Top Spenders

Total Activity by Expense Type

Credit Card vs Other Spending

Personal Charges to Credit Card

Expenses Billable Analysis

Average Days from Submission to Approval

Average Days from Approval to Payment

Performance & Operations

EP_EX_SRCH_PERF_OPR_KIB

Update Image 41

Project Costing Visualizations

Visualization

Dashboard

Search Definition

Update Image

Project Financials by Period (Budgeted and Actual Cost)

Top 10 Projects for Actual Cost

Top 10 Managers for Actual Cost

Actual Cost by Project Types

Top 10 Source Types for Actual Cost

Top 10 Vendors for Actual Cost

Top 10 Expense Report Filers for Actual Cost

Project Cost Analytics

EP_PC_PROJ_RES_KIB

Update Image 44

Project Financials by Period (Budgeted, Actual Cost, and Billing Amount)

Top 10 Projects for Billing Amount

Top 10 Managers for Billing Amount

Top 10 Vendors for Billing Amount

Top 10 Billable Employees

Project Billing Analytics

EP_PC_PROJ_RES_KIB

Update Image 44

Project Financials by Period

Top 10 Projects for Actual Revenue

Top 10 Managers for Actual Revenue

Top 10 Vendors for Actual Revenue

Top 10 Profitable Employees

Project Revenue Analytics

EP_PC_PROJ_RES_KIB

Update Image 44

Year-Over-Year Total Actual Cost

Year-Over-Year Actual Revenue

Year-Over-Year Vendor Actual Cost

Year-Over-Year Profit (Loss)

Year-Over-Year Billing Amount

Year-Over-Year Billable Hours

Year-Over-Year Project Analytics

EP_PC_PROJ_RES_KIB

Update Image 44

Grants Visualizations

Visualization

Dashboard

Search Definition

Update Image

Award Summary

Total Cost by Award

Billing by Sponsor

Billing by Project

Cost by Principal Investigator

Actual Cost by Contract Type

Cost by Source Type

Cost Reimbursable Award Financials

EP_CA_GM_PROJRES_INSIGHT

Update Image 49

This topic lists the delivered visualizations for:

  • Purchasing

  • Inventory

Purchasing Visualizations

Visualization

Dashboard

Search Definition

Update Image

Contracts by Contract Style

Contracts by Status

Contract vs Non Contract Spend

Top Suppliers

Contracts Expiry by Month

Procurement Contracts

EP_PO_CONTRACT_KIB

Update Image 38

Purchase Volume by Business Unit

Top Suppliers

Purchase Order by Pay Terms

Delivery Performance

Rejections and Supplier Returns

Purchase Order Amount by Budget Status

Procurement Volume Trend

Purchasing Effectiveness

EP_PO_RECEIPTS_KIB

Update Image 38

Purchased Orders by Acknowledgement Status

Purchase Orders by Status

Purchase Orders by Budget Status

Purchase Order by Document Tolerance Status

Pending and Past Due Deliveries

Purchase Orders by Period

Purchasing Operations

EP_PO_RECEIPTS_KIB

Update Image 38

Number of POs Dispatched by Buying Organization

Value of POs Dispatched by Buying Organization

Number of POs Dispatched by Ship To Location

Pending and Past Due Purchase Orders by Supplier

Delivery Performance Analysis by Supplier

Value of Shipment Rejections and Returns by Supplier

Value of Purchase Order Activity Trend by Supplier

POA Response Against Service Level Agreements

Number of POAs Pending and Past Due by Supplier

Number of POAs by Acknowledgement Status by Supplier

Supplier Activity Analytics Insights

EP_PO_POA_KIB

Update Image 49

Inventory Visualizations

Visualization

Dashboard

Search Definition

Update Image

Value of Lots Approaching Expiration by Business Unit

Value of Lots Approaching Expiration by Time Increments

Number of Items of Lots Approaching Expiration

Lots Approaching Expiration by Location

Lots Approaching Expiration by Item Category

Item Lots Approaching Expiration Date

EP_IN_ONHAND_KIB

Update Image 44

Non-Viable Inventory Value by IBU

Non-Viable Inventory by Item Category

Non-Viable Inventory by Location

Value of Non-Viable Inventory by Time Increments

Number of Non-Viable Inventory in Expired Lots

Non-Viable Item Lot Analysis

EP_IN_ONHAND_KIB

Update Image 44