Tagged: Finance

Effective January 15, the sheet and report user interface within Adaptive Planning will be updated. The blue banner will be removed on all report and sheet pages and all search fields and data tables will have rounded corners. Additionally, the Add New button will move to a new location below the top menu bar on the report overview and sheet overview pages. The functionality on these pages will remain the same. See the image below to preview the new look.

A new report group, Financial Transactions Awaiting Action, has been released. This report includes three different reports that provide a list and the status of journal, accounting adjustment, and asset transactions that are awaiting an approval or to-do step. To run this report group, users can go to the "Schedule a Report" task and search for "Financial Transactions Awaiting Action." Once the prompts are entered and the report group runs, all reports will be available in one Excel spreadsheet. 

New prompts have been added to the "Find Suppliers - OSU" report. Users can now prompt on the "Last Updated On or After" and "Last Updated On or Before" dates. The "Last Updated Date" has also been added as a column on the output of the report. 

As of Friday, December 6, Workday validations will be placed in various spend business processes to ensure the cost of sales expenditure treatment worktag can only be utilized by approved university earnings operations (Funds FD120, FD121, FD122 and FD200). In addition, users will no longer be able to add ET101 to costing allocations, one-time payments, or period activity pay. 

As a reminder, use of the ET101 expenditure treatment drives the transaction accounting to the cost of sales ledger account (61020).

The Cost of Sales Spend Category (SC10258) will be inactivated for future use, as it does not meet the definition of spend category. ET101 plus the appropriate earnings fund value and an eligible spend category within the services, supplies, or fuel and fuel additives hierarchies should be used to designate cost of sales.

The "Financial Balances Summarization with flexible selectable columns" Tableau report has been enhanced with an additional tab for "Flexible columns Financial Balances Summary Yearly Trending."

The updates listed below have been made to PI Portal and Workday Grants Reporting to ensure data is accurate and in-sync. Questions about the changes can be directed to orhelpdesk@osu.edu.

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 RAE. The data source has loaded the items listed below.

• FY23 Autumn Forecast - UNIV
• FY23 Operating Plan - UNIV
• FY23 Spring Forecast - UNIV
• FY24 Autumn Forecast - UNIV
• FY24 Operating plan - UNIV
• FY24 Spring Forecast - UNIV
• FY24 Summer Forecast - UNIV
• FY25 Operating plan - UNIV
• FY25 Summer Forecast - UNIV

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.

Please send questions about these updates to ctl-businessprocesses@osu.edu

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.