New Reports and Queries released in October 2018

RU GL 097 GL Combinations Report

(Navigation Path: Tools -> Reports and Analytics -> Shared Folders -> Custom -> RU Custom -> Reports -> ATC Reports)

The RU GL 097 GL Combinations Report has been created to identify enabled general ledger account combinations per the CVR rules under the Chart of Accounts Initiative. If the account combination is disabled, the report will show the cross validation rule(s) it violates.

 Units can use the report to identify combinations to use for:

  • journals entries and reconciliations
  • preventing rejections of requisitions in RU Marketplace
  • determining allowable department defaults and Employee Charging Instructions in PeopleSoft

Due to the high volume of data generated by this report, this report must be scheduled.


RU GL 099 Multi Year Trial Balance

(Navigation Path: Financial Reporting Center -> Search by Report Number)

The RU GL 099 Multi Year Trial Balance Report has been developed to show year over year ending balances by unit. It will display balances for the last three fiscal years based upon your selection of the accounting period parameter.

When you export this report to excel a tab will be created for each and every unit. We have also included a new option, “Expand All”, in the upper left corner of this report to expand all the accounts down to the child level with one single click. In addition, the “Expand All” option has been added to reports RU GL 075B through 080B BOG P&L reports.


RU P2P 005 Expense Audit Detail Report

(Navigation Path: Tools -> Reports and Analytics -> Shared Folders -> Custom -> RU Custom -> Reports -> PTP Reports)

The RU P2P 005 Expense Audit Detail Report will assist you with viewing Expense Reports for your U-D-O (Unit, Division and Organization). This report will display both the details and summary information.


Project F&A DFF Listing Query

(Navigation Path: Tools -> Reports and Analytics -> Shared Folders -> Custom -> RU Saved Queries -> Projects -> Sponsored Projects)

A new query entitled Project F&A DFF Listing has been created to assist you with viewing the F&A Credit U-D-O, F&A Credit Location and F&A Credit Business Line on the sponsored projects setup that will be used in the F&A revenue credit. Enter your project number(s) and the setup information about your project will be returned in this query.