A new column has been added to the "Find Journal Lines - OSU - Posted Journals by Amount Type" report to display the Stock Request Number for journal lines with an Inventory Shipment journal source. This is to allow end users to trace a shipment back to the original requisition submitted for the order.
The "Find Transaction Summary Reports" report group has been created to help end users run multiple reports with a single set of prompts. This report group will render results for the summary report groups in the following areas: Requisitions, Spend Authorizations, Expense Report, Miscellaneous Payment Requests, Supplier Invoices, Supplier Invoice Requests, and Purchase Orders. The output of all these reports is compiled and downloaded into one Excel file for end user convenience. Pivot tables have been added on a tab in the Excel output summarizing the report statuses.
The changes described are scheduled to be moved to production during the week of Monday, October 7 . Based on user feedback, the "Sources and Uses – Variance Analysis" report was updated to provide a streamlined solution for viewing Actuals and Encumbrance columns side by side. Encumbrance and Pre-Encumbrance columns have been added alongside the existing Actuals and Plan columns. This will allow users to compare actuals and outstanding encumbrances to plan estimates in a seamless way. Additionally, new dynamic column headings were added to the report to provide greater clarity to the selections made at report runtime that drive the values in the Plan and Forecast columns.
A summary of these changes is listed in the full post. Questions or concerns with these updates can be sent to ctl-businessprocesses@osu.edu .
Below are details about recent and upcoming report changes.
Find Journals – OSU
The "Find Journals – OSU" report has been enhanced with two additional fields in the output of the report. The field names are "Cost Center" and "Worktags."
Report Retirement Reminder
The reports "Find Accounting Adjustments" and "Find Accounting Adjustment Lines for Organizations" will be retired on Friday, September 27 . The recommended replacement for these reports is "Accounting Adjustment Status - OSU."
Below are details about recent and upcoming report changes.
"Find Supplier Invoice Summary - OSU" Report
The "Find Supplier Invoice Summary – OSU" report has been enhanced with two additional fields in the output of the report. The field names are "Invoice Reference ID" and "Supplier Reference ID."
Coming Soon: "Accounting Adjustment Status - OSU"
A new report will soon be released to combine the existing reports "Find Accounting Adjustments" and "Find Accounting Adjustment Lines for Organization" into a single report titled "Accounting Adjustment Status - OSU." The new report will include output from both of the existing reports as well additional columns to help end users identify where in the business process the transaction is awaiting action.
With the release of the new report, the old reports will be retired effective Friday, September 27 . If you have saved filters on these reports, please be sure to save those fields on the new report.
Below are details about reporting changes in production as of July 29. See the full post where indicated for more specifics.
Business Assets Reporting:
The "OSU - Find Assets" report now features a new Asset Description prompt. This text field allows users to enter a description, returning assets that begin with the specified value. This enhancement streamlines the search process, ensuring more accurate and relevant asset retrieval.
Find FDM Requests Report and Security Enhancements:
The "Find FDM Requests" report has recently been enhanced to include a prompt for the Initiator's CCH6 as of the "Date Initiated" value. On the output of the report, the column "Initiator's Unit" has been replaced with the "Initiator's CCH6 as of Date Initiated." This change was made to help capture the correct CCH6 for which the request was entered even if the initiator no longer works in that unit.
Additionally, the security groups permitted access to run this report have been expanded to include the roles as listed in the full post . Please note, in order to see the request on the output of the report, users will need to have one of the security roles listed in the full post for the organization of the initiator. For example, if the initiator's organization is the company The Ohio State University, someone with the Cost Center Accountant role for that company will be able to view the request. However, someone with that same role but for the organization OSU Health System would not be able to view that request.
Below are details about reporting changes as of July 15. See the full post where indicated for more specifics.
Variance Analysis Reports Default Prompt Updates for Fiscal Year 25:
Due to the new fiscal year, multiple reports (as listed in the full post ) have had the "Budget Plan Name" and "Forecast Plan Name" default prompt values updated to reflect the new fiscal year. It is important to note that until the plan/forecast lines have been loaded into Workday no activity will show in the plan/forecast sections of the report. For more information on the timing of the plan line uploads reach out to your Senior Fiscal Officer or FP&A analyst.
Find Journal Lines – OSU - Posted Journals by Amount Type Enhancements:
The "Find Journal Lines – OSU - Posted Journals by Amount Type" report has been enhanced to provide additional operational insights for financial entries. A new prompt has been added for Supplier, which can be used to return journal lines which contain the prompted supplier on the journal line. Most commonly this will be from Supplier Invoice activity and includes external and internal suppliers. Expense Payee has been added to the output of the report. This returns the corresponding Expense Payee for Spend Authorization Cash Advance, and Expense Report journal activity.
The "UNIV Remaining Encumbrances - Requisitions, POs, Spend Authorizations" report will be enhanced to include a section for supplier contracts on the output of the report. This will include a column for the number of supplier contracts with remaining encumbrances as well as the obligation amount remaining. With this addition, the report name will be amended to "UNIV Remaining Encumbrances - Requisitions, POs, Spend Authorizations, Supplier Contracts."
Other changes include adjusting the default date to June 13, 2025 for the prompt "Spend Authorization Return Date On or Before." When drilling into the details on the output of the report, an additional column has been added for each transaction type. The transaction type and the corresponding drillable details column information is listed in the full post .
Enhancements have been made to the "Find Requisition Summary - OSU" and "Business Processes Awaiting Action - Requisition Detail" reports. New report fields that have been added to the output of each report are specific to requisitions with new supplier registrations. The new fields include those listed below.
Date First Email was Sent to Supplier Date Second Email was Sent to Supplier Date Application was Received from Supplier
Additionally, "Requisition Sourcing Buyer" has also been added to the output of the report "Business Processes Awaiting Action - Requisition Detail."
The Foundation Data Model (FDM) Translation Tool, which was utilized to convert PeopleSoft chartfield values into Workday values, will be decommissioned after July 31, 2024 . A new report called PeopleSoft to Workday Conversion Details (authentication required) is now available to financial users in the Reporting and Analytics Environment (RAE). This report provides the same information as the translation tool with more accuracy regarding the full worktag combination that was used during conversion. Read the full post for more details and how to obtain help accessing the report.
Effective Monday, June 3 , the Tableau report "Delegation History - OSU" has been enhanced to include the new fields and search features listed below.
A new field “Specified Business Process Types” has been added to the report. The new field groups business process delegations into the business process types of: Finance HR, Time Off, and Other. If a user has delegated all business processes for approval, then all four categories will display in the "Specified Business Process Types" field. If a user has delegated only certain business processes, then based on their delegation selections the field will populate only the corresponding process types. The “Specified Business Process Types” filter has also been added to the report.
The worker profile fields listed below were added to the report to provide additional transparency.
Delegating Worker Job Profile
Delegate Job Profile
The “For All Business Processes” field was removed from the filter section.
