Tagged: Finance and Supply Chain Reporting

New prompts have been added to "Find Expense Report Summary - OSU" and "Find Expense Report Details - OSU" that will allow both reports to be run by Approved Date. Additionally, "Find Expense Report Details - OSU" has been enhanced with a "Trackable Asset Lines Only" checkbox, allowing for easier tracking of this user selected field.

A new "Cost Center Assignable Roles - OSU" report is now available to assist in reviewing cost center level approver assignments. The report can be filtered by College/Unit Cost Center Hierarchy and where Cost Centers have no approver assignments for certain roles. This will assist with identifying where required role assignments are missing and would cause transactions to go unassigned.

The report can also be used to perform a general review of security assignments at the Cost Center/Cost Center Hierarchy level.

An upcoming logic update for the "Credit Card Transactions - OSU" report may result in some users losing their saved filters. Users with saved filters for the "Cost Center" and "Cost Center Hierarchy Level 6" prompts may be required to update their saved prompt filters. The logic is being updated on these fields to provide more accurate report results. 

The "Cost Center - FDM Values" report has been updated to include the Cost Center Manager(s) assigned to each specific cost center, if applicable. This report enhancement can help identify missing cost center manager security assignments. 

After identifying significant accounting issues with negative expense report balances since this original update was shared, a custom validation was added to prevent an expense report from being submitted with the Personal Expense checkbox selected.

In response to feedback regarding encumbrance logic, all financial reports (i.e. Sources and Uses suite, Equity Balances) will be updated to reflect the new encumbrance logic. The new logic will now be static in nature; once a fiscal period is closed the ending encumbrance number for the period will never change. The previous logic reflected fluid encumbrances and constantly updated. Expect the financial reports logic to be updated by July 29, 2022 (this does not affect grants reporting).

The Requisition Exception report is used to identify after the fact exceptions on requisitions. The report now only returns one row per approved requisition where "after the fact" is the requisition type. 

The prompt has also been enhanced to allow users to search for exceptions based on Cost Center Hierarchy Level 6,7, and 8. The dates on the report have also been corrected so users can run the report based on requisition approval dates as opposed to when a requisition was created.  

Enhancements for the Expense Report Exceptions report will be available in Production no later than August 1, 2022. The report has been enhanced to provide additional functionality and usability. The enhancements are listed below.

Three Workday reports, “Find Expense Reports - OSU,” “Find Expense Report Lines,” and “Find Expense Report Lines for Organization” will be decommissioned on August 31, 2022. 

These reports will be replaced by two new reports named “Find Expense Report Details - OSU” and “Find Expense Report Summary - OSU,” which will be available in Production the last week of July.