Known Issues and Approved Change Requests

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
  • AreaSummaryDescription and WorkaroundStatusCreated Date
    UCPath - Cost TransferCBR and Vacation Accrual went to defaultCost 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 Process7/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
  • AreaSummaryDescription and WorkaroundStatusCreated 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 process1/4/24
    Purchase Order (PO) ConversionNo sales tax converted for open PO linesDue 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 OrdersOracle 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
    AddressesOne-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
  • AreaSummaryDescription and WorkaroundStatusCreated Date
    Accounts Payable – Invoicing on Converted POsMapping 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.

    On-going -Manual workaround required1/22/24

     

  • AggieExpense
  • AreaSummaryDescription and WorkaroundStatusCreated Date
    AllocationsPPM 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 required7/18/24
    PCard reconciliationIncorrect use tax chargedUse 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 required6/4/24
    Out of pocket reimbursementsChart 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 required6/4/24
    GLIDE DataMissing TransactionsIn 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.eduResolved - Manual workaround required6/7/24
    AEE-421 AggieExpense Unreconciled Direct Billings Report Missing Reconciled TransactionsThis report is no longer adding data after 4/10/24, and reconciled transactions are not being removed. Currently working on a fix6/27/24

     

  • Reports: Issues
  • AreaSummaryDescription and WorkaroundStatusCreated Date
    Scheduled ReportsUpdate to your scheduled reportIt is recommended that you update your scheduled reports if there are resolutions to defects or enhancements. Ongoing5/13/24
    FCCS Project ReportFixes reported defectsMap new burden schedule names to indirect cost base codesDevelopment 
    UCD CA592 Tax ReportFixes reported defectsResolves missing and incorrect Withholding TaxesDevelopment 
    UCD PGM Master Data ReportFixes 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 ReportFixes reported defectsCorrect coding to resolve incorrect buyer detail on PDFDevelopment 
    Invoice Print Template (Receivables)Fixes reported defectsResolves PDFs cutting off and incorrect address informationDevelopment 
    UCD PPM GL Cost Reconciliation ReportFixes reported defectReport times out when running and fails when schedulingDevelopment 
    UCD National Institute of Food and Agriculture (NIFA) (PPM) ReportSplit 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 ReportAdjusts 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 ReportRemove FieldsRemoved columns from reportTesting 
    Balance Sheet ReportUpdates to mappingCorrects report code and format issuesRequirements 
    Department P&L ReportFixes reported defectsFixes drill-down feature and corrects reporting for PCARD & TCARD clearing accountsRequirements 
    General Ledger Summary ReportFixes reported defectsFixes duplication in category mapping and corrects reporting for PCARD & TCARD clearing accountsRequirements 
    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 ReportEnhancement 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. 
     

    ReportSummaryStatus
    UCD PPM Budget History ReportA 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 ReportA 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 ReportSimilar to UCD GL and Sub-ledger Reconciliation Report removing accounts 1XXXXX and 2XXXXX.Requirements Phase
    UCD Student Financial Aid Checks ReportStudent Accounting needs a report that shows the date in which their student federal aid checks have been cashed. Requirements Phase
    UCD Gift Accounting ReportA 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 ReportUCD 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
  • AreaSummaryDescription and WorkaroundStatusRelease Date
    PPM- AwardsSome KFS Awards did not migrate to Aggie EnterpriseThere 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. Resolved7/18/24
    PPM - Projects> Project Financial Management> My ProjectsError 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'

     Resolved7/16/24
    PPM - Chart String Validation on Boundary Application transactionsAwards 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.Resolved7/15/24
    PPM - Sponsored Project Award End DatesConverted 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.  

    Resolved7/15/24
    PPM - Cost TransfersCost 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. 

    Resolved7/12/24
    PPM - Manage Project CostsApplying 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.

    Search fields on Manage Project Costs screen with Box around the Accounting Period field.


    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. 

    Resolved7/1/24
    GL Revenue Transfer JournalsRevenue Transfer journals for GL only recharges are auto-rejectingUnits 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).
    Implemented1/23/24
    PPM ProjectsSome PPM Projects were created in the GL, but not in the PPM subledgerAnalysis complete. Process for correction can be found in the PPM Project values missing from the PPM subledger knowledge article.  Resolved1/23/24
    PPM Projects end datesPPM 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). 

    Implemented1/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.

    Resolved1/26/24
    PPM revenue acceptance for recharge revenueBoundary Systems unable to post recharge revenue to PPM non-sponsored projectChange implemented to that allows Boundary Systems (BSYS) to post UCD Recharge Revenue to a PPM Internal (Faculty) Project. Implemented2/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. 

    Resolved2/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

    Implemented3/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.

    Resolved4/29/24
    PPM BudgetsNot 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. 

    Resolved4/29/24
    PPM Department Kick-Out (DKO) projectLogic 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. 

    Implemented5/8/24

     

  • Gifts and Endowments
  • AreaSummaryDescription and WorkaroundStatusRelease 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 Accounting

    Resolved7/18/24
  • Purchasing
  • AreaSummaryDescription and WorkaroundStatusRelease Date
    InvoicesSubaward invoice routing missing approval stepAn 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.Implemented1/26/24
    Purchase Orders (PO) ConversionPOs mapped to some PPM projects did not convert2/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. Resolved2/9/24
    Purchase Order PDFOne 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.

    Resolved2/12/24
    Update "Edit Order" functionalityRemove the "add" and "duplicate" options when trying to create a change orderThe "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.Implemented2/23/24
  • Accounts Payable
  • AreaSummaryDescription and WorkaroundStatusCreated Date
    Accounts Payable - PaymentsACH payments remittance emails not set up for all vendorsAt 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.edu
    Resolved04/08/24
  • Reports
  • AreaSummaryDescription and WorkaroundStatusRelease Date
    PPM UCD Faculty and Department Portfolio ReportProject 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. Implemented1/12/24
    PPM Accounts Receivable Invoice Detail ReportFields on Accounts Receivable Invoice Detail report - Collectors not appearing where expectedApproved change to fix Customer Site amount due and collector's fields on the Accounts Receivable Invoice Detail reportImplemented1/12/24
    GL Monitoring ReportReport was timing out without reporting dataApproved change implemented to fix run time and data report.  Implemented2/9/24
    PPM UCD Faculty and Department Portfolio ReportBudget Commitments and Actuals on the Summary tab are incorrect.Approved change implemented, summary totals now match detail report Implemented2/9/24
    GL Summary ReportGL Summary Report was rounding to 1,000s Enhancement applied, now displays in whole dollarsImplemented2/9/24
    UCD Transaction Listing ReportUCD 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 periodImplemented2/9/24
    VIPER ReportAll posted journals under the VHO department is displayed on this reportViper report will display GL Monthly and YTD actuals from the ledger by Level D (VHO) of the natural account
    hierarchy based on selected parameters.
    Implemented2/23/24
    Purchase Order PDF ReportMultiple 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

    Implemented2/29/24
    UCD Inventory Item On-Hand Quantity ReportNew ReportCreation of a report to view on hand quantities for stock items that are not set to systematically replenishImplemented2/29/24
    UCOP Financial Consolidation and Close Cloud Service Report ExtractsFixed 

    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

    Implemented3/4/24
    UCD Payables ReportMultiple 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

    Implemented3/14/24
    UCD Requisition and Purchase Order Activity Report Time out issues when running reportOptimized report for better run time.  Implemented3/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.
    Implemented3/14/24
    Reporting DashboardMultiple 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

    Implemented3/14/24
    UCD Requisition and Purchase Order Activity Report Add Customer Reference to the reportAdd Customer Reference to the reportImplemented3/14/24
    UCD Drawdown ReportUpdate code to use a new tableFixes UCD Drawdown Report - update code for new table as a result of the 23B changeImplemented 3/28/24
    UCD National Institute of Food and Agriculture (NIFA) Program Management (PGM) ReportUpdate to the NIFA PGM ReportFixes UCD National Institute of Food and Agriculture (NIFA) Program Management (PGM) Report to disable bursting optionImplemented3/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

    Implemented4/4/24
    AE Audit ReportNew ReportNew Aggie Enterprise Audit report to identify all active and inactive UC Davis employeesImplemented4/4/24
    UCD National Institute of Food and Agriculture (NIFA) GL ReportUpdate 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

    Implemented4/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

    Implemented4/11/24
    UCD Disbursement Positive Pay File FormatFix to resolve characters pushing columns outAdded 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...)Implemented4/18/24 
    General Ledger Summary ReportFixes the PTD reporting the same as YTDAdjustments to Period Activity parameter for PTDImplemented4/18/24 
    UCD Payables Invoice DistributionMultiple 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

    Implemented4/18/24
    Department P&L ReportFixes the PTD reporting the same as YTDAdjustments to Period Activity parameter for PTDImplemented4/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

    Implemented4/25/24
    UCD PGM Master Data ReportRequests 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)

    Implemented5/2/24
    UCD Faculty and Department Portfolio ReportMultiple Bug Fixes and Enhancements 

    Bug Fixes:
    -PM not showing up on reporting when run by PI

    Enhancements:
    Add New Header:
    - Report Run Date

    Add 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-PI

    Add 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))

    Implemented5/9/24 
    UCD Transaction Listing ReportFixes reported defectFixes merged cellsImplemented5/9/24
    UCD Transaction Listing Report - GL and Subledger Detail New ReportThe 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.Released5/21/24
    CD Agreement Usage ReportFixes reported defectFixes time zone issueImplemented5/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 appropriately

    Implemented5/23/24
    UCD IDC ReportFixes reported defectsResolves issues with duplicate and incorrect multiplies and incorrect reference of costs subject to indirectImplemented5/30/24
    UCD GL Balance Summary ReportNew ReportSimilar 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...).Released5/30/24
    UCD FTCR Quarterly ReportNew ReportThis 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.Released5/30/24
    Cognos GLIDE ReportFixes Concur data missing from GLIDESome 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.Implemented6/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

    Implemented6/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

    •  
    Implemented6/10/24
    Project Billing UCD Intercampus Request for Reimbursement (IRR) Invoice TemplateFixes reported defectsReplace signature name and stamp Implemented6/27/24
    Project Billing UCD Event Based Invoice TemplateFixes reported defectsReplace signature name and stamp Implemented6/27/24
    Project Billing UCD SF270 TemplateFixes reported defectsReplace signature name and stamp Implemented6/27/24
    Project Billing UCD General Contract and Grant Invoice TemplateFixes reported defectsReplace signature name and stamp Implemented6/27/24
    Wells Fargo FileFixes reported defectsFormats logic to correct CR and LF charactersImplemented6/28/24
    FCCS Funds ReportFixes reported defectsAdjusts non-printable charactersImplemented7/10/24
    FCCS Account ReportFixes reported defectsAdjusts non-printable charactersImplemented7/10/24
    FCCS Department ReportFixes reported defectsAdjusts non-printable charactersImplemented7/10/24
    FCCS Balance ReportFixes reported defectsAdjusts non-printable characters and removes 0 balances from reportImplemented7/10/24
    FCCS Project ReportFixes reported defectsUpdate the logic for internally funded sponsored projectsImplemented7/10/24
  • User Interface
  • AreaSummaryDescription and WorkaroundStatusRelease Date
    Homepage layoutRemoved "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
  • AreaSummaryDescription and WorkaroundStatusRelease 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 tabChart 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.

     

    Resolved03/25/24