Report Development

• Enable searching of all hierarchy levels on all reports

• Repeating Fund number in Excel output
• Additional Prompts for VSE Category and VSE SubCategory
• Add prompt for L3 FinU

Removing:

• Column and filter for business relationship
• Filter for Supplier Site

Adding:

• Columns for System Availability and Employment status

• Calculates amounts for Differential Income, ASSA, Campus Administrative Debit, Dean's Office Tax, and Department Tax, and compares them to the actual amounts charged.
• Calculates a projected project balance after all anticipated taxes have been charged.

Multiple exception reports are in development for use by central offices, the central reconciliation team, and departments to correct erroneous transactions in Oracle.  These include:

1. Transactions with different project in PPM vs GL - May 2023

Enhancements:

Exclude non-sponsored tasks where no budget has been entered
Exclude non-sponsored tasks that have ended and have a $0 balance
Add alternate view with directs/indirects broken out
Payroll Page: Add alternate view that summarizes payroll by project

New columns have been added on the Project Overview report for the Fund and Function associated with the Task at project setup.

New column for Business Unit

• Four different options are available for the Project Summary:
  • With and without budget periods
  • With and without Tasks 
• The Award Anticipated Amount has been added to the top section for sponsored projects.  This amount is the total amount of the award for all budget periods as indicated in Kuali Research.
• The budget period end date has been changed to budget period range (Start -> End dates)
• When entering a date range for sponsored projects, you can choose whether that date range applies to the Accounting Date or the Expenditure Item Date.  When choosing Expenditure Item Date, Payroll Details are filtered by Earnings Period End Date.  Choose Expenditure Item Date to align costs with budget periods. 
• Added drillthrough to Transaction Details report on Expenditure by Month table.
• Future budget years are now excluded when running the report as of a date in the past.

• All reports on the dashboard now open in a new tab.
• A new view under Expenditure by Month by Type breaks costs down by Expenditure Type.
• Balances are now calculated as Budget – Costs.
• The Variances page includes a new table to help you identify discrepancies between award dates in Kuali and Oracle.

BPM Aged Items:

This report identifies the approval state/status of contracts, invoices, budgets, and project cost transfers. Worklist items become stale/stuck if not acted on in a timely manner.

Misc receipts on SP that might be wrong:

Sponsored Projects should have miscellaneous revenue posted as a credit to expense or applied towards an invoice. This report displays the miscellaneous receipt accounting and PPM accounting to reconcile and identify mismatches between the two modules.

• Expenditure Invoice Line Requester added to PPM Cost Transactions (PPM Full)
• PPM Commitments now excludes commitments where the total is $0
• Expenditure Item Date added to GL Transactions
• Two prompt updates:
  • New Fin Unit L2 (Entity Code) prompt
  • Expenditure Batch prompt now filters by the User Expenditure Batch field for PPM Transactions

This report allows users to:

1. Verify funding sources for payroll, tuition, fees, and stipends across multiple terms/years by graduate student, department, fin unit, and project.
2. Discern how a student is funded over their tenure as a graduate student.
3. View data as individual transactions, summary for each student by accounting period, or both.

1. PPM Cost Share Summary: Understand how much of committed cost share has been spent
2. GL Cost Share Summary: Understand whether cost share commitments have been funded to the project in the general ledger
3. Misposted Cost Share Transaction Details: Identify cost share transactions posted to the wrong funding source

• A new page on the project cost transfer panorama for “other adjustment status”
• Cost transfer workflow report is now searchable by the financial unit with a multi-select option.

New fields have been added on the Incoming Payments report for receipt type and creation method.

• Multi-select for Financial Units, Award Type, and project class code
• New prompt for Line of Credit

The following prompt has been added to this report: Project Manager Home Department

The UCPath-PPM-GL Salary Reconciliation report has been modified to account for Pay for Family Care and Bonding (PFCB).  PFCB salary is charged as normal salary in both the Labor Ledger (UCPath) and in Oracle, but is subsequently refunded to the Project in Oracle only.  This was creating artificial discrepancies on the Salary Reconciliation report.  

The PFCB salary amount from UCPath is now broken out into a separate column and is not included in the Variance calculation.  In cases where the refund occurred in a different month from the original salary, you will see a variance in the month of the salary and the opposite variance in the month of the refund.  

• New Project Organization prompt
• New Project Manager prompt
• Report excludes rows where all measures (e.g. beginning balances, YTD resources, YTD expenses, etc.) are $0

Enhancements:

• New pages: Commitment Details, PPM Condensed column set
• Select which page(s) to display (PPM Condensed, PPM Full, GL, Commitments) from the prompt page
• New columns: Transaction/Requisition/Invoice Approver, Created By, Last Updated By, Accounting Date, GL Posting Date, PPM Creation Date, Project Manager, Most Recent Accounting Period, Task Start and End Dates, Project Start Date, Expenditure Comment and PO number added to GL page
• New prompts: Expenditure Comment, Customer, Student PID, Managerial Account Category
• New drillthrough to identify recharge contacts
• Buttons to download a single page to Excel
• Columns with no data are excluded from the table

Enhancements:

• Add column for budget period start date
• Add award total row
• Drillthrough pages receive many of the same enhancements as for Expanded Project Summary

Enhancements:

• Search summary reports by PI (sponsored) or project manager (non-sponsored)
• New columns on Sponsored Contract and Project Summary: PI name, Sponsor Award Number, Sponsor Name, Commitments