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
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 Top Payment Total by Currency Top Payment Total by Payment Method Payment Method Comparison Top Payment Total by Payment Status Discount Analysis Top Outstanding Prepaind Amounts by Supplier Top Late Charges paid by Supplier |
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 |
This section lists delivered visualizations for:
Asset Management
Maintenance Management
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 |
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 |