Chart of Accounts
Overview
The NetSuite Chart of Accounts integration enables automatic synchronization of your general ledger account structure from NetSuite to Zudello.
Integration Details:
- Direction: NetSuite → Zudello (📥 Inbound)
- Sync Type: Incremental
- Sync Frequency: Every 6 hours
- API Used: SuiteQL
Key Benefits
- Maintains consistent account structure across systems
- Enables accurate financial mapping and reporting
- Supports multi-level account hierarchies
- Automatically updates account status changes
Field Mappings
| NetSuite Field | Zudello Field | Description | Data Type |
|---|---|---|---|
| acctnumber | Number | Account number identifier | String |
| acctname | Name | Account name/description | String |
| accttype | Type | Account type classification | String |
| isinactive | Status | true = INACTIVE, false = ACTIVE | String |
| description | Description | Extended account description | String |
| parent | ParentNumber | Parent account for hierarchy | Relation |
| includechildren | IncludeChildren | Consolidation indicator | Boolean |
API Configuration
SuiteQL Query Structure
The integration uses SuiteQL to retrieve account data from NetSuite with support for incremental synchronization based on the last modified date.
Authentication
- Method: Token-based Authentication (TBA)
- Required Permissions:
- Account (View)
- Lists → Accounts (View)
Sync Configuration
Incremental Sync Logic
The integration tracks the last successful sync timestamp and only retrieves accounts modified after that date:
- Initial sync retrieves all active and inactive accounts
- Subsequent syncs only fetch accounts where
lastmodifieddate> last sync timestamp - Deleted accounts are handled through status updates (marked as INACTIVE)
Data Transformation
- Status Conversion: NetSuite boolean
isinactive(T/F) → Zudello string status (INACTIVE/ACTIVE) - Hierarchy Building: Parent-child relationships maintained through
parent.acctnumberreferences - Type Mapping: NetSuite account types mapped to Zudello classifications
Processing Logic
- Data Retrieval: Query NetSuite for accounts modified since last sync
- Transformation: Convert field formats and apply business rules
- Validation: Ensure required fields are present and data types are correct
- Hierarchy Resolution: Process parent accounts before child accounts
- Status Updates: Apply active/inactive status based on NetSuite flags
- Error Handling: Log any processing errors for manual review
Troubleshooting
| Issue | Possible Cause | Solution |
|---|---|---|
| Missing accounts | Insufficient permissions | Verify NetSuite role has Account view permissions |
| Hierarchy errors | Parent account not synced | Run full sync to ensure all parent accounts exist |
| Status mismatch | Transformation error | Check status mapping configuration |
| Sync delays | Large data volume | Consider increasing sync frequency or batch size |
| Duplicate accounts | Account number changes | Review account merge/rename procedures |