The "Find Supplier Invoice Request (SIR) Summary - OSU" report will be enhanced with an additional set of date prompts.
Prompt "Supplier Invoice Request Completed Date on or After" and "Supplier Invoice Request Completed Date on or Before" fields are added which allows users to run the report by when the supplier invoice request completed consistent with other procurement reporting.
To facilitate ad-hoc financial reporting in Tableau, a new Tableau Data Source which contains Adaptive Operating plan lines data for UNIV from Workday has been created in the Reporting and Analytics Environment (RAE).
This data source will be updated as new plan lines are loaded in Workday. The Tableau Data Source name is Workday - Adaptive Operating Plan lines. This data source will be available to all Finance users who have access to this folder “Financial Accounting/General Ledger.” See the full post for the listing of data source items being loaded.
The "Plan Versus Actuals by Plan Worktag" and "Plan versus Actuals by Plan Worktag - With Ledger Account" reports have been enhanced with new dynamic column headings to provide greater clarity to the selections made at report runtime. Now instead of simply displaying "Plan," the column heading will display the Plan/Forecast Name that was selected at report runtime.
The "Find Purchase Order Details - OSU" reports has been updated to include two new fields for line level status details named "Purchase Order Line Status" and "Line is Cancelled" which provides insight to the statuses of specific Purchase Order Lines.
The "Find Purchase Order Summary - OSU" report has been updated to include the Purchase Order Reference ID Field. This field is can be used by Internal Service Providers to populate their EIB templates when processing credits on fully invoiced Purchase Order Lines.
During the months of November and December, multiple Procurement and Supply Chain reports will be enhanced to add a new prompt for "Projects." This prompt will provide additional search options on projects and is intended for areas managing large projects with multiple phases in Workday. See the full post for the list of affected reports and the date each report is expected to be updated.
A new report named "Business Processes Awaiting Action - Asset Detail" has been released to aid in locating where asset events are in workflow. This report displays one row per event awaiting action and will provide basic information about the asset as well as days awaiting action and days since assignment.
With the release of this new report, the older "Transactions in Progress - Asset Registrations and Transfers" report will be retired on Friday, November 15 .
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 .
