Use this article to learn how to view, update, and bulk-import values for the managed lists used in Procurement Planning. Managed lists are fields where users select an option from a pre-determined, administrator-managed list of values. The fields you can manage are Cost Centres, Regions, Contract Types, Risk Types and Categories, and Category and Subcategories.
Prerequisites
You must have Administrator access to the Procurement Planning module to view and update the managed lists.
Steps
Follow these steps to access and update your managed lists.
-
Navigate to the Procurement Planning module.
Find the module either via the app launcher icon in the menubar or through the navigation tile on your Homepage.
Click on the Manage Module tab in the top right to open the module settings.
-
Select the Lists tab. Here, click on the list you want to update.
A table of all values currently in the list will expand.
-
Make any required changes to existing values or add new values.
This can either be done individually or in bulk (for some of the lists) by using the Import Templates function.
To change an existing value individually: Click on the line item to open its details, make the necessary amendments, then Save your changes.
To delete a value individually: Open up the details and select the Delete button.
To create a new value individually: Click on the + symbol to the right of the table, then enter all required details and click Save.
Managed List Descriptions and Fields
The following describes the available managed lists and the details you can define for each.
Cost Centres
Location in Procurement Plan: Appears in the Setup phase of a Procurement Plan on the Value step.
Mandatory: It is an optional field.
-
Fields to Define: When creating/managing a cost centre in this list, you will be able to define the following:
Cost Centre Number.
Name or description of this cost centre.
Note: Cost Centres are available as a selectable field and managed list in Procurement Planning and Contracts Management. It is a single list that applies to both modules and can be managed from either module's settings (if using both modules). This means the same fields will be available for users to select when assigning a cost centre to a plan or contract.
Regions
-
Location in Procurement Plan: Can appear in the Setup phase of a Procurement Plan in the Details step.
Users will be able to select multiple regions where the procurement will be carried out.
Administrators can choose whether they want to include this field as part of the plan or not, and can also determine whether it's a mandatory field or not in the Procurement Planning General Settings.
-
Fields to Define: You will only need to define the name of your regions when creating/managing your values in this list.
Click the Save button to save your changes.
Contract Types
-
Location in Procurement Plan: Can appear in the Setup phase of a Procurement Plan on the Award Type step.
This step is only included if you are also using the Contracts Management module and the Procurement Process selected on the Plan has an Output Type of Contract, Panel Contract, or Subcontract.
Fields to Define: Information on setting up and managing your Contract Types is available in the Managing Contract Types article.
Note: Contract Types are available as a selectable field and managed list in Procurement Planning and Contracts Management. It is a single list that applies to both modules and can be managed from either module's settings (if using both modules). This means the same fields will be available for users to select when assigning a contract type to a plan or contract.
Risk Types and Categories
-
Location in Procurement Plan: Can appear in the Planning phase of a Procurement Plan on the Risks step.
When adding a new Risk a user will be able to select a 'type' and then get a list of 'categories' that relate to the selected type. Here you can define those options.
This step can be enabled in a Procurement Process and allows the user to enter any known risks to the procurement.
-
Fields to Define: When creating/managing your risk types and categories in this list, you will be able to define the following:
Risk Type name.
Primary Objective of the risk type.
-
The Categories that relate to this Risk Type.
Against a category, you can describe the four severity levels (Minor, Moderate, Major, Extreme).
You can add additional categories using the table controls on the left that appear when you hover over the table.
Note: Risk Types and Categories are available as a selectable field and managed list in Procurement Planning and Contracts Management. It is a single list that applies to both modules and can be managed from either module's settings (if using both modules). This means the same fields will be available for users to select when adding a Risk to a plan or contract.
Category and Subcategories
-
Location in Procurement Plan: Can appear in the Setup phase of a Procurement Plan in the Details step.
Users will be able to select multiple categories that apply to this procurement.
They will first select a 'category' and then will be able to select a 'subcategory' from what's been linked to the category they selected first.
Administrators can choose whether they want to include this field as part of the plan or not, and can also determine whether it's a mandatory field or not in the Procurement Planning General Settings.
-
Fields to Define: When creating/managing a category in this list, you will be able to define the following:
Category name.
An optional description of the category.
-
The subcategories linked to the category.
You can add additional subcategories using the table controls on the left that appear when you hover over the table.
Note: Categories and subcategories are available as a selectable field and managed list in Procurement Planning and Contracts Management. It is a single list that applies to both modules and can be managed from either module's settings (if using both modules). This means the same fields will be available for users to select when setting a category on a plan or contract.
Import Templates Function (Bulk Updates)
Import templates are available if you need to make updates to a list in bulk. The template you download will include all of your current values in this managed list. It will include columns for the values that you can set.
Steps to Use the Import Templates Function
While on the Lists tab of the module settings, scroll down the page to reach the Import Templates section.
Select the relevant list from the drop-down menu.
-
Click to Download an import template, then open the template in Excel.
The template will contain any existing list items.
The first column contains the record IDs (unique identifiers) and any subsequent columns are dedicated to capturing the list values.
-
Update the template as needed:
To make changes to existing items: Retain the record IDs and update the values in any subsequent columns. If you don't make any changes to other existing items then nothing will change for them when you import the template.
To add new items: In a new row, leave the record ID column blank (the system will find the next available record ID upon import) and enter the values in their dedicated columns. This also ensures you don't inadvertently overwrite an existing record.
Do not make any changes to the column names, as they reference specific fields in the system.
Save the changes made to your template in Excel.
-
Return to VendorPanel and select to Import the template (ensure you still have the correct managed list selected from the dropdown).
You will receive an on-screen notification confirming once your import has been successful.
What's Next / Related
Troubleshooting
The source text does not contain a specific Troubleshooting section for this task.
Limits & Notes
The names of the columns directly relate to how the data is stored in-system. Please do not change the name of the columns so the system can correctly identify what's required to be updated when importing.
The RecordID field is the unique identifier in-system for the record of the item.
You can either create new items, update existing ones, or do both of these at the same time in one import.
Cost Centres, Contract Types, Risk Types and Categories, and Categories and Subcategories are single lists that apply to and can be managed from the settings of both the Procurement Planning and Contracts Management modules (if using both modules).