Subsidiaries
Overview
📥 Direction: NetSuite → Zudello
🔄 Sync Type: Incremental sync
⏱️ Frequency: Based on lastModifiedDate
Subsidiary data flows from NetSuite to Zudello to maintain your multi-entity organizational structure. This integration ensures proper entity segregation for financial reporting and supports complex corporate hierarchies.
Key Benefits
✅ Multi-Entity Support - Manage multiple legal entities seamlessly
✅ Hierarchy Preservation - Maintain parent-subsidiary relationships
✅ Currency Management - Entity-specific currency settings
✅ Compliance Ready - Proper entity segregation for reporting
Field Mappings
| Zudello Field | NetSuite Field | Data Type | Notes |
|---|---|---|---|
| code | name | String | Subsidiary short name/code |
| name | legalName | String | Full legal entity name |
| trading_name | name | String | Operating/trading name |
| parent | parent | Relation | Parent subsidiary reference |
| currency | currency | Relation | Base currency for the subsidiary |
| country | country | String | ISO country code |
| status | isInactive | String | true = INACTIVE, false = ACTIVE |
| tax_number | federalIdNumber | String | Federal tax ID/registration |
API Configuration
SuiteQL Configuration
- Table: Subsidiary
- Required Fields: All mapped fields plus relationships
- Filter: Active and inactive subsidiaries
- Order: By hierarchy level, then name
Data Requirements
- Currency records must exist
- Country codes in ISO format
- Parent subsidiaries processed first
Sync Configuration
Initial Setup
- Configure subsidiary access permissions
- Map currency codes to Zudello
- Validate country code mappings
- Set processing order for hierarchies
Incremental Processing
- Query based on lastModifiedDate
- Process in hierarchical order
- Update relationships after all records processed
- Validate entity integrity
Processing Logic
Hierarchy Management
- Root Entities: Subsidiaries with no parent processed first
- Child Entities: Processed after parent exists in Zudello
- Elimination Entities: Special handling for consolidation subsidiaries
- Inactive Handling: Inactive status preserved but relationships maintained
Currency Configuration
- Base currency mapped from NetSuite
- Multi-currency subsidiaries supported
- Exchange rate tables referenced
- Reporting currency settings preserved
Tax Registration
- Federal ID numbers mapped to tax_number
- State registrations handled separately
- VAT/GST numbers preserved
- Multiple registration support
Special Features
Consolidation Support
- Elimination subsidiaries identified
- Inter-company relationships tracked
- Consolidation hierarchies preserved
- Reporting rollups configured
Multi-Country Operations
- Country-specific settings maintained
- Local compliance requirements tracked
- Regional hierarchies supported
- Cross-border considerations
Legal Entity Management
- Legal name vs trading name distinction
- Registration numbers preserved
- Incorporation details tracked
- Statutory requirements supported
Troubleshooting
| Issue | Cause | Solution |
|---|---|---|
| Subsidiary missing | No access permissions | Check subsidiary restrictions in role |
| Currency errors | Invalid currency code | Verify currency exists in both systems |
| Hierarchy loops | Circular parent references | Review subsidiary parent settings |
| Country mismatch | Invalid ISO code | Update country field to ISO standard |
| Consolidation issues | Elimination subsidiary config | Check consolidation settings |
Related Documentation
- Currency - Multi-currency configuration
- Tax Rates - Entity-specific tax settings
- Suppliers - Vendor subsidiary assignments
- NetSuite Overview - General integration guidelines