Tagged: Finance and Supply Chain Reporting

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. 

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. 

The "Cost Center - FDM Values" report has been updated to include the Cost Center Manager(s) assigned to each specific cost center, if applicable. This report enhancement can help identify missing cost center manager security assignments. 

After identifying significant accounting issues with negative expense report balances since this original update was shared, a custom validation was added to prevent an expense report from being submitted with the Personal Expense checkbox selected.