 |
| ||||||||
FAQ KB0397126
How to create, update or activate a Unit of Measure?
Question
How to create, update or activate a Unit of Measure?
Answer
Site Administrators can now import Unit of Measure (UOM) and Unit of Measure Translations.
This is now a Self-Service Task and site administrators are responsible for updating their site's UOMs.
Procedure:
- Go to Site Manager > Data Import/Export;
- Click Import tab search for Units Of Measure;
- Select Import Units Of Measure;
- Select the appropriate Import Operation:
- Load: Creates and modifies objects in the database using values in the data file. If an object in the data file does not already exist in the database, it is created. If an object in the data file already exists in database, it is modified using the value in the data file
-
Create: Creates new objects in the database using values in the data file. If an object in the data file already exists in the database, it is not modified.
-
Update Only: Modifies existing objects only in the database using values in the data file. If an object in the data file does not already exist in the database, it is not created. If you do not want to modify a particular object, do not include it in the data file. This operation can cause deactivated objects to be reactivated
-
Deactivate: Deactivates objects in the database based on objects in the data file. If you do not want to deactivate a particular object, do not include it in the data file.
- Choose your updated UnitsOfMeasure.csv file with the correct entries.
- Run.
Note: It's recommended to export the current list of active UOMs before Importing the file to confirm what is currently active in your realm.
Additional Information
Sample UnitsOfMeasure.csv
"UTF-8"
UniqueName,Name,AllowNonWhole,Category,Description
"DZN","Dozen","Yes","0","DZN"
"Dozens","12-Dozen","Yes","0","dozen (Test)"
For additional details please check below:
UniqueName: A unique internal identifier for the unit of measure.
Name: A user-visible name for the unit of measure.
AllowNonWhole: A Boolean value that indicates whether the unit of measure supports non-whole quantities. For example, a centimeter supports non-whole quantities, while a micron or an atom does not.
Category: Indicates whether the unit of measure is time related. A value of 1 means the unit of measure is time related. A value of 0 means the unit of measure is not time related.
Description: A user-visible description for the unit of measure.
Applies To
Core Procurement > Core Administration > Units of measure (UOM)
Strategic Sourcing