Finance Reporting and Analytics Release Notes

January 25 Release Notes

Finance Reporting and Analytics Release Notes for January 25.  This update includes significant new reports and modifications that have been released since October 5 as well as known issues that we are investigating or working on currently.

 

 

Archived Release Notes:

December 14, 2023

Workday enhancements include two new reports:

 

NEW Award Authorized vs. Plan Amount - Check if the Award budget amount matches the authorized amount of the Award. NEW Supplier Invoices with Cancelled Payments for OSP - a report of Supplier Invoices that have been reissued or have multiple settlements. Plus, several new fields and prompts have been added to existing reports such as:
  • FDM Reference – Funds - Added the new Sponsored Programs Fund Hierarchy.
  • FDM Reference – Project - Added the “Project Budget Manager” and “Project Budget Specialist” fields to the report.
  • FDM Reference – Cost Center - Added the “Last Functionally Updated” field if you need to check when a cost center name or hierarchy may have been changed.
  • Grant Budget vs Actual - Added an “As of Budget Amendment Date” prompt so that reports can be run with the budget as it was at the same point in time and period used for Expenses. 

 

 

 

Workday Account Certification Dashboard - Added a new Sheet to track the status of grant-related Account Certifications. Workday FDM Reference - Added the new Sponsored Programs Hierarchy on the Funds sheet Removed Inactive worktags.  If you need to view inactive tags, use the FDM Reference reports in Workday. Workday Journal Lines - The “Details” Sheet now requires you to select an MBU before the chart will display data.  This was done to improve performance.  You can select one or more MBUs, apply other filters, and select multiple periods as needed.There are a variety of other updates to existing apps including:

 

UBI enhancements include one new app:

 

NEW Workday RAD for PIs - This new app is a streamlined version of the existing RAD app for use by PIs.  Upon login by the PI, the app will dynamically filter the data to only their Awards.  Be on the lookout for more info coming in January 2024.
October 4, 2023

Workday

Some new fields have been added to a few of the Workday reports (see Release Notes for specifics) and there are 3 new reports:

NEW Find Account Adjustments with Worktags –  this new custom report will show both the original and current worktags for any Accounting Adjustment entries on Supplier Invoices or Expense Reports.  NEW  Expense Reimbursements in process - Graduate Students – new report for monitoring aging expense reimbursements for Graduate Students.  NEW  BP Transaction Status – new report to find BPs that are completed – for instance, all Payroll Costing Allocations submitted on a particular day.  The existing BP in Process Monitoring report did not include an option for completed BPs.

 

Other noteworthy items:

The Line Item hierarchy for Salary related Spend Categories has been expanded to allow for more granularity in Salary reporting.  The Spend Category values remain the same. The Fund Level 3 and the alternate UFM Fund Source Group 3 hierarchies (Operating/Non-Operating) have been aligned to eliminate reporting inconsistencies across reports when filters are applied. New Spend and Revenue Categories for Transfers have been added to improve the granularity of reporting.  Contact FP&A via AskFinance if you have questions.
  • Amount fields being used in the data model have been cleaned up for consistency. 
  • Note this change may cause you to see issues in your personal “My sheets” (e.g., report won’t render or Amount field(s) show only 0).  You can replace the field on your sheet by searching the Measures for “Amount” or reach out to AskFinance if you need assistance.

UBI

Workday Journal Lines -  

Please select your filters BEFORE you open the Details sheet. The amount of data in the app continues to grow so limiting the data before the table generates will improve response times.
August 24, 2023

Finance Reporting and Analytics Release Notes for August 25th.    

 

This update includes significant new reports and modifications that have been released between July 1st and August 11th as well as known issues that we are investigating or working on currently. 

 

When using the UBI WD Journal Lines app, please remember to set filters BEFORE you open the Details sheet.  The amount of data in the application continues to grow so limiting the data before the table generates will improve response times. 

 

The BI team met earlier this week with a group of users to discuss options for managing the data volume to keep the UBI apps performing.   During the fall, you can expect to see a few new Journal Lines apps in UBI – one will contain Actuals only for both the Income Statement and Balance Sheet accounts, the other will contain Actuals plus Commitments and Obligations, but only Income Statement ledger accounts.  More to come on exact timing. 

  

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

Business Intelligence & Analytics | UVA Finance (virginia.edu) 

 

 

 

  

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. 

WD Book to Budget Crosswalk 

WD Dean’s Dashboard 

Workday RAD for PIs:  Working with RAIT members on a streamlined version of RAD focused on the needs of the PI Community 

WD Journal Lines (Actuals Only) 

WD Journal Lines (Revenue, Expense, Transfers Only) 

 

  

Items in UBI currently under review or development: 

  

UBI 

Enhancements to UBI Reports: 

Workday Research Admin Dashboard (RAD):   Added a Simple Expense BBA Report 

Workday Supplier Invoices:   NEW! app and dataset with Supplier Invoices – created for Accounts Payable team  

Workday Payroll Costing:  Added two new fields (Costing Override and Earning Name) to more easily review allocations for employees with multiple costing types. 

 

 

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 

Project Fund Balance:  NEW - Fund Balance report by Project with associated funding worktags provides beginning balance, YTD activity, and current balance. 

Payroll F&A Reconciliation:  Added Budget Date Drill-down field 

Billing Installments – OSP:  NEW report is to help pull information on installments to be manually invoiced. 

Other minor enhancements, bug fixes, and new reports for targeted central use – (OSP, Business Assets, Accounts Payable, Procurement, Financial Accounting). 

  

 

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

  

Workday 

 

Significant Workday Reporting Updates for General Use: 

Open Obligations on Purchase Orders: NEW  - This new report can be run on a cost center, designated, gift, or grant.  You can look up a purchase order or a specific supplier.  By default, it will include canceled and closed POs and will exclude POs with no obligation remaining.  See the sample report image below for an idea of the fields available to view in the report.  The report can also be modified to show POs with zero obligations remaining that are not closed or canceled (these are good candidates for closing!). 

Details for Account Certifications:  Project, Designated, Gift, and Grants fields have been added to the prompt screen. 

My Card Transactions:  Report can now be run for all expense transactions (both approved and unexpensed/unapproved).  Added a drillable link to the Expense Report Line.  Added this report to the Expense Dashboard/Worklet for quick access. 

July 13, 2023

This update includes significant new reports and modifications that have been released between May 22nd and June 30th as well as known issues that we are investigating or working on currently.

 

Thank you all for your patience as we worked through a few unexpected glitches as we rolled over fiscal years for the first time in Workday and the data warehouse.  The data warehouse team, UBI team and the Finance BI team reacted quickly to resolve the data load errors that occurred during the first couple days of the new year.  We will apply the lessons learned to strengthen the processes for next year.

 

For those interested, our Journal Lines table in the warehouse currently has 64,000,000 rows of data.  Over the coming weeks and months, we will be evaluating the UBI applications to optimize performance where necessary which may require some changes to manage the data volumes.  We will keep everyone posted as we make those decisions.

 

For those who use Budget or Fund Balance reports in Workday, please make note of the Period, Time Period, Plan Structure, Plan Name, and Budget Date prompts you are using based on your need to either look back at FY23 or forward to FY24.  Most reports are set to prepopulate those prompts for the current period/fiscal year.

 

FY24 Working and Original Budgets are now available in both Workday and UBI Budget vs Actuals.

 

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

Business Intelligence & Analytics | UVA Finance (virginia.edu)

 

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.

Items in UBI currently under review or development:

Workday Supplier Invoices:   New app and dataset with Supplier Invoices Workday RAD:  Simple Expense BBA Report

 

 

Workday Research Admin Dashboard (RAD)
  • Corrected the linkage between Awards and Grants where a budget does not yet exist.

 

UBI

Enhancements to UBI Reports:

Workday Journal Lines
  • Added Pay Period, Pay Period Start, Pay Period End, Grant Cost Center, Grant Sub-department, Grant Department, Grant VP/MBU & Purchase Order

 

 

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

Image removed.

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

 

Workday

 

Significant Workday Reporting Updates for General Use:

Details for Account Certifications:  Activity Stream field has been added to streamline review of account certifications – see Activity Stream | UVA Finance (virginia.edu) for more information about this new feature. Grant/Award Budget vs Actuals reports:  Updated the various Award/Grant reports so that Transfers and Interest Income transactions are included OSP Award Comparison Report:  Added a field for Open Receivables Grant Balance Available:  Added Budget Date and Originating Transaction fields to the Drill-down/Details sub-reports Sponsored Invoices:  Cleaned-up various data and formatting issues on Sponsored Invoice templates. Open Purchase Orders – Fully Invoice and Fully Paid:  NEW – quickly identify candidates for closing out open purchase orders which are complete. Track Purchase Order with Line Splits: New & Improved -   This report provides greater detail and improved usability over the existing Track Purchase Order report.  We will be looking at consolidating the various PO and Supplier Invoice reports this summer. Other minor enhancements, bug fixes, and new reports for targeted central use – especially related to year-end clean-up and state reporting needs (Business Assets, Accounts Payable, Procurement, Financial Accounting).
May 22, 2023

This update includes significant new reports and modifications that have been released since April 10th 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: 

Business Intelligence & Analytics | UVA Finance (virginia.edu)

 

 

 

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.

Please send feedback or suggestions to AskFinance@virginia.edu by May 31st for evaluation for the next update.

 

Items in UBI currently under review or development:

Workday Supplier Invoices:   New app and dataset with Supplier Invoices Workday Journal Lines
  • Added an Employee Cost Center filter for easier salary analysis of employees in a cost center. (requested by SOM)
Workday eVA Fee Chargebacks
  • New app with summary and detail of eVA fees to be charged out to the Schools and Units for FY23.
Workday Delegations (Finance)
  • New app for looking up the status of delegations for Finance BPs in Workday.  (requested by SOM)
Workday Security Roles
  • Added filters to enable search by Project Hierarchy
Workday Fund Balances
  • Added filters to enable search by Project Hierarchy
Workday Account Cert Dashboard
  • New sheet for downloading and submitting reassignment requests
Workday Research Admin Dashboard (RAD)

 

UBI

Enhancements to UBI 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

 

June focus:

OSP reporting (New and Updates) – Sponsored Invoices, Budget vs Actual and Balance reporting, F&A reconciliations Bank Statement Reconciliation reports

 

Image removed.

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

 

Workday

Significant Workday Reporting Updates for General Use:

Account Certification Reports: (more detailed info on these enhancements is coming soon)
  • Account Certification Awaiting Me: New Prompts and Data Fields
  • Status of Account Certifications:  New Prompts and Data Fields
  • Details for Account Certifications:  Now includes attachments to streamline the review and approval process
Expendable Fund Balance Summary:  Enabled drill-down to the Memo/Comments fields for easier access. Budget FDM Summary and Actuals FDM Summary:  Aligned the columns of these two reports so that they can be used in tandem if you need to download your budget with all FDM worktags and combine with Actuals (and Obligations) in an Excel pivot table (requested by A&S) Open Purchase Orders:  Added Payment Status field Cost Center Role Assignments – Security:  Added the Payroll Costing Manager Role Simple “BBA” report:  Added an additional line to capture recoveries. Other minor enhancements, bug fixes, and new reports for targeted central use – especially related to year-end clean-up and state reporting needs (Business Assets, Accounts Payable, Procurement, Financial Accounting). Updates to the Project User Interface coming the week of May 29:
  • We are planning two changes to the Project User Interface. First, an updated spend report Project Actual Spend will be added to the Financials tab to include all types of transactions. The current, Workday delivered report “Project Spend” does not fully detail all transaction types so we are adding the Project Actual Spend report. You will still see the Project Spend report, but the new Project Actual Spend Report will also be available.
  • Additionally, we are adding a Project Funding Source Rule report to the Financials tab on the Project User Interface. This should aid in clean up and troubleshooting MFS issues related to projects by providing more comprehensive information on the Project Financials tab.

April 10, 2023

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: 

Business Intelligence & Analytics | UVA Finance (virginia.edu)

 

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.

 

Items in UBI currently under review or development:

Workday Supplier Invoices:   New app and dataset with Supplier Invoices

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

 

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

 

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

Coming in April:

Improved Prompts in Status of Account Certifications New and Improved Account Certifications Awaiting Me Bank Statement Reconciliation reports 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.

 

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.
March 9, 2023

March 9 Release Notes

Finance Reporting and Analytics Release Notes for March 9th.   This update includes significant new reports and modifications that have been released since February 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: 

Business Intelligence & Analytics | UVA Finance (virginia.edu)

 

 

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.

 

Important note regarding EDW/UBI reload schedule

  

Items in UBI currently under review or development:

COMING SOON! - Workday RAD (Research Admin Dashboard)
  • Direct access for Principal Investigators (In testing now with target release data of 3/31)

 

 Coming Soon:

Workday NACUBO Function Analysis:   This is a new app that allow us to compare FY23 to FY22 use of the Function code within each MBU and will highlight any significant variances so that they can either be corrected or validated and explained.

 

Workday Budget vs Actuals
  • Added Estimated F&A Commitments and Obligations
Workday Account Certification Dashboard
  • Corrected error where not all records had Cost Center and/or Principal Investigators values.
Workday Fund Balances
  • Added Gift Type attribute to the Gift dimension so it is available for use in custom “My Sheets”

 

Workday Research Admin Dashboard (RAD) – read more detail here(PLEASE INSERT LINK)
  • NEW! Payroll Costing by Fiscal Period
  • NEW! Clinical Trial Balances for School of Medicine
  • NEW! SAFM Obligations:  Obligations on Stipends, Tuition Remission and Health Insurance are now pulled from SAFM
  • Bug fix:  Capture missing Grant To/From Dates and Multiple Grant Managers

 

 

UBI

Enhancements to UBI Reports:

Workday Journal Lines (Available in Production on Monday 3/13)
  • Journal Lines Detail Sheet
    • Journal Source filter added
    • Current FY Flag field added to more easily filter Obligations so that only the current fiscal year budget dates are included in the results
    • Last Updated Date added to the table for additional searchabilty
    • Estimated F&A Amount added for Commitments and Obligations
    • Corrected the formatting of the Budget Date to fix issue where dates may have appeared twice in the filter pane
  • NEW! Obligations Summary by Reporting Date Sheet
    • This new sheet delivers a more streamlined view of Obligations by Fiscal Period and includes estimated F&A.  You can copy this sheet to add additional worktags as needed.
  • Selections Sheet
    • Added Grant Ref ID back to the Grant filter pane
  • General
    • Reloaded data to capture corrected MFS Project allocation data from Workday that was processed in January.

 

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

 

Coming Soon:

Worker Costing Allocation Information – Payroll:  Collaborating with the People Analytics team to overhaul this report and improve functionality and address some open requests/issues.  We will be deprecating a number of obsolete payroll costing reports.  More details to be shared when the new report is ready.  Targeted for the week of 3/20.

 

Curious about what Finance reports people use the most?

Here are the usage stats for a recent 7 days in Workday:

 

Graphical user interface

Description automatically generated with medium confidence

 

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

 

Workday

 

ICYMI:  New Simple “BBA” Report for Expense Budget vs. Actuals (PLEASE INSERT LINK)

 

Significant Workday Reporting Updates:

No Significant updates to general use Workday reports this month.  Most work has been targeted bug fixes and enhancements supporting OSP and Central Finance use cases.

 

Quick Tip of the Month:

Saved Filters (Workday) and Bookmarks (UBI) – remember that if you regularly the same report with the same filter(s) for CC, Grants, or other worktags, you can save your filters using the Saved Filters option in Workday or using Bookmarks in UBI.  Bookmarks in UBI can be shared, Saved Filters in Workday cannot.  As a best practice, you should leave the Period prompt empty when you save since you will likely need to update that from month to month anyway.  Directions on how to use Saved Filters and Bookmarks can be found in the Reporting Training Resources.

 

February 9, 2023

FEBRUARY 9 Release Notes

Finance Reporting and Analytics Release Notes for February 9th.   This update includes significant new reports and modifications that have been released since January 12th 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: 

Business Intelligence & Analytics | UVA Finance (virginia.edu)

 

 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.

  Items in UBI currently under review or development:

Workday Journal Lines
  • Adding F&A Commitments & Obligations
  • Greater detail in Expenditure Comment field
Workday Budget vs Actuals
  • Adding F&A Commitments & Obligations
COMING SOON! - Workday RAD (Research Admin Dashboard)
  • Payroll Costing/Obligations by Fiscal Period
  • Clinical Trial Revenue
  • SAFM data integration
  • Grant To/From Dates correction
  • Multiple Grant Managers

 

 New Apps/Reports added to UBI:

  • none
Workday Journal Lines
  • NEW!  Suspense Analysis:  This is a new Community Sheet that you can use to identify open Suspense Balances that need to be cleared.  Thanks to Amanda Doherty in School of Education and Human Development for the suggestion.
  • Update to add Default Cost Center to Awards

  UBI

Enhancements to UBI 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

 

Coming Soon:

Worker Costing Allocation Information – Payroll:  Collaborating with the People Analytics team to overhaul this report and improve functionality and address some open requests/issues.  We will be deprecating a number of obsolete payroll costing reports.  More details to be shared when the new report is ready.

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

 Workday

Significant Workday Reporting Updates:

NEW!  Expense Budget vs Actual (Simple "BBA")
  • This new Budget Variance report provides a simple view of Expenses in format that is modeled on the old “BBA report” in UBI and Recon@.  It shows the fiscal year Budget, MTD and YTD Actuals, open Commitments & Obligations, and a variance by Spend Line Item and Category.  You can use prompts to run by any combination of Worktags.  All amounts are drillable to see the details or slice and dice by additional attributes.
  • This report was designed with input from our Fiscal Administrator Reporting Focus Group and provides a simple budget management tool for anyone who is responsible for managing expenses to a budget.
  • This report only includes transactions charged to a Spend Category
NEW!  Open Purchase Orders
  • This report will return all Purchase Orders in Workday that are NOT in a Closed, Cancelled, or Denied status.
  • Report includes Invoicing status and invoiced amount for each PO Line.
  • The report can be filtered by date, invoicing status, buyer, supplier, submitted by as well as any combination of worktags
Account Certifications Awaiting Me
  • Added a new field:  Awaiting Persons - Excluding Delegates
Status of Account Certifications
  • Updated to correctly show Awaiting Persons/Statuses for items that are “Sent Back” 
Bug fixes and minor enhancements
  • Expendable Fund Balance Summary: Added Memo Field to the Drill-through options
  • F&A Recovery by Company and Cost Rate Type: Updated calculations
Numerous reconciliation and invoicing support reports for OSP Numerous other minor enhancements and defect resolutions

 

Quick Tips of the Month:

When using the Prompt fields in Workday reports, you can quickly do a multi-select of your search results by using Crtl-A then Enter to select all available values. To speed up the search when using the Worktags prompt field, type in the worktag prefix or Worktag field name along with the value you are looking for.  For example, if I know that I want to select the MBU level for Batten, I can search “CH4 Batten” or if I know my Grant name contains “Electron” but don’t know the ID, search “Grant Electron” instead of just “Electron”.
January 12, 2023

General Note on Obligations reporting in Fund Balance or Budget vs Actuals reports:

The default Ending Budget Date prompt is set to 6/30/23 however this will include the final FY payroll for 12-month Faculty that is deferred until July of the new fiscal year.  You can set the Ending Budget Date to 6/22/23 to prevent this.  We are looking into options for other ways to account for this, but that is the current solution.

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

Workday

Significant Workday Reporting Updates:

                · Project Funding Source

                              ○ This is a new report that shows Funding Source(s) with dates, worktags, funding amount, and available balances

                · Fund Balance Report

                              ○ Through collaboration between the Accounting, FP&A, and Treasury teams we have settled on the fund and ledger accounts that are included in Expendable Fund Balances. Expendable Fund Balance is the new version of the "Cash Balance Summary Report" that we had in UBI for Oracle. 

                                  § The Fund Balance reports (by Cost Center, by Assignee, by FDM) in Workday have a new column called "YTD Other" that will include any current year activity on the balance sheet that impacts the Expendable Fund Balance

                                  § These reports display the Current Expendable Fund Balance Summary (Balance Sheet and FYTD Activity)

                                         □ Expendable Fund Balance Summary (this report will be used by Treasury to monitor MBU balances for policy compliance)

                                         □ Fund Balance Comparison by Ledger Account - this report will allow you to compare the Trial Balance to Expendable Fund Balance

                               ○ UBI Workday Fund Balance app is now available in Production

                                    § You can use the Fund Balances by Ledger or Fund Balances by Fund sheets in the UBI app to see which ledger accounts and/or funds are included in the Expendable Fund Balance rollup.  

                · Bug fixes and minor enhancements

                              ○ F&A Recovery by Company and Cost Rate Type: corrected the F&A rate to pull   correct value

                              ○ Customer Payments: Added Customer Invoice Memo field

                              ○ Worker Costing Allocation Information - Payroll:  Fixed prompt screen so you can now select by Position Cost Center Hierarchy

                              ○ Miscellaneous Payment Request Report: Added Cancel Accounting Date

                · Numerous other minor enhancements and defect resolutions

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:

                · Workday Budget vs Actuals

                                ○ Corrected Obligations calculation when prior periods are selected

                               

New Apps/Reports added to UBI:

                · Workday Fund Balance

                           ○ This UBI app replaces the "Cash Balance Summary Report" that we had in UBI for Oracle.

Items in UBI currently under review or development:

                · Workday Account Certification Dashboard

                                ○ Correct the values in the Approval fields when items are sent back

                · Workday Journal Lines

                                ○ Greater detail in Expenditure Comment field

                · Workday Budget vs Actuals

                                ○ Add Employee/Position information

                · Workday Delegations (On Hold - pending approval to release)

                · Workday Payroll Costing

                                ○ Missing employees without costing allocations

                                ○ Add Position Restrictions

                · Workday RAD (Research Admin Dashboard)

                                ○ Payroll Costing/Obligations reporting improvements

                                ○ Clinical Trial Revenue

                                ○ SAFM data integration

                                ○ PI access

                                ○ Grant To/From Dates correction

                                ○ Multiple Grant Managers

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.

20476