Effective the week of Monday, February 24 , the "Payroll Accounting Adjustment Status" report will have some enhancements made to its prompt functionality. First, this report will include "Initiated By" as a prompt. Secondly, the prompt functionality for Current Expense Worktags and Proposed Expense Worktags will change to look at what is entered in either prompt.
Below is a brief example using two PAAs.
Current worktags are in CC12345 and the proposed worktags are in CC45678. Current worktags are in CC45678 and the proposed worktags are in CC12345.
In the "Payroll Accounting Adjustment Status" report prompts, you can now enter CC12345 in the Current Expense Worktags and CC12345 in the Proposed Expense Worktags and BOTH of the PAAs listed above return. Prior to this change, you would have needed to run two separate reports to get the intended data--one report run where CC12345 was in the Current Expense Worktags and a second report run where CC12345 was in the Proposed Expense Worktags.
Effective the week of Monday, February 24 , a prompt for "Prior Worktags" will be added to the "Accounting Adjustment Status - OSU" report. This particular prompt will use the "or" logic so that if a value is entered in another prompt, such as Proposed Organization, the results will return adjustments that have the proposed organization OR the prior worktags entered in the prompt. This is similar to the change being implemented for Current Expense Worktags and Proposed Expense Worktags on the Payroll Accounting Adjustment Status report.
The specifc reports listed in the full post will be updated during the week of Monday, February 24 to enhance user ability to analyze expenses. Current state, these reports have the ability to expand directly from the ledger account value into all Spend Category detail lines. This update will group the Spend Categories into groupings determined in the All Spend Categories hierarchy. Reports will populate level 5 of this hierarchy with the ability to further expand to detail line items if needed. The hierarchy groupings can be viewed in the “Spend Categories – FDM Values" report.
Spend category hierarchies (level 5) will be updated to create logical groupings of expenses. These groupings will help provide a level of visibility that is inbetween the high-level Supplies and Services view, and the granular spend category level. Below are a few examples of logical expense groupings the changes will create.
Computer, Audiovisual, and Copying Services Maintenance and Repair Services Financial, Accounting, and Legal Services HVAC, Electrical and Electronic Components
Once the hierarchy changes are made, the "Sources and Uses - Variance Analysis" report will be updated to bring in the level 5 spend category hierarchies. This will allow you to expand supplies and services and view spend associated with the updated hierarchies. You will still have the option to drill/expand to view at the individual spend category level if you have the need.
Report Enhancement: Find Journal Lines – OSU - Posted Journals by Amount Type
The "Find Journal Lines – OSU - Posted Journals by Amount Type" report has been enhanced with an additional field for "Object Class" in the output of the report.
Grant - FDM Values Report Enhancements
The output of the report "Grant - FDM Values" has been enhanced to include four additional columns. Those columns include the Award Line From Date, Award Line To Date, Prime Sponsor Type, and Sponsor Type.
Supplier Contracts Prompt Added to Procurement Reporting
A "Supplier Contracts" prompt has been added to three reports to enable users to search by supplier contracts. The reports include "Find Supplier Invoice Summary - OSU," "Find Supplier Invoice Detail - OSU," and "Find Purchase Order Summary - OSU."
Find "Requisition Summary - OSU" Prompt Update
An update to the prompt "Supplier" on the "Find Requisition Summary - OSU" report is scheduled to take place at end of day on Friday, February 14. See the full post for more details.
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.
The Time Tracking Funding Overrides report has been updated so users can now search for worktag overrides for positions they own. This can be run each pay period to ensure biweekly workers have not erroneously entered worktag overrides on their timesheets. Payroll accounting adjustments should be processed to correct erroneous overrides.
Historically the report returned all workers with time entered but a new prompt titled "Only Include Time Blocks with Funding Overrides" will narrow results down to return only workers with worktag overrides.
As a reminder, the best option is to run the report by the "Organizations by Type" prompt to capture all the positions owned by your college or cost center.
The Tableau report "Flexible Payroll Expense Data" has been enhanced with the addition of a new tab titled "Flexible Payroll Actuals- Annual Trend." In this tab users can compare payroll spend data by fiscal year.
The Tableau report "Delegation History - OSU" has been updated with the enhancements described below.
A new "Stopped Date and Time" field has been added to the report. When the delegation is stopped for any reason before it's expected end date, the stopped date and time will now display in a new column. A new filter "For All Business Processes" has been added to the report. Additionally, the naming of two fields has been changed. "Allowed Action" has been changed to "Start on My Behalf." "Specified Business Processes" has been changed to "Approval on Behalf of Specified Business Processes." A clean-up has been done on the "Delegation Details" and "All Delegation History" to no longer display rows denoting when a worker is on leave and returns from leave. This reduces some unnecessary noise in the data.
