Report Development

The Transaction Type filter on the current Receivables Aging report is broken, and the report build is too clunky to fix the broken prompt.  We are hoping that a streamlined build will fix the existing issues, improve performance, and make ongoing maintenance more efficient.

Multiple reports are being created to support the new Fixed Assets Module:

• Asset Inventory Report
• Asset Depreciation Report
• Asset Retirements/Disposals Report
• Asset Purchasing Report

• Enable searching by Principal Investigator

• All prompts will have multi-select searches
• A new prompt filter and column for Employee Status will be added.

• A new column for Accounting Period End Date will be added.
• A new page for Financial Pivot Tools will be available on the GL Panorama

• A box for project notes will be added to the top of the report.  Stay tuned for announcements about training on how to enter notes so they appear correctly on the report!
• On-screen prompts will be added to filter the Cost Details by Expenditure Category and/or Expenditure Type, allowing users to narrow in on specific costs.
• A new prompt will be added to the prompt page to return all projects for a given award
• A link will be added above each table to enable Excel download of just that table.
• Columns will be added to the Revenue Details table for Receipt Amount and Unpaid Amount to enable users to see whether invoices have been paid.

• A new page for payroll projections will be added.
• A new column for project start date will be added to the sponsored projects section
• New columns for Project Manager and Fund Manager columns will be added to the Kuali-Oracle Comparison table

This new dashboard will provide department leaders with metrics related to faculty activity and productivity.

• Research expenditures by year
• Numbers of students, postdocs, and staff supported
• Numbers of proposals submitted and awards received

• The layout of the sponsored projects table is being changed to show only the current budget period, including the carryforward amount from prior budget periods as well as current period budget, costs, and balance for the whole task.
• The percentages shown on the sponsored projects table will be changed to Percent Budget Remaining and Percent Budget Period Remaining. The Percent Budget Remaining can be used directly as the carryforward percentage for NIH reporting.
• The GL summary table will be re-organized by project classification table to help faculty understand the purpose of each project.
• Multiple enhancements to increase functionality and usability of the drillthrough reports

The Budget and Finance User Group (BFG), including representatives from Audit & Management Advisory Services (AMAS) and Internal Controls & Accounting (ICA), has approved a change to the threshold of transactions that need to be reviewed with high-risk ledger review. The $2,500 threshold that has been applied to the total invoice dollar amount will now be applied at the transaction level. This will greatly reduce the number of transactions requiring review and simplify the monthly high-risk ledger review process.  This change is now reflected in the Transaction Details report.

Two new versions of the Gift Fund Balances report have been added to the Gift Funds Panorama to enable you to search the report by VSE Category and VSE Subcategory. Visit the Gift Fund Balances Blink page for more information.

Additional enhancements have also been made to the reports:

• Report output has now been limited to include only gift funds.
• The default view now repeats all rows rather than grouping financial unit and fund columns.  An alternate view is still available that includes the grouping.
• A prompt for L3 Financial Unit (School level) has been added.
• Financial unit and project numbers have been updated to a number-name format.

The Chart of Accounts Panorama has also been enhanced to include the entire hierarchies for VSE Category and VSE Subcategory so that you can review how all gift funds are categorized. Visit the Chart of Accounts Panorama Blink page for more information about these new hierachies added.

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

• The report provides a summary of a Fin Unit’s ending balances by fund, with information from the GL and PPM and drills down to the GL Project Balances report. For more information about this report, visit the GL Fund Balances Blink page.

• In order to prevent alumni employees from showing up on the report, only the following employee class types are included: "Academic: Academic Student", "Academic: Medical Residents", and "Student: Casual/Restricted"
• Two new prompts have been added: Hiring Department (returns payroll data only) and Expenditure Type
• Two additions to Summary Table: Fin Unit Code and Name and Admit Term Year. This table also now sorts by Fiscal Year.

• Sponsored Projects should have miscellaneous receipts posted as a credit to expense or applied towards an invoice.
• Sponsored project receipts should most often be posted and applied to an invoice, not as a credit to expense.
• This report highlights any credits to expense as a potential receipt that may need to be applied to an invoice.

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

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.

This report allows users to:

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

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.  

Enhancements:

Enhancements:

Enhancements: