The two reporting enhancements listed are now in production.
Find Miscellaneous Payment Request Summary – OSU - This report has been enhanced to include the Accounting Date, and Reconciliation Status as both a report prompt, and output field.
Find Expense Report Details – OSU - This report has been enhanced to include the Merchant Name transmitted to the bank for Expense Report lines associated with PCard Purchases.
As a result of user community feedback, the "Equity Balances by Balancing/Carry Forward Worktags" report will receive two updates.
A new column titled "Total Sources" will add the "GFA Activity (includes GFA original & net revisions & student reimbursement)" and the "YTD Sources/Other revenues-Transfers" together into a new column. The "Total Spendable Balance" will now add the "Beginning Balance," the "GFA Activity (includes GFA original & net revisions & student reimbursement)," and the "YTD Sources/Other revenues-Transfers" in columns together. It will also be moved to follow the newly created "Total Sources" column. Historically, the "Total Spendable Balance" only added the "Beginning Balance" and the "GFA Activity (includes GFA original & net revisions & student reimbursement)" columns together.
An enhancement has been made to the Sources and Uses suite of reports to allow users to select "book" when running a report.
Please note that if you have saved filters on this report you will need to ensure your report is running on the common book to return the results your saved filters would have normally returned. When you apply a saved filter the book default of common book will blank out. Please update your filters to select the common book if appropriate.
For any new report runs the most utilized book for decentral users remains the "common book" and this has been defaulted in the report prompt for user convenience.
An additional view has been created in the "Payroll Expense Details and Flexible Payroll Expense Data" to show hours associated with salary expense. The new tabs are called "Prepopulated Monthly Payroll Actuals (Hours and Amount)" and "Flexible Monthly Payroll Actuals (Hours and Amount)."
The Office of the Controller has compiled an inventory of available trainings for end users broken down by finance and supply chain areas. The inventory provides the course name with link, description of the course, security roles the trainings are recommended for and if the training is required or recommended. The inventory will be updated as courses are added or edits are made.
The "Find Internal Service Delivery Lines by Cost Center" report has been enhanced to help tie the operational activity to the General Ledger. A new date range prompt has been added to this report to allow for searching ISD activity based on Accounting Date. Revenue worktags and Accounting Date (as a column) have also been added to the output of this report.
Two new Miscellaneous Payment Request Reports as described below are now in Production.
Find Miscellaneous Payment Request Summary – OSU: This report returns Miscellaneous Payment Request data based on header information such as status, payee, and total amount and can be used for basic metrics and transaction status tracking.
Find Miscellaneous Payment Request Details – OSU: This report provides detailed information on Miscellaneous Payment Requests including header information as well as line details such as funding and item description details when applicable.
"Find Miscellaneous Payment Requests – OSU” will be decommissioned on September 30. This report will be replaced by the first two new reports previously mentioned.
Users with saved filters and worklet configurations for “Find Miscellaneous Payment Requests – OSU” are asked to delete them prior to the decommission date. Saved filters can be applied to the new reports.
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.
