Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Updating HUB Subcontractor Payments on PARs onto COGNOS

...

STEP 1 - Gathering Info from PAR & Voucher

  1. Review paid invoices for PAR Report 
    1. For PMCS: Go to the "HUB PAR Reviews" → "Completed_Paid" Folder 

...

    1.  For CPC: Go to the "CPC HUB PAR" → "Review & Paid" → "Paid" Folder

STEP 2 - Archiving PAR Transactions 

  1. Find the data:

    ...

        1. From VP2 (Voucher):

    ...

        1. Purchase Order

    ...

        1. Number,

    ...

        1. Purchase Order Amount

    ...

        1. , and Payment Date 
        2. From PAR:  HUB Vendor Name, Texas VID

    ...

        1. and Total Amount Paid This Reporting Period 

    ...

        1. See example below:

    Image Modified

    Image Modified

    Voucher Example:

      • Purchase Order Number (PO NUMBER)- 20PSA02703
      • Purchase Order Amount (Amount)- $8586
      • Payment Date (Record Date)- 7/8/20

    PAR Form Example:

      • HUB Vendor Name (Subcontractor's Name) - Texas Geo Bore Geotechnical Drilling Services
      • Texas VID - 1901077596300
      • HUB Payment Amount (Total $ Amount Paid This reporting Period to Subcontractor) - $1718.00

    Notes:

    • working a month behind.  Prime received payment however reporting subcontracting paid out in previous month.  No true correlation between a and b
    • for future consideration add report month or other items that will additional identification (how many PARs did prime submit this month?)
    • add the EID in the notes and any details that will assist with assigning the payment

    4. Find the UT EID by searching on PointPlus. 

    •  Go to Point Plus.
    •  Enter Name into Vendor Search.
    •  Use the one with the HUB determination. 

    Image Removed

    Image Removed

    Image Removed

    Step 3 - Payment Entry into HUB Administration

    5. Now, go to the HUB Administration site. This site is available via UT Direct. Here is a link: https://utdirect.utexas.edu/hub/ 

    6. Click on "Subcontracting" on the left hand side. 

    Image Modified

    7. Click on "Add a New Transaction".

    Image Modified

    8. Enter in the highlighted fields. 

    Image Removed

    ...

    Image Added

    • The Payment Date is in the format of DD/MM/YYYY and it must be a date that has passed already

    ...

    • . . Entering first date of fiscal year 09/01/XXXX should bring back all payments made to prime in that year.

    9. Click on "Retrieve Vendors".

    ...


    Image Added


    10. A list of Purchase Orders will populate. Look under the "Original Amount".

    ...

     Apply payment to voucher closest to the report month.

    Image Modified

    11. This is the confirmation page you should see. 

    Image Modified

    ...

    System will take either the Contract Number/DTN or Purchase Order number.  Need to standardize to ensure payments are all gathered together for reporting purposes. PO Number will return all payments associated.  Contract Number DTN will only return that specific payment(s).  

    • Consult with IT if they can ensure the opposite number is saved on record.
    • Consult with IT if the deduct feature can be upgraded to show if subcontracting already attributed to that payment category

    Remember we are working with payments that actually occurred in previous month. 

    • Consult with IT to see if we can enter a retroactive payment date to coincide with the Report Month from the PAR

    You will have to use the search feature in the HUB Subcontracting Payment Entry portal to find the EID. 

    • Consult with IT to see if system can be upgraded to use State Issued VID for input or POINT Plus can accommodate a select feature from the search (if you search by name capability is there but does not point to HUB Subcontracting page)

    Double Checking Payments - You can also check to see if the payment has entered. 

    1. Click on "Subcontracting" on the left hand side and then "List Subcontracting Expenditures". 

    Image Modified

    2. Input the Payment Date. Click on "Payment Date" that's written in orange. 

    Image Modified

    Subcontractor payments will populate. If the data was inputted correctly, it will be there. 


    STEP 2 - Archiving PAR Transactions

    PAR information is kept in UT BOX.

    PMCS PAR Information can be found here

    Image Added

    Here you will enter:

    • Today's Date
    • PO Number
    • Document ID
    • PO Amount
    • HUB Vendor Name
    • HUB VID
    • Subcontracting Payment
    • Voucher Date

    White = To Be Completed

    Gray = Completed

    Yellow = Issue

    CPC PAR Information can be found here.