Finance Reporting and Analytics Release Notes for April 10th

Finance Reporting and Analytics Release Notes for April 10th.   This update includes significant new reports and modifications that have been released since March 9th as well as known issues that we are investigating or working on currently.

 

A friendly reminder that you always find this information and more reporting resources at: 

 

Adaptive Planning Release Notes delivered from Office of Planning and Analysis.

 

Workday

Significant Workday Reporting Updates for General Use:

  • Fund Balance by MBU:  Managerial summary of current and projected Fund Balances for the Academic Division.  Worktag Prompts can be used to highlight specific funds, gifts, grants, or designated worktags.  Balances can be drilled into for further analysis
  • Status of Account Certifications:   Delegates have been removed from the Awaiting Preparer and Awaiting Approver fields.
  • Non-payroll Commitments and Obligations:  Estimated F&A for Commitments and Obligations has been added to the report.
  • Award and Grant Assigned Roles Audit:  Select a Department or Cost Center to find any and all Grant related roles which are unassigned.  It can also be used to get a consolidated list of all the Awards/Grants in a Cost Center or Department with all the associated roles.
  • Cost Reimbursable Line Status:   Added drill-down capabilities to the Accounting and Budget Dates of the billable items
  • General Ledger Details – with Payroll Details:  Added Pay Component and Hours Worked fields.
  • Worker Costing Allocation Information – Payroll
    • Report now pulls Position Restriction (labor suspense) costing allocations in for greater visibility into allocations that exist for a single Worker.
    • Positions without costing allocations can now be pulled in this report, eliminating the need to remember the name of multiple reports.
    • Outdated/unnecessary costing allocation reports have now been hidden so there will be fewer reports returned in search results, providing users with more confidence that they have selected the right report.
  • Find Supplier Invoice:  Added new prompts and fields to highlight invoices in draft status that have errors or warning that will prevent them from being processed.
  • Various audit reports for Supplier Accounts
    • Supplier Change/Create Audit Report
    • Suppliers with mismatch Payment Types
    • Supplier Invoices with cleared Match Exceptions
  • Other minor enhancements, bug fixes, and new reports for targeted central use.

Coming in April:

  • Improved Prompts in Status of Account Certifications
  • New and Improved Account Certifications Awaiting Me
  • Bank Statement Reconciliation reports

 

Known Reporting Issues in Workday currently under review or items of interest in Development:

  • Spend Detail Report - Hotel name from Expense Report does not pull into the Vendor/Payee field

 

UBI

Enhancements to UBI Reports:

  • NEW!  Workday NACUBO Function Analysis
  • NEW!  Workday F&A Recovery
    • Check the F&A Recovery on individual Grants and Awards
    • Check F&A generated by individual Award or Grant PIs
    • See the F&A revenue allocation by Department, Dean’s Office, and School
  • Workday Journal Lines
    • Added a new Community Sheet for Non-Payroll Commitments and Obligations with all worktags to provide more detail than is available in the report with the same name in Workday
  • Workday Research Admin Dashboard (RAD)
    • Added a new Home Page and navigation buttons for an improved user experience
    • Improved the layout/UI of the Grant Summary page
    • New views of Project to Date, FYTD, and Future Spending by Fiscal Period as well as Burn Rates and Spending Forecasts
    • Added Grant Invoice History
    • Organization page with contact information and hierarchies for key personnel
    • Definitions sheet to clarify the metrics used in RAD
    • Direct Access now available for PIs – QRGs and formal launch materials under development

There has been a significant amount of work put into RAD over the past 3-4 months with great collaboration and input from OSP and Grant Administrators and PIs in the Schools and Units.  We’re going to take a pause and collect feedback during April and Mays so you likely will not see anymore updates to RAD for a few months.  If you have feedback or suggestions, please send it to AskFinance@virginia.edu.

  • Workday Fund Balances
    • Added Project Hierarchy Levels 3 & 4 to the Fund Balance by Project sheet

 

Items in UBI currently under review or development:

  • Workday Supplier Invoices:   New app and dataset with Supplier Invoices

Important note regarding EDW/UBI reload schedule

  • The Date Warehouse (EDW) and UBI are currently scheduled to reload Sunday – Thursday nights with data extracts from Workday starting at 9 PM.  This timing is driven by maintenance and backup schedules for Workday and our data center.  When a month-end falls on a Friday, an out-of-cycle refresh will happen so data is available over the weekend.

 

Release Date
Functional Area
Finance Reporting and Analytics Release Notes