How to Process Transactions in the RMP Recharge Application


Overview

This article describes how to process recharges transactions through the RMP Recharge Application. The RMP Recharge App is to be used for Recharge Operations, Recharge Mechanisms such as Auxiliaries, and Recording Differential Income and Equipment Depreciation. You can reference, KB0033794: RMP App Best Practices. Additionally, Cost Transfers should not be processed as a recharge; please see, KBA0033191: Cost Transfer Guide. Recharges are used to recover costs when one UCSD Department provides a service/product to another UCSD Department for a fee as an institutionally approved Sales and Service Activity  Recharge Cost Recovery, sometimes referred to as Internal Revenue or Recharge Income, is not reported the same way on Financial Statements as External Revenue nor is it recognized as Revenue. The credit for a Recharge is not accounted for as Revenue, but as Cost Recovery; negative Project Costs. 

Prerequisites

Essential Information

Next Steps

    1. Clearly bookmark the RMP DEV (test) site and the RMP PROD (live) sites.
      1. RMP DEV: https://rmp-webdev.ucsd.edu/rmp-recharge/charges  
      2. RMP PROD: https://rmp-web.ucsd.edu/rmp-recharge/charges
    2. Download the RMP Import Template, Save As, and populate content.
    3. Ensure you are on the correct tab before importing the file.
    4. Excel Import Batch:
      1. A unique identifier referenced in the RMP Recharge App only.
      2. Do not enter a generic name; recommended format is [Document Entry name] [Date] [Number], Example = HDH 2020-10-06 1 
      3. 35-character limit
    5. Charge Description:
      1. Description of what was charged.
      2. 200-character limit 
      3. Avoid special characters and formatting such as line breaks.
      4. Visible in OFC: Projects > Costs > Manage Project Costs > View > Columns > Add Comments column. Access to Manage Project Costs is dependent on role.
    6. Customer Project Number
    7. Customer Task Number 
    8. Customer Funding Source Number 
      1. Populate if Customer Project Number is sponsored, otherwise leave blank.
    9. Expenditure Type:
      1. Must be an exact match to what exists in Oracle. Reference the Expenditure Type Report.
        • Starting FY2023-24, Differential Income will use Expenditure type: 773002 - Department Tax (previously used Expenditure Type 774010 - Differential Income).
        • Equipment Depreciation will use Expenditure Type: 774010 - To/From Renew/Replace Equipment Reserves.
    10. Revenue Expenditure Type
      1. If blank, automatically defaults to 775000 - Recharge Income Self Supporting Activities – Credit 
        • Starting FY2023-24, Differential Income will use Expenditure type: 773002 - Department Tax (previously used Expenditure Type 774010 - Differential Income).
        • Equipment Depreciation will use Expenditure Type: 774010 - To/From Renew/Replace Equipment Reserves.
    11. Provider Project Number: Recharge organization’s Project Number
    12. Provider Task Number: Recharge organization’s Task Number
    13. Dollar Amount: Amount being charged to the customer
      1. Do not include leading dollar sign ($) 
    14. Service Date
      1. Date that good were provided or services were rendered. 
      2. Appears in Oracle as the Expenditure Date.
      3. MM/DD/YYYY format 
    15. From Import Charges From Excel, click Choose File to search for the file. Once loaded, select Import Charges, then Submit Active Charges to OFC. 
    16. Once the transaction shows as "Submitted" in the RMP App, validate that the batch was successfully loaded in Oracle. See How to Confirm Transactions in Oracle.

Transaction Verification & Reporting

  1. Manage Project Costs accessed through Oracle
    1. Access is dependent on having the UCSD GL Inquiry and Reporting JR role in Oracle. See KB0032240: How to request the GL Inquiry and Reporting Role. 
    2. Pathway: Projects > Costs > Tasklist (paper icon on the right menu) > Manage Project Costs 
    3. Select Advanced to search by Batch Name (use dropdown quantifier Contains), Transaction Number, Expenditure Type, etc.
    4. Optionally, save the Advanced search with Expenditure Batch quantifier changed so it's the default search. 
    5. Add desired fields (e.g., Comments) by clicking View dropdown > Columns 
  2. Project Information Lookup Panorama accessed through Business Analytics Hub
    1. Validate the Project/Task (and Funding Source) values.
  3. UCSD-BIP Project Costs Detail Report accessed through Business Analytics Hub
    1. The more criteria that can be provided, the faster the report will run (e.g., Transaction Source = UCSD RMP Recharge App).
    2. The report may take minutes to run; recommend running it and taking a break. 
  4. Unprocessed Transactions Report accessed through Reports & Analytics
    1. Export the data to filter and format; reference column: Document Entry
    2. A single transaction may be referenced multiple times, one per error. Note the Unprocessed Transaction Reference as the unique identifier of a transaction.
    3. Reference MCI Import File Best Practices and Error Handling.
      • Written for troubleshooting MCI file import, but some error messages/troubleshooting may apply. 
    4. Submit Service & Support ticket to request processing or deleting an unprocessed cost. 
  5.  Additional reports accessible through Business Analytics Hub: 
    1. UCSD-DSH Project Panorama (PPM Project Balances and GL Project Balances tabs)
    2. UCSD DSH Project Balances with Expenditure Dashboard
    3. Faculty and Researcher Panorama

Troubleshooting

  1. Confirm values such as Expenditure Type are an exact match to what exists in Oracle. E.g., no leading/trailing spaces, extra dashes, upper/lower case, misspellings, etc.
  2. Ensure the Project/Task (and Funding Source if project is sponsored) are valid and active.
    1. The Service Date cannot be after the Project/Task (or Award if Sponsored Project) end dates. If the Project/Task/Award has ended, backdate the Service Date if appropriate, or contact the customer to request new Project information.
  3. Review character limitations: Excel Import Batch (35 characters) and Charge Description (200 characters)
  4. If a transaction fails import to OFC, you have the option to edit by clicking on the pencil icon to correct the Charge Description, Customer POET values or Service Date.
    1. If a Funding Source was incorrectly included in the import, edit the failed transaction and search for the project number again, refreshing the values.
    2. All other values cannot be edited in the RMP Recharge App. Instead, correct the information on the import template and re-import. Failed transactions will remain in the interface, as they cannot be deleted at this time. 
    3. Once the correction has been made, change the status dropdown to Active and click Save. You can then resubmit all Active transactions by clicking Submit Active Charges to OFC.
  5. If reusing the Excel import file and manipulating data within the spreadsheet, the system may not realize rows are blank. A warning will reference requiring values in those rows . 
    1. The RMP Recharge App will only load the rows that are truly populated and will disregard fully blank rows. The warning can be disregarded if the correct transactions were successfully imported.
    2. Optional Solution: Ensure that content is fully cleared (data and formatting) from blank row. Alternatively, copy and paste the values only to a new template and re-import.
  6. To reverse charges that were successfully submitted to OFC:
    1. Example: Wrong amount referenced, wrong project information, submitted under the wrong RMP group/tab 
    2. Optional: Make a copy of the tab on the original import file to process the reversal. The system will import the information on the first tab only.
    3. Modify the import file:
      • Make Dollar Amounts negative values by adding a minus (-) sign 
      • Include additional information in the Charge Description as an explanation for the reversal.
      • Ensure the Excel Import Batch value is unique
    4. Upload the modified file, send to OFC. Confirm the reversal processed successfully by validating in OFC. 
    5. Import the corrected file or import the original file on the correct tab (be sure to move the desired tab to the first position). 
  7. If charges were imported to RMP Recharge App but not submitted to OFC under the wrong RMP Doc Entry/Group: 
    1. Use the same file, delete all but 1 charge, reimport (may need to copy and paste values into a new template). The RMP Recharge App will recognize the same batch ID and will delete all but the 1 remaining line, which you can then manually delete. Then import the original file on the correct tab. 
    2. Optionally, manually delete the Active charges individually via the trashcan icon.

Additional Information

Supplemental Guides

To submit a ticket regarding PPM File Submissions, select the following options:  

Questions?

If you need any additional assistance, please utilize the Community of Practice or submit a ticket here.