Purchase Requisitions - Support Multiple Units of Measure per Item
R
Rebeca Castellanos
a créé un sujet
environ 11 heures il y a
Current Limitation:In mySparkrock Purchase Requisitions, each item can only be configured with a single Unit of Measure (UOM). This creates challenges for organizations that manage centralized inventory items that users may want to order in different quantities.
Use Case:Our organization has ~200 Central Supply items that approximately 20 users can requisition. Each item is configured with one base UOM (e.g., "Bag" containing 80 briefs).
The Problem:When users need to order in larger quantities (e.g., "Case" containing 320 briefs = 4 bags), they must manually calculate the conversion:
320 briefs per case ÷ 80 briefs per bag = 4 bags per case
To order 5 cases: 5 cases × 4 bags/case = 20 bags
This manual calculation is confusing and error-prone for users.
Current Workarounds:
Manual Math: Users calculate conversions themselves (current state - confusing)
Duplicate Items: Create separate items for each UOM (e.g., "Briefs - Bag" and "Briefs - Case"), which doubles the database and creates maintenance overhead
Desired Enhancement:Allow items to support multiple Units of Measure with automatic conversion. Users would:
Select the item (e.g., "Briefs")
Choose from a dropdown: "Bag" or "Case"
Enter the quantity in their preferred UOM
System automatically converts to the base UOM for ordering
Business Value:
Eliminates user confusion and calculation errors
Improves user experience and adoption
Reduces support tickets
More efficient than duplicating every item in the database
Aligns with standard procurement practices where items can be ordered in multiple pack sizes
Example:
Item: Briefs
Base UOM: Bag (80 briefs)
Alternative UOM: Case (320 briefs = 4 bags)
User selects "Case" and enters "5" → System converts to "20 bags" for ordering
Rebeca Castellanos