Units of Measure
Overview
📥 Direction: NetSuite → Zudello
🔄 Sync Type: Incremental sync
⏱️ Frequency: Based on lastModifiedDate
Units of Measure (UOM) data flows from NetSuite to Zudello to maintain consistent measurement standards across inventory management, purchasing, and sales processes. This integration supports base units and conversion factors for complex UOM relationships.
Key Benefits
✅ Standardized Measurements - Consistent UOM across all processes
✅ Conversion Support - Automatic unit conversions where needed
✅ Inventory Accuracy - Precise quantity tracking
✅ Multi-Unit Items - Support for various selling/buying units
Field Mappings
| Zudello Field | NetSuite Field | Data Type | Notes |
|---|---|---|---|
| code | unitName | String | Unit abbreviation/code |
| name | pluralName | String | Full unit name (plural form) |
| singular_name | unitName | String | Singular form of unit name |
| base_unit | baseUnit | Relation | Reference to base unit if conversion |
| conversion_factor | conversionRate | Decimal | Factor to convert to base unit |
| unit_type | unitType | String | Category (Weight, Volume, Length, etc.) |
| status | isInactive | String | true = INACTIVE, false = ACTIVE |
API Configuration
SuiteQL Configuration
- Table: UnitsType
- Related Data: Unit conversions and relationships
- Filter: Include base units and conversion units
- Order: By unit type, then unit name
Conversion Management
- Base units processed first
- Conversion units require base unit existence
- Circular conversions prevented
- Factor validation performed
Sync Configuration
Processing Hierarchy
- Base Units: Units with no base unit reference
- Conversion Units: Units that convert to base units
- Validation: Ensure all references exist
- Relationships: Establish conversion chains
Data Validation
- Conversion factors must be positive
- Base unit must exist for conversions
- Unit names unique within type
- Type categories properly assigned
Processing Logic
Unit Type Categories
- Weight: Pounds, kilograms, ounces, grams
- Volume: Gallons, liters, cubic feet
- Length: Feet, meters, inches, centimeters
- Area: Square feet, square meters
- Count: Each, dozen, gross, case
- Time: Hours, days, months
Conversion Processing
Example: Conversion Chain
Base Unit: Kilogram (kg)
- Gram: 0.001 conversion factor
- Pound: 0.453592 conversion factor
- Ounce: 0.0283495 conversion factor
Calculation: 100 grams = 100 * 0.001 = 0.1 kg
Status Handling
- Active units available for new items
- Inactive units preserved for existing items
- Conversion chains maintained regardless of status
- Historical data integrity preserved
Special Features
Multi-Level Conversions
- Support for complex conversion hierarchies
- Automatic factor calculations through chain
- Precision handling for accurate conversions
- Rounding rules for display
Industry Standards
- Standard unit abbreviations maintained
- Industry-specific measurement support
- Regulatory compliance for unit usage
- International standard alignment
Item Integration
- UOM assignments to inventory items
- Purchase/sales unit differences
- Stock keeping unit definitions
- Inventory valuation considerations
Troubleshooting
| Issue | Cause | Solution |
|---|---|---|
| Conversion errors | Invalid conversion factors | Verify factor calculations |
| Missing base units | Processing order incorrect | Ensure base units sync first |
| Circular references | Improper unit relationships | Review NetSuite unit setup |
| Precision issues | Decimal place limitations | Check factor precision settings |
| Type mismatches | Unit type inconsistencies | Standardize unit type values |
Related Documentation
- Items - Inventory item UOM assignments
- Purchase Orders - UOM usage in procurement
- NetSuite Overview - General integration guidelines
- Inventory Management - Stock tracking with UOMs