Aggie Enterprise System Known Issues and Approved Change Requests
In Progress Log
This log tracks issues and approved change requests impacting Aggie Enterprise processes and reports.
- Finance, including PPM Projects
Area Summary Description and Workaround Status Created Date UCPath - Cost Transfer CBR and Vacation Accrual went to default Cost transfer file with the KFS Object Codes for CBR and Vacation Accrual went to default (this is for Jul-24). Batches impacted contain: 3897_240720B3X_00008791_COST_TRANSFER. This means that UCPath 339 report does not match Oracle. Units: Please do not make any adjustments, the central team is working on a plan to correct. In Process 7/19/24 Finance - Finance and Administration Offset Recovery (Offset) Error in the way Finance and Administration Offset Recovery (Offset) is recording in the General Ledger An error was detected in the way the Facilities and Administration Offset Recovery (Offset) records in the General Ledger. The Offset is used to centrally accumulate the total F&A being recorded on individual sponsored projects. The system has been incorrectly posting the Offset to the same Financial Department and Project where the F&A expense is posting. The Offset should have been recorded in the central Contracts and Grants Accounting Financial Department.
To fix this issue, a journal entry is being made to reverse the incorrect lines and post the corrected lines. This journal entry will be for the period January 2024 to April 2024. The entry is expected to post to Aggie Enterprise by 5/24/24.
Additionally, the accounting rules for posting future F&A transactions are being updated and will be put into production as soon as possible. At that point, an additional journal entry will be made to correct postings from May to the date the new accounting rules are implemented in the system.
7/8/24 update: Corrections for January - May posted, Corrections for June pending. 5/23/24 - Purchasing
Area Summary Description and Workaround Status Created Date Purchasing - Catalog Suppliers Not all previously available AggieBuy Catalogs are enabled While over 20 catalogs are available in Aggie Enterprise, not all previously available AggieBuy Catalogs are there yet. Catalogs are continuously being added.
See Supplier Catalog plan for details.
6/20/24: On-going, in process 1/4/24 Purchase Order (PO) Conversion No sales tax converted for open PO lines Due to complexity of extracting correct sales tax for only open purchase order lines from Kuali, converted POs in Aggie Enterprise do not include sales tax. When converted POs are invoiced, correct sales tax will be calculated by tax engine and will be paid based on zip code listed in PO and vendor charged tax. On-going for all converted POs 1/23/24 Catalog Orders Oracle defect randomly drops State field from electronic PO. There is a defect in Oracle that occasionally fails to transmit the State Abbreviation field with the electronic PO. Some suppliers have workarounds for this, but for some suppliers (including Dell and Amazon) this error causes the order to fail. There is no current workaround in these cases. When this occurs, a new order needs to be placed. 6/20/24: SCM is actively working on a solution. 6/4/24 Addresses One-time address use for campus locations may cause incorrect tax to be levied. Use of "One-time" address for campus locations may cause punch-out vendor to charge incorrect sales tax on invoices as system only allows "Internal" Addresses to carry postal code 95616-5270. 6/20/24: On-going. For campus locations, users should only use Internal addresses set in the system. If you’re unable to find your campus location in Aggie Enterprise, please reach out to SCM using the Aggie Enterprise help form and selecting the Purchasing subcategory. 6/4/24 - Accounts Payable
Area Summary Description and Workaround Status Created Date Accounts Payable – Invoicing on Converted POs Mapping of CoA/PPM on invoices of converted POs may not reflect desired mapping Purchase orders were converted based on the CoA/PPM rules that were established for go-live. The invoicing team is unable to update the existing accounting information.
In the event that these rules do not reflect the department's desired mapping, the recommended guidance is to reallocate the expense after the invoice is approved. This can be done through a journal or PPM cost transfer.- • Journal transfer - https://kb.ucdavis.edu/?id=09749
- • PPM cost transfer - https://kb.ucdavis.edu/?id=09580
On-going -Manual workaround required 1/22/24 - AggieExpense
Area Summary Description and Workaround Status Created Date Allocations PPM Project/Tasks missing or inaccurate. Approvers not updating for PPM Projects and Financial Departments. Some of the PPM Project updates and Financial Department approver updates in Aggie Enterprise are not loading into AggieExpense properly. This includes PPM approver updates, Task updates or additions, and updates to Financial Department approvers. Please email AggieExpense Help at expensehelp@ucdavis.eduto report the missing/incorrect information.
SCM is working with our Admin IT partners to resolve.
On-going -Manual workaround required 7/18/24 PCard reconciliation Incorrect use tax charged Use tax was charged on all taxable Expense Types even if the sales tax amount was added in the “Merchant Charged Sales Tax” field. If you find that your department was charged use tax when sales tax was already paid, please complete the Use Tax Accrual Correction Form and add “Due to system issue” in the Additional Information section. The fix for this issue was deployed on 05/30 and we are in the process of validating that it is working as intended. Resolved -Manual workaround required 6/4/24 Out of pocket reimbursements Chart of Accounts missing Program, GL project, and/or Activity values In most cases, out-of-pocket expenses defaulted the Program, GL Project, and Activity fields to all zeros, even if data was entered into AggieExpense. The other chart fields loaded correctly. If you need detailed information for your financial department’s activity to process corrective journal entries, please reach out to AggieExpense Help at expensehelp@ucdavis.edu.
Out-of-pocket expenses after May are loading all fields correctly into Aggie Enterprise.
Resolved -Manual workaround required 6/4/24 GLIDE Data Missing Transactions In the months following the launch of Aggie Enterprise, from 1/4/24 to 5/24/24, some transaction data did not transfer to GLIDE. If you need detailed information on these transactions, please reach out to AggieExpense Help at expensehelp@ucdavis.edu. Resolved - Manual workaround required 6/7/24 AEE-421 AggieExpense Unreconciled Direct Billings Report Missing Reconciled Transactions This report is no longer adding data after 4/10/24, and reconciled transactions are not being removed. Currently working on a fix 6/27/24 - Reports: Issues
Area Summary Description and Workaround Status Created Date Scheduled Reports Update to your scheduled report It is recommended that you update your scheduled reports if there are resolutions to defects or enhancements. Ongoing 5/13/24 FCCS Project Report Fixes reported defects Map new burden schedule names to indirect cost base codes Development UCD CA592 Tax Report Fixes reported defects Resolves missing and incorrect Withholding Taxes Development UCD PGM Master Data Report Fixes reported defects Isolate UCD Primary Ledger - As a result of the new Foundation Ledger, adjust report to only include UCD Primary Ledger = 300000008409485
Adjust the following (Multi) Select & Search parameters:
-Award Org - ensure Parent level values are available
-Project Org - ensure Parent level values are available
-Adjust the Report Output:
- Add a Report Name
- Add a Report Run Date
- Add all parameters with their associated selections
- Adjust report default (currently) to the right upon opening of export
- Adjust the following fields:
- Legal Entity - Retitle to Award Entity and adjust to the concatenation with the number and associated description (3110 - UC Davis Campus)
- Sponsor - ensure the number prefix in concatenation similar to prompt (i.e. K27420 - NATIONAL SCIENCE FOUNDATION)
- Add new field:
- Project Entity - ensure the concatenated number and description similar to requested above for Award - add field after Project Number and before Project PI
Development Purchase Order PDF Report Fixes reported defects Correct coding to resolve incorrect buyer detail on PDF Development Invoice Print Template (Receivables) Fixes reported defects Resolves PDFs cutting off and incorrect address information Development UCD PPM GL Cost Reconciliation Report Fixes reported defect Report times out when running and fails when scheduling Development UCD National Institute of Food and Agriculture (NIFA) (PPM) Report Split the file output to send information as 3 files There will be a separate project file with all the master data information on project task details along with Task DFF values for Non-Sponsored projects. This should also list the award against the project and NIFA Accession & Project Number for each entry where applicable.
There will be a separate file for master data of Awards – all details needed for awards.
There will be an expenditures file which can be linked via Project, Tasks, and Expenditure Item Date.
Each award personnel/project team player information should include the corresponding effective start and end date of the personnel/team player.
Testing UCD GL VIPER Detail Report and UCD GL VIPER Summary Report Adjusts Financial Department level parameter and add new fields Adjust Parameter:
-User needs to be able to run by Parent Level E Financial Department
Add New Fields:
-Vendor Name
-Report Key - currently the report only displays Purchasing Card transaction and user needs the detailed data
Testing ACH Remittance Report Remove Fields Removed columns from report Testing Balance Sheet Report Updates to mapping Corrects report code and format issues Requirements Department P&L Report Fixes reported defects Fixes drill-down feature and corrects reporting for PCARD & TCARD clearing accounts Requirements General Ledger Summary Report Fixes reported defects Fixes duplication in category mapping and corrects reporting for PCARD & TCARD clearing accounts Requirements UCD Faculty and Department Portfolio Report Fixes reported defects Add the following fields:
-Award Entity - after Award Name
-Project Entity - after Project Name
Requirements UCD All Users Audit Report Enhancement Request Add Parameter: Status (All, Active or Inactive)
Add or Modify Fields:
- Number (Person or Party Number)
- Category (User Category)
- Switch ‘Active’ field from Y or N to naming ‘Status’ referencing Active or Inactive
Order Report by User Name, then Role Names
Change Request - Reports: New Report Requests
Reports listed here have been approved for production and are in development.
Report Summary Status UCD PPM Budget History Report A new report to allow Project Managers and Functional Users to extract all historical budget details for projects or group of projects. This report will allow users to compare changes over time, and to ensure the GL balance for the project aligns with the PPM Project budget. Testing UCD GL Oracle to Lawson Details Report Get a daily transaction download report from Oracle that is a (by FAU-GL string) of Company 3210/10 and 3111 data.
Use this Oracle download to compare to a full download (by FAU-GL string) of Company 3210/10 and 3111 data out of Lawson.
Testing UCD Faculty and Department Portfolio Expense Report A report for reporting (Fiscal Year) Monthly expense detail at the Award, Project, and Task level. This will compliment the existing Faculty and Department Portfolio Report which provides Budget, Commitment, Expenses and Balances as of a given date. Requirements Phase UCD GL Income Statement Report Similar to UCD GL and Sub-ledger Reconciliation Report removing accounts 1XXXXX and 2XXXXX. Requirements Phase UCD Student Financial Aid Checks Report Student Accounting needs a report that shows the date in which their student federal aid checks have been cashed. Requirements Phase UCD Gift Accounting Report A new report for Accounting and Financial reporting that will pull active gift fee, revenue, expense, and endowment accounts which can be run monthly for posting allocations. Requirements Phase UCD Transaction Listing Detail Report UCD Transaction Listing Report does not display the actual document number from the source system. The request is to add the actual document number to the report output (eg if the JE source is AP, add the AP Invoice Number associated with the Journal Detail Line; or if the JE source is AR, add the AR Invoice Number associated with the Journal Detail Line; or if source is SCM, add the REQ number, PO number, Invoice Number, and Payment Number, etc) Requirements Phase
Resolved Log
Tracking issues that have been resolved, enhancements and user-facing change requests that have been implemented.
- Finance, including PPM Projects
Area Summary Description and Workaround Status Release Date PPM- Awards Some KFS Awards did not migrate to Aggie Enterprise There were Awards in KFS that should have migrated to Aggie Enterprise, but they did not. Team added those Awards into Aggie Enterprise, including migration of expenditures. Resolved 7/18/24 PPM - Projects> Project Financial Management> My Projects Error message Issue resolved. Fix applied 7/16/24 at 7:10pm.
Users are encountering the following error message when trying to open the Project Financial Management module:
'Error code: Association end PartyP of assoc NoteEOToPartyPEO invalid for entity base PartyPEO in view object NoteUIViewVO'
Resolved 7/16/24 PPM - Chart String Validation on Boundary Application transactions Awards with "Expired" status are being rejected preventing posting to the project/award. Boundary Systems can now submit Journal Requests via Aggie Enterprise Integration Platform without rejection when the Award status is "Expired" with an active Project. PPM Segment validation now recognizes "Active", "Under Amendment", "Hold", and "Expired" Award statuses for successful posting to respective projects. Resolved 7/15/24 PPM - Sponsored Project Award End Dates Converted Sponsored Project Award Close and Project Completion Dates being updated The UCPath I-370 COA Validation webservice has been updated to correct Entity Codes, PPM Department Kickout Logic and Labor Ledger Processing. This fix includes checks to Project Status, Award Status and Project End Dates, resulting in reduced kickouts to DKO projects moving forward.
As a reminder, users should regularly review transactions posted to DKO Projects using the Run PPM Department Kickout Project Balances Report and work to transfer costs to the appropriate PPM Project or GL.
Resolved 7/15/24 PPM - Cost Transfers Cost transfer posting inadvertently split posting for GL and PPM Cost transfers split, posting GL correctly to Period 12, and PPM erroneously posted to July (Period 1).
PPM postings will be reversed and posted to correct Period 12 by July 12, 2024.
Resolved 7/12/24 PPM - Manage Project Costs Applying the “Between” filter when setting the Accounting Period search parameters will deliver incorrect/ incomplete search results. When using the “Advance” search features on the Manage Project Costs screen, the system includes the option to select “Between” for Account Period search parameters.
There is a known issue in Oracle that results in incorrect/ incomplete search results when the “between” option is selected.Until a resolution is rolled out by Oracle, users should not use “Between” when setting the search parameters for Accounting Period in Manage Project Costs.
7/11/24: this is ongoing, an Idea has been submitted to Oracle (Idea Number: 556748); and customized version of Manage Project Costs report close to production.
Resolved 7/1/24 GL Revenue Transfer Journals Revenue Transfer journals for GL only recharges are auto-rejecting Units who submit recharge billing to GL only chart strings on their own using the UCD Revenue Transfer Journal process will have their journal auto-reject. This is expected to be fixed very quickly so please wait to submit your journal until the fix is completed.
If your journal has already auto-rejected you can resubmit the rejected journal after the fix (if you do not want to resubmit your journal for approval, then you should click Batch Actions and select the Delete option from the drop-down menu to delete the rejected journal).Implemented 1/23/24 PPM Projects Some PPM Projects were created in the GL, but not in the PPM subledger Analysis complete. Process for correction can be found in the PPM Project values missing from the PPM subledger knowledge article. Resolved 1/23/24 PPM Projects end dates PPM Projects end and close dates are incorrect During conversion some PPM Project end and close dates set to default, this impacts expense transactions and other activities associated with financial administration of a sponsored award.
An enhancement was applied to update end and close dates to correct date(s).
Implemented 1/26/24 TouchNet credit card feed processing (not a Banner issue) TouchNet credit card feed, for only those merchants that process directly to the ledger, was inaccurate. TouchNet daily credit card feed was inaccurate for those merchants that process directly to Aggie Enterprise ledger.
All transactions posted from the TouchNet Feed to the ledger have been reversed, and reloaded with correct amounts.
Resolved 1/26/24 PPM revenue acceptance for recharge revenue Boundary Systems unable to post recharge revenue to PPM non-sponsored project Change implemented to that allows Boundary Systems (BSYS) to post UCD Recharge Revenue to a PPM Internal (Faculty) Project. Implemented 2/9/24 PPM Non-Sponsored Projects Incorrect budget load during conversion The budgets loaded into PPM Non-Sponsored Projects are have a budget as of October close.
December 2023 close balances from KFS were loaded as PPM Budgets end-of-January, to ensure they match the converted budget balances in the GL. At that time, everything will be up-to-date from a conversion standpoint.
2/9/24: December budgets were loaded and validated
Related: CGA is working to process new and amended projects received after November 21st.
Resolved 2/10/24 Subaward processing Additional Fund and Natural Account parents An enhancement was implemented o comply with UCOP guidance and to allow new Subawards to be processed in the 1800B Fund groups.
Impacts all users as the update Cross-Validation Rule (CVR) will include additional Fund and Natural Account parents:
1800B - Special Site Appropriations B
1999B - Specific State Appropriations B
2000B - Contracts and Grants
Natural Account 53300B - Subcontract Services
Implemented 3/1/24 GL balances Incorrect carryforward balances posting to unit instead of central accounting financial departments Carryforward offsets erroneously posted to academic and administrative units instead of Central Office General Accounting. This may impact the available balances units are seeing at go-live.
In Feb. '24 a one-time process to support Correcting Chart String Balances (and PPM Budgets) Post Go-Live began, units submitted files for converted balance corrections including PPM budgets. On 4/29/24 GL conversion reclass corrections for converted balances were loaded into Aggie Enterprise.
Resolved 4/29/24 PPM Budgets Not all Chart of Accounts (CoA) mapping incorporated into converted balances/PPM Budgets for go-live In Feb. '24 a one-time process to support Correcting Chart String Balances (and PPM Budgets) Post Go-Live began, units submitted files for converted balance corrections including PPM budgets. On 4/29/24 GL conversion reclass corrections for converted balances were loaded into Aggie Enterprise.
It may be helpful to use the Inquire on Detail Balances tool in the General Accounting Dashboard to verify the balances.
Resolved 4/29/24 PPM Department Kick-Out (DKO) project Logic for PPM Department Kick-Out projects requires correction At go-live, there were cases where the Department Kick-Out (DKO) logic was not working as expected and transactions posted to DKO projects, including payroll transactions.
This issue impacted the DKO process and the UCPath Labor Ledger Processing (I-101 and I-370).
A fix was applied 5/8 to correct validation flow. The payroll workflow has been updated to utilize GL error workflow, which should reduce activity in DKO.
Note to Departments: You should review transactions hitting your DKO projects regularly; see Understanding DKO Projects and Transferring Costs out of DKO Projects KBA for additional guidance. Departments are responsible for moving costs off of DKO projects.
Implemented 5/8/24 - Gifts and Endowments
Area Summary Description and Workaround Status Release Date Foundation Funds Foundation Funds beginning with 6XXXX or 7XXXX were created in error and have been inactivated.
Central Accounting will research and address any balances on these funds.
Early on in conversion planning, Foundation funds were assigned 6xxxx and 7xxxx fund numbers. It was later decided to change them to alpha-numeric funds (See Understanding Gift Fund Value Structure KBA).
• Note: Past iterations of department mapping may have included the 6xxxx and 7xxxx Foundation funds, which have now been inactivated.In addition, Foundation provided a list of allocations that are inactive and should not have been brought over to Aggie Enterprise. In some cases, funds were set up for these allocations using the 6xxxx/7xxxx fund numbering (and then disabled in January). Departments have reported that there are KFS balances as of 12/31 for some of these allocations. Central Accounting will need to research and possibly create a new alpha-numeric fund so the balance can be transferred over.
For departments:
If you come across a balance in a 6XXXX or 7XXXX fund that has been inactivated, please submit a ticket to the Gift & Endowment team. Use the Aggie Enterprise Help Request Form, selecting the following:• Category: Transaction processing, general policy questions, functional support
• Functional subcategory: Accounting and Financial Reporting
• Topic: Gifts and Endowment AccountingResolved 7/18/24 - Purchasing
Area Summary Description and Workaround Status Release Date Invoices Subaward invoice routing missing approval step An enhancement has been applied to ensure that subaward invoices always route to both project manager (department approver) and then to PI before going out for payment. All subaward invoices must be approved by project manager and PI to ensure appropriate use of funds. Implemented 1/26/24 Purchase Orders (PO) Conversion POs mapped to some PPM projects did not convert 2/9/24 update: 81 of the 100 POs that did not initially convert have successfully been reloaded. 19 POs did not convert. At this point, the 19 will not be reloaded. If they are still valid and need to be in Aggie Enterprise, please process a Requisition and note in your request that this is an attempt to recreate a PO from KFS that did not convert. You would also want to make sure the vendor who will send the invoice to Aggie Enterprise is aware of the new PO number that is being created in the system. Resolved 2/9/24 Purchase Order PDF One Time Locations were not populating in Delivery section of PO PDF Issue resolved, Delivery addresses now populating in corresponding Delivery Address box on the PO PDF.
As a reminder, for Purchase Orders that are automatically created, with no buyer involvement, the resulting PO will need to be manually provided/emailed to the supplier once it is issued.
Resolved 2/12/24 Update "Edit Order" functionality Remove the "add" and "duplicate" options when trying to create a change order The "add" and "duplicate" options interfered with pre-populated procurement smart forms, causing incompletion Requisition lines to route to buyers. Removing these buttons eliminates the incomplete lines and improves turnaround time for PO processing. Implemented 2/23/24 - Accounts Payable
Area Summary Description and Workaround Status Created Date Accounts Payable - Payments ACH payments remittance emails not set up for all vendors At go-live not all vendors have ACH remittance email addresses set up in their records. AP and Supplier Services will continue working to add these emails so remittance notifications can go out to payees.
Vendors with questions on ACH payments should contact aphelp@ucdavis.eduResolved 04/08/24 - Reports
Area Summary Description and Workaround Status Release Date PPM UCD Faculty and Department Portfolio Report Project Manager and PI column data Approved change request to enhance PPM UCD Faculty and Department Portfolio. Future report will populate PI, Project Manager, and Co-PI columns. Implemented 1/12/24 PPM Accounts Receivable Invoice Detail Report Fields on Accounts Receivable Invoice Detail report - Collectors not appearing where expected Approved change to fix Customer Site amount due and collector's fields on the Accounts Receivable Invoice Detail report Implemented 1/12/24 GL Monitoring Report Report was timing out without reporting data Approved change implemented to fix run time and data report. Implemented 2/9/24 PPM UCD Faculty and Department Portfolio Report Budget Commitments and Actuals on the Summary tab are incorrect. Approved change implemented, summary totals now match detail report Implemented 2/9/24 GL Summary Report GL Summary Report was rounding to 1,000s Enhancement applied, now displays in whole dollars Implemented 2/9/24 UCD Transaction Listing Report UCD Transaction Listing Report was unable to be scheduled with an open-ended or future "to period" Enhancement applied, report can be scheduled without having to change parameters with every monthly period Implemented 2/9/24 VIPER Report All posted journals under the VHO department is displayed on this report Viper report will display GL Monthly and YTD actuals from the ledger by Level D (VHO) of the natural account
hierarchy based on selected parameters.Implemented 2/23/24 Purchase Order PDF Report Multiple defects fixed Logic changed to include restricted categories from Procurement Hierarchy instead of the restricted category value set
Update the stores replenishment order PO PDF to default to the scmstores@ucdavis.edu email for the Delivery Address and correctly reference the Department Contact
Implemented 2/29/24 UCD Inventory Item On-Hand Quantity Report New Report Creation of a report to view on hand quantities for stock items that are not set to systematically replenish Implemented 2/29/24 UCOP Financial Consolidation and Close Cloud Service Report Extracts Fixed Fix to the Department Report to include and exclude specific departments and re-sort the file.
Fix to the Projects Report to exclude future dated burden Schedules
Implemented 3/4/24 UCD Payables Report Multiple defects fixed Fixed multiple "Line Amount" for every "Project Task"
Line Amount is missing invoice distribution amounts
Report is not displaying 'Assessed Tax' amount in the Tax column
Implemented 3/14/24 UCD Requisition and Purchase Order Activity Report Time out issues when running report Optimized report for better run time. Implemented 3/14/24 UCD DE 542 Report Check Status adjusted Check status adjusted from NEGOTIABLE to excluding the following:
- Spoiled. The payment document was damaged during a payment batch and you have recorded it as Spoiled when you confirmed the payment batch. It is non-negotiable.
- Stop Initiated. You have initiated a stop payment on the check.
- Unconfirmed Set Up. The payment document was used as a set up check in a payment batch, and you have not yet confirmed the payment batch.
- Voided. You have voided the payment, and it is no longer valid for payment.
Implemented 3/14/24 Reporting Dashboard Multiple defects fixed Fixed the URL on the reporting dashboard to be dynamic
Resolve incorrect reference of UCD Request and PO activity report to show UCD Requisition and PO Activity Report
Implemented 3/14/24 UCD Requisition and Purchase Order Activity Report Add Customer Reference to the report Add Customer Reference to the report Implemented 3/14/24 UCD Drawdown Report Update code to use a new table Fixes UCD Drawdown Report - update code for new table as a result of the 23B change Implemented 3/28/24 UCD National Institute of Food and Agriculture (NIFA) Program Management (PGM) Report Update to the NIFA PGM Report Fixes UCD National Institute of Food and Agriculture (NIFA) Program Management (PGM) Report to disable bursting option Implemented 3/28/24 UCD Payables Report Multiple updates Resolve merging of cell data & moves export from Excel 2003 to RTF format
Added Accounting Date & Period parameters
Adjusted Project Task parameter & Report field
Implemented 4/4/24 AE Audit Report New Report New Aggie Enterprise Audit report to identify all active and inactive UC Davis employees Implemented 4/4/24 UCD National Institute of Food and Agriculture (NIFA) GL Report Update to the NIFA GL and GL Incremental Report Fixes UCD National Institute of Food and Agriculture General Ledger Report to include missing layout
Fixes UCD National Institute of Food and Agriculture General Ledger Incremental Report - Initial Load
Implemented 4/11/24 UCD Transfer Order Status Report Added new parameters and fields & changed field names Add New Parameters: Pick Slip Status, Pick List From Date, and Pick List To Date
Add New Fields: Pick List Status and Transfer Order Line Number
Renaming Fields: Fulfilled Quantity to Picked Quantity and Internal Requisition Quantity to Requested Quantity
Implemented 4/11/24 UCD Disbursement Positive Pay File Format Fix to resolve characters pushing columns out Added logic to replace all commas, quotations, and characters which are not allowed with a " " (blank) for formatting of transfer file (Invoice number, date from INVDESC, etc...) Implemented 4/18/24 General Ledger Summary Report Fixes the PTD reporting the same as YTD Adjustments to Period Activity parameter for PTD Implemented 4/18/24 UCD Payables Invoice Distribution Multiple fixes to the report Distribution Details for Invoices Failed to execute post 24A Release
Expenditure Organization & Project were blank for some lines
Segment Value missing from Project & Task
Implemented 4/18/24 Department P&L Report Fixes the PTD reporting the same as YTD Adjustments to Period Activity parameter for PTD Implemented 4/25/24 UCD Faculty and Department Portfolio Report Multiple fixes to the report Adjustment to parameters and fields
Resolves missing Project Manager information & SubQuery Error
Implemented 4/25/24 UCD PGM Master Data Report Requests adjustment to parameters and fields Adjust Award Organization parameter name to Award Org
Add the following (mulit) Select & Search parameters:
- Project Number - title Project Number
- Project Owning Organization - title Project Owning Org
- Project Principal Investigator - title Project PI
Adjust the following column names:
- Principal Investigator Person Name to Award PI
- Organization to Award Org
- Co-PI to Award Co-PI
Add the following columns:
- Project Principal Investigator - title Project PI
- Project Owning Organization - title Project Owning Org
- Project Fund
Reorder Report (post above changes)
Implemented 5/2/24 UCD Faculty and Department Portfolio Report Multiple Bug Fixes and Enhancements Bug Fixes:
-PM not showing up on reporting when run by PIEnhancements:
Add New Header:
- Report Run DateAdd New Parameter:
- Project Number
- Parent Project Owning Organization (to allow for Parent level searches)Modify Parameters:
- Project Manager (PM) move to a new parameter prompt, also adding Project Administrator as an option - title Project Admin/Project Mgr
- Principal Investigator/ Project Manager/ Co-PI rename to PI/Co-PIAdd New Fields:
- Project Administrator
- Award Status
- Project Status
- Task Status
- Budget Balance (Detail tab only)Modify Field:
- Budget Balance(Total Budget - Expenditures - Commitments) header on Summary tab rename to Budget Balance (Budget – (Comm & Exp))Implemented 5/9/24 UCD Transaction Listing Report Fixes reported defect Fixes merged cells Implemented 5/9/24 UCD Transaction Listing Report - GL and Subledger Detail New Report The report will provide users with Summary Chart of Account balances and information for sub-ledger and General Ledger journal entries Detail. Works toward an FISDS-1 Replacement. Released 5/21/24 CD Agreement Usage Report Fixes reported defect Fixes time zone issue Implemented 5/23/24 UCD Project Cost Reconciliation Report
Fixes reported defects Isolate Primary Ledger
Update to performance
Fix Layout to display correct output
Fix duplicate rows and incorrect data
Addition of multiple parameters:
-GL date range parameter
-Business Unit parameter
-Document Entry Type Parameter
-Rename existing and new parameter prompts appropriatelyImplemented 5/23/24 UCD IDC Report Fixes reported defects Resolves issues with duplicate and incorrect multiplies and incorrect reference of costs subject to indirect Implemented 5/30/24 UCD GL Balance Summary Report New Report Similar to UCD GL and Sub-ledger Reconciliation Report moving accounts from default Parents in balancing with the General Ledger Summary Report (i.e. 775xxx from Revenue to Expense, etc...). Released 5/30/24 UCD FTCR Quarterly Report New Report This Federal Cash Transaction report will provide the necessary information for completing the Federal Quarterly Reports. Federal Report requires Quarterly activity in addition to Cumulative to Date detail. Released 5/30/24 Cognos GLIDE Report Fixes Concur data missing from GLIDE Some PPM and ledger costs that posted successfully are not showing in the GLIDE reports for Jan, Feb and part of March 2024. The issue was fixed going forward, but the missing records could not be retro-actively loaded to the GLIDE report. The application most impacted was Concur, for journal batches that begin with the letters “sae.” SCM team has saved a spreadsheet at https://supplychain.ucdavis.edu/banking-card-program/glide-information that includes Concur data missing from GLIDE. Implemented 6/3/24 UCD Transaction Listing Report - GL and Subledger Detail Enhancement Request Add fields from original Transaction Listing Report used to identify GLIDE boundary applications: Document Type, Document Number, Tracking Number, and Reference.
Transaction Number prompt is actually a search for AP/AR Invoice Number which the prompt will be renamed in Phase 2 updates
Implemented 6/6/24 UCD Faculty and Department Portfolio Report Fixes reported defects Optimization of the report
Add the following fields:
-Adjust Include Task to Task Status and default of 'Active' back to 'All' for prompt
Implemented 6/10/24 Project Billing UCD Intercampus Request for Reimbursement (IRR) Invoice Template Fixes reported defects Replace signature name and stamp Implemented 6/27/24 Project Billing UCD Event Based Invoice Template Fixes reported defects Replace signature name and stamp Implemented 6/27/24 Project Billing UCD SF270 Template Fixes reported defects Replace signature name and stamp Implemented 6/27/24 Project Billing UCD General Contract and Grant Invoice Template Fixes reported defects Replace signature name and stamp Implemented 6/27/24 Wells Fargo File Fixes reported defects Formats logic to correct CR and LF characters Implemented 6/28/24 FCCS Funds Report Fixes reported defects Adjusts non-printable characters Implemented 7/10/24 FCCS Account Report Fixes reported defects Adjusts non-printable characters Implemented 7/10/24 FCCS Department Report Fixes reported defects Adjusts non-printable characters Implemented 7/10/24 FCCS Balance Report Fixes reported defects Adjusts non-printable characters and removes 0 balances from report Implemented 7/10/24 FCCS Project Report Fixes reported defects Update the logic for internally funded sponsored projects Implemented 7/10/24 - User Interface
Area Summary Description and Workaround Status Release Date Homepage layout Removed "Social" tile and left sidebar. To streamline homepage, removed the left sidebar, and "Social" tile. Removing "Social" drives users to seek support using established channels. Implemented 2/21/24
- Segmentor
Area Summary Description and Workaround Status Release Date UCPath PPM tab "Validate" button was not performing true validation. The validate button was returning successful chart strings regardless of possible issues. Resolved 03/25/24
POET PPM tab Chart string order at the bottom of the page. The POET PPM tab was displaying the chart string at the bottom in PTOEAF order, instead of POETAF.
Resolved 03/25/24