Classifications
Overview
The NetSuite Classifications integration synchronizes cost center and classification data from NetSuite to Zudello, enabling accurate expense allocation and departmental financial tracking.
Integration Details:
- Direction: NetSuite → Zudello (📥 Inbound)
- Sync Type: Incremental
- Sync Frequency: Every 6 hours
- API Used: SuiteQL
Key Benefits
- Accurate cost center tracking across systems
- Supports multi-level classification hierarchies
- Enables departmental expense analysis
- Maintains classification relationships
Field Mappings
| NetSuite Field | Zudello Field | Description | Data Type |
|---|---|---|---|
| name | ClassificationName | Classification identifier | String |
| classnumber | ClassificationCode | Unique classification code | String |
| isinactive | Status | true = INACTIVE, false = ACTIVE | String |
| parent | ParentClassification | Parent classification for hierarchy | Relation |
| subsidiary | Subsidiary | Associated subsidiary | Relation |
| includechildren | IncludeChildren | Consolidation indicator | Boolean |
| description | Description | Classification description | String |
API Configuration
SuiteQL Query Structure
The integration uses SuiteQL to query classification data with support for hierarchical structures and incremental synchronization.
Authentication
- Method: Token-based Authentication (TBA)
- Required Permissions:
- Classifications (View)
- Lists → Accounting (View)
- Subsidiaries (View)
Sync Configuration
Incremental Sync Logic
The integration efficiently syncs only modified classifications:
- Initial sync captures entire classification structure
- Subsequent syncs retrieve records where
lastmodifieddate> last sync timestamp - Maintains parent-child relationships during incremental updates
- Preserves classification hierarchy integrity
Data Transformation
- Status Conversion: NetSuite boolean
isinactive(T/F) → Zudello string status (INACTIVE/ACTIVE) - Hierarchy Processing: Ensures parent classifications sync before children
- Subsidiary Mapping: Links classifications to appropriate entities
Processing Logic
- Hierarchy Retrieval: Query classifications with parent relationships
- Order Processing: Process parent classifications before children
- Status Transformation: Convert NetSuite boolean to string status
- Validation: Ensure classification codes are unique
- Subsidiary Association: Map classifications to correct subsidiaries
- Consolidation Rules: Apply include/exclude children logic
Troubleshooting
| Issue | Possible Cause | Solution |
|---|---|---|
| Missing classifications | Permission restrictions | Verify Classifications view permissions |
| Hierarchy errors | Parent not synced | Run full sync to rebuild hierarchy |
| Subsidiary mismatch | Multi-subsidiary setup | Check subsidiary access permissions |
| Duplicate codes | Classification renaming | Review classification code uniqueness |
| Sync gaps | Timezone differences | Verify timestamp handling |