See the full post for more details about recent and upcoming reporting changes, including more specifics about the replacement reports for those being decommissioned on Friday, March 29.
Find Supplier Invoice Details - OSU Enhancements :
The "Find Supplier Invoice Details - OSU" report has been enhanced to include a column on the output of the report for the Unit Cost.
Credit Card Transactions - OSU Enhancements:
The report "Credit Card Transactions - OSU" has been enhanced to include two new columns. The report will now include the "Card Embossed Name" as well as the "Expense Report Approval Date" when applicable.
Enhancement to Asset Reports:
An enhancement has been made to the "OSU - Find Assets" and "Asset Physical Custody" reports. The output of these reports now display the field "Disposal Type" instead of "Disposal Method."
Business Processes Awaiting Action Suite Enhancements:
Two new columns have been added to the output of the "Business Processes Awaiting Action - Details" reports. The new fields include the "Created Date" and the "Total Amount."
Report Retirements:
On Friday, March 29 , the reports "In Progress Business Processes by Cost Center" and "In Progress Business Processes by Cost Center for Company Level Security" will be decommissioned. Specifics about the replacement reports for those being decommissioned are in the full post.
See the full post for more details about recent and upcoming reporting changes, including reports where users will need to update saved filters.
Find Supplier Invoice Request Summary and Detail Report Enhancements:
Enhancements have been made to both the "Find Supplier Invoice Request (SIR) Summary - OSU" and "Find Supplier Invoice Request (SIR) Detail - OSU" reports.
Coming Soon: Business Processes Awaiting Action Dashboard Changes:
To improve performance on the "Business Processes Awaiting Action" dashboard, changes will be made to the Requisition report on the dashboard.
Coming Soon: Saved Filters on Find Supplier Invoice Reporting:
On March 18 , changes will be made to prompts on the "Find Supplier Invoice Summary - OSU" and "Find Supplier Invoice Details - OSU" reports.
Coming Soon: Business Process Approval Times - Supplier Invoice Reporting:
To coincide with changes to workflow on supplier invoices, the Grants Operation Center Rep approval time will be added to both the "Business Approval Times - Supplier Invoice Summary" and "Business Process Approval Times - Supplier Invoice Detail" reports during the week of March 18 .
A new Tableau report is now available to end users in "Enterprise" folder. This report allows users to customize worktags for finance data. Users can select worktags from the column headings and they will remain displayed on the page. Users can select up to 10 custom columns and those can be filtered from the details pane. The report displays beginning balance, activity, and ending balances for the worktag combinations selected.
The report can be found using the path Finance and Supply Chain Domain > Financial Accounting/General Ledger > Financial Balances Summarization with Flexible Selectable Columns . For those with access, the Tableau link is https://dataviz.rae.osu.edu/#/workbooks/9485/views .
Coming Soon : Business Processes Awaiting Action – Journals:
Two new reports, "Business Processes Awaiting Action – Journal Summary" and "Business Processes Awaiting Action – Journal Detail" will soon be released to expand on the "Business Processes Awaiting Action" report suite. These two reports will also be added to the report group "Business Processes Awaiting Action Report Group" and the corresponding dashboard. This reporting will allow end users to locate journals that still have review and approval steps left in the business process.
Find Journals – OSU Enhancement:
The Workday report "Find Journals – OSU" has been updated to include the "Created Date" for the journal on the report output.
Internal Service Provider Billing Enhancements:
The report Internal Service Provider Billing has been enhanced to include additional worktag columns in the output of the report, due to changes to the EIB template. Those columns include Grant Treatment, Sponsor, CSI Code, Prevailing Wage, and Academic Period.
Find Purchase Order Summary – OSU Enhancements:
The report Find Purchase Order Summary – OSU has been enhanced to include additional columns on the output of the report. Those columns include Cost Center Hierarchy 6, Cost Center Hierarchy 7, Cost Center Hierarchy 8 and Cost Center.
Select Sources and Uses Reports Enhanced:
Select reports in the Sources and Uses suite of reports have been enhanced to provide a better experience for infrequent users of financial reports. A summary of the changes, and a list of enhanced reports is available in the full post.
A new series of reports has been released to help end users identify transactions that are still in draft status or have been submitted, but are pending approval steps. These reports also offer metrics to show the amount of time the transaction has been pending an approval step as well as length of time spent in progress. The business processes included in the new reports are Requisitions, Spend Authorizations, Expense Reports, Miscellaneous Payment Requests, Supplier Invoice Requests, Supplier Invoices and PO Change Orders.
There are two different styles of reports, a "Summary" version and a "Detail" version. The report naming conventions are "Business Processes Awaiting Action - (Transaction Type) Summary" or "Business Processes Awaiting Action - (Transaction Type) Detail." Additionally, a dashboard and a report group are available. Additional features are listed below.
The summary-style reports display the security groups awaiting action, number of transactions, days since assignment and days in progress. The detail-style reports display one row per transaction and include the security group and persons awaiting action, days since assignment and days in progress. Basic funding information is also displayed in this reporting. The dashboard, "Business Processes Awaiting Action - Finance/Supply Chain" displays all summary-style reports. The report group "Business Processes Awaiting Action Report Group" allows end users to enter one set of prompts and have all reports download into one Excel file.
A new report is now available for end users to view journal line detail on income statement reporting. The report "Find Journal Lines - OSU - Posted Journals by Amount Type" can be used to find the journal line details behind the data columns in reporting such as Equity Balances by Balancing/Carry Forward Worktags and Sources and Uses.
The Tableau "Financial Balances Summarization" report has been updated on "Project" field. Now, project and project phase code amount will be added in "Project" field.
Starting the week of January 29 , the “Find Supplier Invoice Details – OSU” report will be enhanced with a new "Line Memo" field in the output of the report. The line memo field includes details associated with a purchase for the line. Some internal billing teams are leveraging this field to provide additional clarity in the invoicing for their customers (e.g. tag number, date order was placed, order number, etc.) to verify the customer is billed for the correct record.
Enhancements have been added to the output of both the "Business Process Approval Times – Miscellaneous Payment Request Detail" and the "Business Process Approval Times – Miscellaneous Payment Request Summary" reports. The enhancements include a new column on the output of each report to display the approval time for the workflow step “Accountant OSP.” This approval step will be added into the Miscellaneous Payment Request workflow as a part of the petty cash project.
Business Process Approval Times – Supplier Invoice Request Reporting Enhancements:
Enhancements have been added to the output of both the "Business Process Approval Times – Supplier Invoice Request (SIR) Detail" and the "Business Process Approval Times – Supplier Invoice Request Summary" reports. The enhancements include two new columns on the output of each report, one to display the approval time for Business Operations Center Leads and one to display the approval time for Grants Operations Center Leads. These additions are due to the change in workflow on Supplier Invoice Requests where they now route to Service Center Leads on the SIR rather than routing for approval on the Supplier Invoice.
The Spend Report Exceptions Dashboard will be retired on Friday, December 29 . Please utilize the "Exceptions Dashboard" as it has the latest in exceptions reporting available. Alternatively, the "Schedule A Report" task can be used to run the "Exceptions Report Group." This allows users to run three exceptions reports with one set of prompts and all reports will be downloaded into one Excel file.
Miscellaneous Payment Enhancements:
"Find Miscellaneous Payment" reports have been updated with additional prompts to allow users to see information for their specific college or unit cost centers that must be recorded on OSP worktags as part of the cash advance for human subjects process. To view cash advances for human subjects on OSP grants associated with your specific college or unit, enter the Requester’s cost center or cost center hierarchy as of the date the Miscellaneous Payment was submitted. See further information in the Reporting Tip shared via the Business and Finance site.
