Departments

Overview

The NetSuite Departments integration synchronizes organizational department structure from NetSuite to Zudello, enabling accurate expense allocation and departmental reporting across systems.

Integration Details:

• Direction: NetSuite → Zudello (📥 Inbound)
• Sync Type: Incremental
• Sync Frequency: Every 6 hours
• API Used: SuiteQL

Key Benefits

• Maintains organizational structure consistency
• Supports hierarchical department relationships
• Enables departmental cost tracking
• Facilitates accurate expense allocation

Field Mappings

NetSuite Field	Zudello Field	Description	Data Type
name	DepartmentName	Department name	String
isinactive	Status	true = INACTIVE, false = ACTIVE	String
parent	ParentDepartment	Parent department for hierarchy	Relation
includechildren	IncludeChildren	Consolidation indicator	Boolean
subsidiary	Subsidiary	Associated subsidiary	Relation
nohierarchy	FlatStructure	Hierarchy participation flag	Boolean

API Configuration

SuiteQL Query Structure

The integration queries department data with hierarchical relationships to maintain organizational structure integrity.

Authentication

• Method: Token-based Authentication (TBA)
• Required Permissions:
  • Departments (View)
  • Lists → Employees (View)
  • Subsidiaries (View)

Sync Configuration

Incremental Sync Logic

The integration maintains efficient department synchronization:

• Initial sync captures complete department hierarchy
• Subsequent syncs retrieve departments where lastmodifieddate > last sync timestamp
• Processes parent departments before child departments
• Maintains hierarchy relationships during updates

Data Transformation

• Status Conversion: NetSuite boolean isinactive (T/F) → Zudello string status (INACTIVE/ACTIVE)
• Hierarchy Validation: Ensures parent departments exist before processing children
• Subsidiary Mapping: Associates departments with correct organizational entities

Processing Logic

1. Hierarchy Query: Retrieve departments with parent relationships
2. Order Processing: Process parent departments before children
3. Status Management: Update active/inactive department flags
4. Validation: Ensure department names are unique within scope
5. Subsidiary Linking: Associate departments with subsidiaries
6. Consolidation Rules: Apply include/exclude children logic

Troubleshooting

Issue	Possible Cause	Solution
Missing departments	Permission restrictions	Verify Departments view permissions
Hierarchy breaks	Parent not synced	Run full sync to rebuild hierarchy
Subsidiary conflicts	Multi-subsidiary access	Check subsidiary permissions
Duplicate departments	Department merging	Review department consolidation
Sync timing issues	Large hierarchy	Optimize processing order

Related Documentation

• NetSuite Integration Overview
• Organizational Structure
• Employee Management
• Expense Allocation