The Modernization of Financial Reporting Project is rolling out sub-ledger dashboards during February and March. These Oracle Business Intelligence (OBI) dashboards will replace their respective content on the Finance Tab in CREW.
The sub-ledgers include Cash Management, Accounts Receivable and Procure-to-Pay (Accounts Payable).
Sub-ledger |
Run this OBI Dashboard |
If you used this CREW Report |
Business Description |
Procure-to-Pay (Accounts Payable) |
Committed Funds |
Committed Funds |
Open purchase orders with unspent balances. |
Vendor Invoice Detail |
HU Vendor Detail |
Invoice and payment information by vendor. |
|
Cash Management |
Escheat Due Diligence |
Escheat Due Diligence |
Used to research checks that have been outstanding (uncashed) for more than 6 months. |
Unclaimed Wires |
Unclaimed Wires |
Used by tub financial staff to review funds that have come into the Income Wire account to determine if they belong to the tub. |
|
Accounts Receivable |
Billing Detail |
Billing Summary |
To review a summarized history of transactions that affect a customer's invoices and on-account credits. |
Billing Detail |
To review a detailed history of transactions that affect a customer's invoices and on-account credits. |
||
Account Status Summary |
Account Status Summary |
Summary listing of all outstanding invoices at the summary level by Customer, Site and Invoice. |
|
AR Aging Balances |
Outstanding Customer Aging Sum |
To review outstanding accounts receivable balances by customer, broken down into 7 aging buckets (current plus six month past due categories). |
|
Past Due Invoices |
To review a summary listing of all past due invoices for given parameters. Most importantly, the report displays the amount that is outstanding and the number of days it is past due. |
||
Bad Debt Write-off and Recovery |
Bad Debt Recoveries |
Displays invoices written off to bad debt and subsequently paid. |
|
Bad Debt Write Off Report |
Provides local billing units with information needed to manage receivables and the related general ledger accounting. |
The timing of the roll-out to users will be determined by each school-based engagement council. Your local implementation manager can provide you with information on when you can expect content to be made available to your school.
To receive access to the OBI content, users must successfully complete a 45-minute tools training course. We are pleased to announce that an on-line OBI Tools Training option is now available to the user community. Users that prefer an instructor-led training session may register in PeopleSoft for course FSS170.
Earlier this month, the project team released updates to the CAPS content rolled out in December. The changes include:
Dashboard(s) |
Change |
External Team |
The “Company” prompt has been restricted to only include values for organizations that have projects. The prompt now filters out organizations that were set up but never associated with a project. |
Building Selected Data |
"Report Period" prompt changed to include the "Most Recent Opened Period" in the List of Values. |
Capital Renewal Spending (Building Portfolio page) |
Tonight, the project team plans to introduce another change that has been requested by many users and should enhance the “searching” experience. Today, when a user searches for a value, the default behavior is for “match case” to be selected. Going forward this box will be unchecked across the entire Oracle BI platform.
If you have any questions about the Modernization of Financial Reporting project, please contact your local implementation manager.