Using the Unit Defined Commitments Load Template

Overview

Departments can record revenue and expense commitments using the Unit Defined Commitments functionality in M-Pathways. This document contains three sections that, when used consecutively, allow units to upload new commitments into or update existing commitments in M-Pathways using an Excel spreadsheet template. This method is best used when adding and/or updating multiple commitments.

Additional information is located in the following sections:

Navigation

Open the Unit Defined Commitments Load Template, which is available on the following website: http://www.mais.umich.edu/fin/commitments.html.

NavBar > Navigator > General Ledger > Unit Defined Commitments > Load UDC File

Step-by-Step Process

Creating the data file

  1. If the Security Warning message displays, click Options.
  2. Click Enable this content.
  3. Click OK.
  4. Enter UMICH in the Business Unit field.

    Note: UMICH is the only acceptable value for this field.

  5. UDC Load Template

  6. For updates to existing UDCs, enter the UDC Commitment Number in the Commitment # field. For new UDCs, enter NEXT.

    Note: When updating a UDC for a sponsored project/grant (i.e., those beginning with F, N, or M), do not enter an IDC commitment (e.g., 123456A). Updating the direct cost UDC will automatically update the related IDC commitment.

  7. Enter applicable information in the following fields:
    • Reference
    • Begin Date
    • End/Pay Date
    • Description 1
    • Description 2
    • Notes

    Note: Required fields and field formats are noted on the template.

  8. Scroll right to complete the commitment.
  9. Enter applicable ChartField information in the following fields:
    • Fund
    • Deptid
    • Program
    • Proj/Grt
    • Account

    Note: Revenues are entered as negative amounts (credits). Expenses are entered as positive amounts (debits).

    UDC Load Template

  10. Enter the dollar amount of the commitment in the Amount field.
  11. Repeat steps 4 – 9 for each commitment.
  12. Click Create UD Commitments Load ASCII.

    Note: A macro process in the spreadsheet verifies that all required data has been entered.

  13. Enter the desired location for the data file and its name in the file path and name field.

    Notes:

    • You can save the data file to any folder on any network drive to which you have access.
    • The file name must end in .dat
  14. Click Ok.

Uploading the Data File to M-Pathways

This procedure assumes that you have an existing Run Control ID to run the upload process. If you do not, or you want to create a specific Run Control ID for the process, use the Add a New Value page to create it. For subsequent uploads, use the Find an Existing Value page and select the desired Run Control ID. See M-Pathways Run Control ID Information for more information.

  1. Click Search to view a list of your Run Control IDs.
  2. Click the link for the applicable Run Control ID in the Search Results grid.

    Notes:

    • If you only have one Run Control ID, the system automatically selects it when you click Search.
    • If you know your Run Control ID, select = (equal to) from the conditions drop-down list and enter your Run Control ID in the field.
  3. Click Attach.
  4. UDC Load Template

  5. Click Choose File and select the data file from the location in which you saved it.
  6. Process Scheduler Page, cont.

  7. Click Upload.
  8. Click Run.
  9. Process Scheduler Request

  10. Select PSUNX from the Server Name drop-down list.
  11. Process Scheduler Request

  12. Select the Type field value according to the type of computer you’re using.
    • MAC users: select Web
    • Windows users: select Window
  13. Click OK.

If you are a Windows user:

  1. The following status pop-up windows appear.
    • Queued
    • Processing
    • Success (or Error)
  2. Review the report using the field descriptions in the Verifying the Results of the Upload Process section for reference.

If you are a Mac user:

  1. Click Report Manager.
  2. Click the Administration tab.
  3. Click the Load Unit Defined Commitments link in the Description field to open the report.
  4. Review the report using the field descriptions in the Verifying the Results of the Upload Process section for reference.

The upload process results in an Error & Control Report that acts as a status report. For a successful upload, the report provides the Commitment # for the new commitments. For an unsuccessful upload, it shows which commitment rows in the data file contained errors.

Important Information

The report is automatically stored in your Report Manager, regardless of the run procedure you use. You can retrieve the report for up to 60 days after it is run. It is recommended that you save this report for your records, as it gives you the Commitment #s for new commitments. You can print it from the .pdf report window or save it to a folder on a computer drive to which you have access.

Verifying the Results of the Upload Process

The following information describes how to read the Error & Control Report. See the Troubleshooting UDC Upload Errors document in My LINC for more information.

UDC Load Template

Letter Field/Button Description
A Commitment rows

If the UDC load is successful, the commitment rows are displayed in the order they were entered on the UDC Load Template.

If the UDC load is unsuccessful, only the commitment rows containing errors appear on the report.
B Commit # Shows the assigned Commitment # (e.g., 123456) for a new unit defined commitment or the updated Commitment #. IDC Commitment #s (e.g., 123456A) are also listed below their associated UDC.
C Error/Status Description

If the UDC load is successful, one of two status descriptions appear:

  • New commitment inserted
  • Commitment updated
If the UDC load is unsuccessful, the error message(s) appears here.
D Transactions

The Transactions summary provides the following information:

  • Read indicates how many commitment rows were edited during the upload process.
  • Errors show the number of commitment rows that contained an error.
  • Inserted lists the number of new commitment rows that were successfully loaded into M-Pathways.
  • Updated lists the number of existing commitment rows that were successfully changed in M-Pathways.
E Status Message

If the UDC load is successful, the message is ***NO ERRORS – FILE LOADED***

If the UDC load is unsuccessful, the message is ***ERRORS – FILE NOT LOADED***

Related Reports

Summarized UDC data (and applicable IDC data) appears on the various financial reports, including:

  • Project/Grant Budget Status report (PBSR) shows your UDCs/IDCs for a particular sponsored project/grant.
    • In M-Reports, the Other Commitments column displays expense UDCs per Budget Category.
    • In M-Pathways, the Unit Defined Commitments column shows expense commitments per Budget Account/Category and revenue commitments on the Total Revenues line.
  • nVision Income Statement reports (mgln075a and mgln075d-variance report) have three rows at the bottom of the report: Revenue Commitments, Expense Commitments, and Adjusted Balance.
  • UM-Maintained BusinessObjects reports may also show UDC/IDC detail.
    • CMB Project Grant Budget Status with Estimates [FN01 FN05 FN06 PY01]
    • CMB Reporting Bdgt Ledger NonSponsored Reconciler by FundDeptPrgm [AR01 FN01 FN05 FN06 HR01 PY01]

Related Resources