iProcurement Online Requisition for HVPO
iProcurement is a self-service requisitioning software provided by Oracle as a module of the University's overall financial systems. A web based application, iProcurement allows departments to electronically create, submit and manage departmentally approved requests for issuing purchase orders.
In accordance with the University's Purchasing Policy, except certain goods and services covered by pre-established University wide contracts, all departments shall procure goods and services that are $5000 or greater through iProcurement.
If you have questions about iProcurement that you cannot find the answer below, please direct your inquiry to firstname.lastname@example.org.
Access to iProcurement
To gain access to the iProcurement system and entering requisitions, employees of the University of Guelph need to have a user account to the University's Oracle Financial Systems. The user account is different from the University's central email login.
Applying for New User Account:
- Go to https://www.uoguelph.ca/ccs/forms/finance-new-user-request.
- Click on the New User Link and enter your Central ID and Password.
- Follow the instructions pertaining to the Acceptable Use Policy.
- Next screen allows you to select the application(s) you would like access to.
- Submit this form to your Supervisor for approval.
- Supervisor is now responsible for approving the request.
- Once approved Financial Services will be notified to set the user up and will notify the end user when completed.
- Upon the first time log in, the new user will be prompted to change the password, and you are good to go.
Things to Know for New iProcurement Users:
- Your iProcurement account will be locked after 3 unsuccessful tries.
- If you need to reset your password, please contact purchasing helpdesk Ext. 56412.
- iProcurement system user name and password should be kept secure. All activities within the system under your account will bear your digital signature. Do not share your login information with others.
- Not all internet browsers are compatible with iProcurement. If you are experiencing technical difficulties logging into the system from the link above, please contact CCS helpdesk or your IT personnel for help.
Changing User Account:
- Go to https://www.uoguelph.ca/ccs/forms/finance-change-user-request.
- All steps are the same as for applying new user account except for the Acceptable Use Policy, it doesn’t exist in this process as it has already been accepted.
Revoking User Account:
- Go to https://www.uoguelph.ca/ccs/forms/finance-revoke-user-request.
- This request is initiated by the Supervisor, not the user.
- The Supervisor enters the name of the person that they would like to remove and then submits.
Checklist for Entering Requisition
Below is a checklist to be reviewed prior to the start of a requisition. If you answer yes to all these questions, you are ready to start entering the requisition.
1) Is the purchase approved by the procurement authority?
Every department has their own internal approval process and signing authority. You should ensure all purchases are approved according to your department's internal signing authority before entering the requisitions.
2) Is supplier set up in iProcurement?
To find out if a supplier is set up in iProcurement, log into iProcurement, go to the 1st screen of entering a Non-Catalog Request, using search button to see if you can find the supplier that you are looking for. If you can't, you need to submit a request to have the supplier set up.
3) Is the site a P site set up in iProcurement?
In the Non-Catalog screen, remove any default information in the Site field, use the search button to display all sites set up in the system. Check the address information on your quote or invoice to see if you can find them in the list of sites in iProcurement. If you do, check if the site name starts with P. If you can't find the address you are looking for or the site name doesn't start with P, email email@example.com to have a new site set up or have the site name changed to a P site.
4) Do we have all the supporting documents required for the designation?
Check if you have all the supporting documents required for the requisition and if all documents are properly signed. For information on what is required for a requisition, refer to Supporting Documents for Requisitions.
5) Are all the supporting documents in softcopy?
Are your supporting documents all in softcopy? If no, scan them and save them in a designated folder on your computer, such as the desktop, so you can easily attach them to the requisition when prompted by system.
6) Do we know if the order is for goods or services? Do we know if they should be entered as one time purchase or long term recurring purchase?
There are three item types in a requisition. They are:
- Goods billed by quantity
- This is for goods that supplier will likely invoice us by quantity and we are likely paying supplier by the quantity we receive. There is a good chance that supplier will invoice us several times, each invoice for a partial shipment, until the whole order is complete.
- Goods or services billed by amount
- This is the most versatile item type. The total amount of the order will be entered in the amount field. The unit price of the requisition will be single dollar of the selected currency. Supplier could invoice us for partial order or the whole order. We are able to pay supplier by whatever amount their invoice might be. This is to be used when we are not sure how the supplier will be invoicing us and we are not in a position to track the quantity of the delivery. This is also suitable for blanket orders that we will release multiple shipments over the term of the order and the release has no fixed pattern in terms of quantity or amount.
- Services billed by quantity
- This is for services that supplier will invoice us by incremental quantity. For example, supplier invoices us by the hours they commit to our project at an agreed hourly rate, or supplier invoices us every month for their monthly services at a fixed amount.
7) Do we know what the charge code (cost centre) is for the requisition?
All requisitions need the 26 digits charge code. Some requisitions might have multiple charge codes. Make sure we have the information which line item will be charged to which account code.
When a requisition line has splitting charge codes, which means multiple charges code will be sharing the cost of a line item, please make sure the percentage of cost sharing will not change throughout the term of the order. For example, if two charge codes will be sharing the cost at 50% each, then each invoice paid will be charged 50% to each charge code. You cannot change the invoice so that the percentage of sharing becomes 30% and 70% between the two charge codes. This is determined at the time when we set up the requisition.
If you are not sure if the percentage of cost sharing between different charge codes will remain consistent throughout the order, it is better to set up two separate lines where each line has its own charge code. You can then designate a particular line that an invoice should be paid against. When there is amount change for a particular charge code, you can always revise the line with the single charge code. Revising a line with multiple charge codes will affect all the charge codes.
8) Do we know when we need the goods or services? For a blanket order, do we know when the term starts and ends?
When we enter a requisition for an order that is to be delivered in the future, we often want to make sure the funds get committed at the time they are allocated. When we enter a requisition for a blanket order covering multiple fiscal years, we want to make sure the funds get committed only for the current year. A future required date would tell buyer this order is for a future purchase, so the commitment will be set up during the specified future year. This is particularly important during the year end process.
9) Do we know which buyer we should send the requisition to?
Check the Commodity Codes by Buyer to find out what commodity code is and who the buyer is for your requisition.
Supplier Set Up and Change Request
To set up a new supplier, send a request to firstname.lastname@example.org with the following information:
- Supplier name
- Supplier business address
- Supplier billing address (if different from business address)
- Phone number
- Fax number
- Email to receive our PO
- Supplier contact's name, phone number and email address
- Payment terms (if different than the University's default net 30 term)
- Freight (if different from the University's default pre-paid term)
- Transportation (if different from the University's default arrange-by-supplier term)
- Shipping terms (if different from the University's default FOB Destination term)
- Currency (CAD or USD or GBP)
- Payment information (EFT is preferred)
To revise a supplier information in iProcurement, send a request to email@example.com with the following information:
- Supplier name
- iProcurement supplier number
- The detailed changes you are requesting
All supplier setup and change requests will be processed within 12 - 24 business hours.
Supporting Documents for Requisitions
For Requisitions for New POs:
Requisition Scenario Where Attachments Are Required
|Written Quote(s)||Supplier is selected from quote(s) based on purchasing thresholds|
Justification for Supplier Selection
Supplier is selected from multiple quotes,
|Document to Support a Missing Quote such as Supplier’s Email or Manufacturer’s Email||
Supplier is selected from multiple quotes,
|Non-Competitive Procurement Justification||
Supplier is selected in accordance with a non-competitive procurement provision,
Supplier’s Final Quote
|Supplier is selected from a RFX process|
|Supplier Verification of Compliance Form (SVC)||
|Supplier Conflict of Interest Form||
Total order is over $99,999 and supplier is not selected from a RFX process,
|Relationship Questionnaire||Services provided by an individual or an owner operated business (sole proprietorship)|
|Standalone Agreement/Contract||Separate agreements or contracts have been signed or will be signed for the purchase|
|Radioactive Permit Number in Item Description||Radioactive material purchases|
AUP number in Item Description
|Live animal (vertebrates) purchases|
For Requisitions Revising Existing POs:
|Attachments||Requisition Scenario Where Attachments Are Required|
|Existing PO number in Notes to Buyer
|All requisitions revising an existing PO|
|Are signatures on original documents sufficient for the new value?
If no, documents need to be refreshed with signatures from required authority and resubmitted
Revise an existing PO
|Non-Competitive Procurement Justification||Original blanket PO covering a period of time, revise it by extending original term|
Category Codes by Purchasing Contact
All category codes in iProcurement are combination of Category Code and Category Type of SUPP. For example, ADV.SUPP.
If you can't find a category code appropriate for your purchase, contact firstname.lastname@example.org. A new category code could be set up upon request.
|ADV||Advertising, Promotion, Communications||Nelson Severino|
|AE||Arts & Entertainment - art, games, music, etc.||Nelson Severino|
|AGG||Aggregates including cement, sand, salt, road gravel||Nelson Severino|
|AGR1||Agricultural & Horticultural Vehicles & Implements||Jesse Allen|
|AGR2||Crop Inputs - seeds, fertilizers, pesticides, farm chemicals||Jesse Allen|
|AGR3||Crop Outputs - oilseeds (grains), hay, straw||Jesse Allen|
|ANIM1||Animal Feed & Bedding||Jesse Allen|
|ANIM2||Animal Husbandry - animal equipment, service||Jesse Allen|
|ANIM3||Animal & Marine Life (Live) & Artificial Insemination||Jesse Allen|
|APP||Appliances (Domestic -10Cº) & Food Processing||Nelson Severino|
|ATH||Athletics - excluding jerseys – see (WEAR)||Nelson Severino|
|AV||Audio, Visual & Projection||Nelson Severino|
|AWA||Awards & Trophies||Nelson Severino|
|BIOHAZ||Biological Hazardous Materials||Jesse Allen|
|BLDG||Building Renovation & Maintenance||Nelson Severino|
|CAP||Capital Equipment Projects, ARIO over $100k, including affixed equipment approved by Physical Resources||Nelson Severino|
|CHEM1||Chemicals - Industrial plant, water treatment, lubricants, etc||Jesse Allen|
|CHEM2||Chemicals - Scientific Freezer Program, Lab Chemicals, Organic Compounds & Reagents, Biochemical||Jesse Allen|
|CHEM3||Chemicals - Alcohol||Jesse Allen|
|CHILD||Childcare Services||Nelson Severino|
|COMM1||Communication - networking & web services||Nelson Severino|
|COMM2||Communications - telecommunications, cell phones||Nelson Severino|
|COMP1||Computer - Hardware, Accessories & Peripherals||Nelson Severino|
|COMP2||Computer - Software Applications & Websites||Nelson Severino|
|CONFERENCE||Conference, Meeting||Jesse Allen|
|CONSTRUCT||Projects, ARIO over $100k, including design, architect, land development, buildings, affixed equipment, furniture||Nelson Severino|
|CONSULTING||General Consulting Services including management consulting or technical consulting||Jesse Allen|
|ENG||Architect, Study, Engineering & Survey (non-construction)||Nelson Severino|
|ENV||Environmental (Soil, Water, Air, Weather)||Jesse Allen|
|EVENT||Event Hosting & Organizing, Special Occasion||Nelson Severino|
|FILING||Filing - office & record retention||Nelson Severino|
|FLEET||Fleet - Vehicles Purchase; rental; lease||Nelson Severino|
|FLOOR||Floor Finishing & Covering||Nelson Severino|
|FOOD||Food - equipment, supplies, services||Nelson Severino|
|FUEL||Fuel, Heating Oil & Propane||Nelson Severino|
|FURN||Furniture Office & Facilities - filing cabinet, furniture, office seating||Nelson Severino|
|GAS||Gases, Compressed||Nelson Severino|
|GROUNDS||Grounds Keeping & Landscaping||Nelson Severino|
|HDW||Hardware, Tools & General Consumer Goods||Nelson Severino|
|HOUSE||Housekeeping Supplies and Services||Nelson Severino|
|HVAC||Heating, Ventilation, A/C||Nelson Severino|
|LASER||Laser devises & supplies||Nelson Severino|
|LAU||Laundry & Linen Services||Nelson Severino|
|LIB||Library & Archival||Nelson Severino|
|MATL||Material Handling including elevator, industrial shelving & storage, robotics||Nelson Severino|
|MED1||Medical, Surgical, Pharmaceutical, Veterinary - supplies & minor equipment||Jesse Allen|
|MED2||Medical, Surgical, Pharmaceutical, Veterinary - equipment||Jesse Allen|
|MEMBERSHIP||Membership, sponsorship||Nelson Severino|
|MET||Raw Materials including Metal, Plastic, Rubber||Nelson Severino|
|MOV||Moving & Storage Services - faculty & staff||Jesse Allen|
|OFF1||Office & Stationery includes postal & computer supplies (excluding postage, Computers & Computer Peripherals)||Nelson Severino|
|OFF2||Office Paper, Printers including inkjet, laser, wide format||Nelson Severino|
|PEST||Pest Control Services||Nelson Severino|
|PHOTO||Photographic & Finishing||Nelson Severino|
|PRINT1||Print - Photocopier||Nelson Severino|
|PRINT2||Print - Printing & Publishing||Nelson Severino|
|PROPERTY||Property management, Real Estate Services||Nelson Severino|
|RAD||Radioactive Material & Supplies||Jesse Allen|
|SCI||Scientific - equipment, supplies, services||Jesse Allen|
|SEC||Security Parking & Identification||Nelson Severino|
|SIGN||Signage - interior & exterior||Nelson Severino|
|TEACHING||Teaching, Speaking engagement, lecturing services||Nelson Severino|
|TEX||Textiles - linen, bath curtains, mattress, upholstery, etc.||Nelson Severino|
|TRAINING||Training, Course, Seminar||Nelson Severino|
|TRAN||Transportation Services, Freight||Nelson Severino|
|TRAV||Travel & Accommodation - Hotel & Out of Town Car Rentals, Airporter Service, Bus Rentals||Nelson Severino|
|WASTE||Waste Management & Recycling - disposal of general, hazardous, dead stock, medical, metals, plastics||Jesse Allen|
|WEAR||Wearing Apparel including work wear, lab, clinic, athletic||Nelson Severino|
|WEBSITE||Website development, maintenance, troubleshooting services||Nelson Severino|
|WINDOW||Window Coverings & Treatments||Nelson Severino|
Items Must Be Procured Through iProcurement
1. Denatured Alcohol (DA) and Specially Denatured Alcohol (SDA)
DA and SDA are items regulated by the Excise Act, 2001 and related regulations. As a SDA registrant, the University is required to maintain adequate books and records such as purchase orders. Requisitions for DA and SDA shall use category code CHEM3.SUPP.
Denatured Alcohol (DA) refers to spirits that have been mixed with prescribed denaturants rendering the product non-potable for human consumption and making recovery of spirits difficult. Duty and excise tax exemptions do not apply to DA.
Specially Denatured Alcohol (SDA) refers to spirits that have been denatured for scientific or industrial uses in accordance with prescribed grade-specific specifications. Duty and excise tax exemptions apply to SDA.
2. Radioactive Materials
Requisitions for radioactive material will be routed to Environmental Health and Safety Department for approval prior to being processed by Purchasing Services. The category code for radioactive material is RAD.SUPP.
3. Live Animal (Vertebrates)
Requisition for live animal (vertebrates) will be routed to Animal Care Services for approval prior to being processed by Purchasing Services. The category code for live animal (vertebrates) is ANIM3.SUPP. Please ensure the Animal Utilization Protocol (AUP) number has been assigned by ACS prior to entering requisition and the AUP is clearly indicated on the requisition.
4. Biological Hazardous Materials
Requisitions for biological hazardous materials will be routed to Environmental Health & Safety for approval prior to being processed by Purchasing Services. The category code for biological hazardous materials is BIOHAZ.SUPP.
Biological hazardous material, also known as biohazards, refer to biological substances that pose a threat to the health of living organisms, both human or animals. Biohazardous materials include infectious agents, (i.e., pathogens), or materials produced by living organisms, (i.e., biological toxins), which may cause disease in other living organisms. Examples of biohazards are: recombinant DNA, medical waste or samples of a microorganism, virus, bacteria, molds or fungus.
5. Hazardous Material Disposal Services
Requisitions for hazardous material disposal will be routed to Environmental Health & Safety for approval prior to being processed by Purchasing Services. The category code for hazardous material disposal is WASTE.SUPP.
The Environmental Health & Safety Department manages the University's hazardous waste disposal program. Please contact EHS before you initiate any requisition for hazardous material disposal services. For more information on the hazardous waste disposal procedure, please visit https://www.uoguelph.ca/hr/hr-services-environmental-health-safety-programs-laboratory-safety/hazardous-waste,
Requisitions for Apparel Products
In 2012, the University's Board of Governors approved a Code of Ethical Conduct for Suppliers and Subcontractors in Relation to Working Conditions and Employment Standards (the Code). The purpose of the Code is to ensure that the University does its utmost to have positive impact on working conditions and to minimize the possibility of its contribution to oppressive working conditions. As a result, the University of Guelph requires suppliers and subcontractors with which it does business and who fall within the scope of this Code to conduct their business and uphold workplace standards in adherence to the Code.
Effective November 1st, 2016, the University of Guelph will require all suppliers who supply apparel products to the University to confirm their compliance of the Code by completing the Supplier Verification of Compliance (SVC) form.
The University maintains a list of apparel product suppliers on its Ethical Buying website that have completed the SVC forms. If departments are buying apparel products from the suppliers on this list, no extra SVC form is required. If departments would like to procure apparel products from a supplier that is not on this list, it is required to have a SVC form completed by the supplier and attached to the purchase requisitions.
For the list of suppliers who have completed the SVC form, visit Ethical Buying website. The Supplier Verification of Compliance (SVC) form is available in the Forms section under Ethical Buying Forms on Procurement website.
Entering and Submitting Requisitions
Below is a step by step guide on how to enter and submit a new requisition:
- Log into the iProcurement
- Start a new requisition by clicking Non-Catalog Request tab at the header
- Enter all fields as requested, click Add to Cart
- Click View Cart and Checkout bar to move to checkout screen
- Enter all fields on requisition information section, click Next bar
- Enter Charge Accounts, click Next.
- Enter Notes to Buyer, add Attachment, click Next
- Review all requisition information, click Submit.
During step 4 and 8, you can choose to save the requisition at any time and exit the process.
At any later time, you may log back in iProcurement and click the requisition you saved earlier to continue. A requisition is submitted only when you click the Submit button and the system confirmed the requisition has been submitted successfully.
Requisitioners will also receive an email notification that the requisition is submitted.
We are currently working on a detailed screen by screen instructions. Please check back here at a later date.
Revising Existing POs
Requisitioners can submit email requests to the buyer for the following types of Order Change:
- Order Cancellation
- Order Amount Decrease
- Order Amount Increase Below $3000
For order amount increase over $3000, a new requisition is required. Requisitioners should indicate, in Notes to Buyer section, you would like to add the requisition to the existing PO and what the PO number is.
To change the GL coding on an existing HVPO:
- contact the buyer who issued the PO
- The open line with old GL coding would be cancelled and returned to the requisitioner
- Requisitioner revise the requisition with new GL coding and re-submit
- The re-submitted requisition will become a new line under the same PO
If invoices have been paid against a HVPO, Purchasing can only change the GL coding for the balance that hasn't been paid.
If you need to change the GL Coding for the payments already been made, department can do journal entry to correct the coding. Alternatively, contact Payment Services to request to have all invoices paid against the HVPO unmatched, then follow the above process to have the GL coding on the PO changed, and at last request Payment Services to rematch all paid invoices against the new PO line. Due to the workload involved in this process, it is only recommended when there is a specific reason we do not want to use journal entries to correct the codings.
For all PO change requests, requisitioners should make sure sufficient supporting documents are provided to the buyer.
A requisition may be returned for various reasons. Every time when a requisition is returned, the requisitioner will receive an email from the buyer providing detailed information why the requisition is returned. Check the email. If the information in the email is not clear to you, contact the buyer.
Some of the most common reasons for requisition returns are:
- Missing backup document such as quote(s) or Single/Sole Source
Please do not send these documents via email. We require all back up documentation being attached with the requisition.
- Didn’t select a proper P-site
All iProcurement supplier sites should begin with “P”. If the site you use is not a P- site or is not set up in the system, stop the requisition process, email email@example.com to have the site revised to P-site or set up, then resume the requisition process. Refer to the Supplier Set Up and Change Request section for details.
- Didn’t select a proper Ship-To address
All Ship-To address should begin with four digit unit number followed by a sequence number, such as 1234-01. Correct Ship-To address not only ensures the supplier ship your order to the correct receiving address, but also that your department receives a copy of the PO and the DDR.
- Items with different taxes being entered in the same line
Every PO line can only be applied with one tax treatment. If different items are taxed differently, they have to be entered in different lines. For example: professional services are HST taxable. Reimbursed travel expenses are tax exempt. If one requisition has both items, they must be entered on two different lines.
What Happens After Requisition Submission
Once a requisition is submitted, it automatically goes into the queue for the specified buyer. The buyer will review all information submitted with the requisition to determine if all required supporting documents are present and if all information on the requisition is complete and correct. The buyer will contact the requisitioner within 24 to 48 business hours if we require further information or if we have any questions. If information on the requisition is incomplete or incorrect, the buyer will return the requisition to the originator for revise or completion.
When all requirements for processing the PO are met, the buyer will process the requisition into a purchase order. Once the order is issued in Oracle system, a copy of the PO and the Distribution Detail Report (DDR) will be emailed to the following parties:
- the requisitioner
- the department organizational email associated with ship-to location code
- the buyer
- the supplier (if no email on file, the PO will be faxed to the supplier)
Where buyer has all the information required, the normal processing time for a requisition to be turned into a PO is 24 to 48 business hours. However, this time may vary during high volume periods.
Tracking Your Department Open POs
On the 1st day of each month, the Oracle system will email departments a report called UofG Open POs for every department's outstanding high value purchase orders (HVPOs). This report provides you a snap shot of all HVPOs that are outstanding for your department at the end of each month. The report is in CSV format, which can be viewed and edited in Excel. The report will be emailed to the organizational email address your department currently uses to receive HVPOs.
To understand what type of information this report provides and how to open, edit and save the report, please review the Open POs Report FAQs.
We hope this report makes it easier for you to manage your department’s HVPOs, especially in areas of approving invoices, managing blanket POs and commitments. For example, the report can be used to:
- review the remaining amount on the blanket POs and determine if you need to make any changes for the remainder of fiscal year or the remainder of the PO term;
- review any invoices against your outstanding POs before approving them for payment to ensure it is not an overbilling and the invoice is paid against the POs;
- understand the PO commitments in your FRS account and alert us if the commitments are incorrect.
If you have questions regarding this report, please contact firstname.lastname@example.org.
Training and System Updates
Purchasing Services has developed iProcurement training resource documents which you can access at any time from your own desktop. Please see below for:
- iProcurement reference manual
- How-to update Requisition information
- How-two update Requisition Buyer field
iProcurement System Update
As part of our continuous improvement, the iProcurement team constantly seeks opportunity to improve the system and the process. Whenever any change is made to the system, we will send out iProcurement Updates to all iProcurement users to keep everyone informed of all changes and updates.
If you are an iProcurement user but did not receive these updates, please email email@example.com. We will make sure you are added to the iProcurement communication list.
iProcurement User Group Feedback
We would love to hear any suggestions and feedbacks you might have about the iProcurement system or the HVPO process. Please do not hesitate to let us know. Together, we could make it better.
|How-to update Requisition Buyer field.pdf||116.97 KB|
|How-to update Requisition information 2020.07.17.pdf||195.39 KB|
|iProcurement reference manual 2020.07.16.pdf||959.25 KB|