Tagged: Finance and Supply Chain Reporting

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.

Coming Soon: Business Processes Awaiting Action – Journals:

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.

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:  

Spend Exceptions Dashboard Decommissioning:

The dashboard "Spend Report Exceptions" will be decommissioned on Friday, December 29. End users should utilize the new "Exceptions Dashboard" for viewing policy exceptions for requisitions, expense reports, and supplier invoice requests. A report group could also be scheduled for viewing exceptions. To run the report group, use the Schedule a Report task and enter "Exceptions Report Group" in the report name. The report group can be run in real time or scheduled for a later or reoccurring date. 

Cost Center - FDM Values Report:

In preparation for Position Control enhancements, a new "Central Review Required" field has been added to the output of the "Cost Center - FDM Values" report. This field will be used to identify whether a cost center will require central review within the job requisition business process.  

Find Purchase Order Summary - OSU: