Suppliers

Overview

📥 Direction: NetSuite → Zudello
🔄 Sync Type: Incremental sync
⏱️ Frequency: Based on lastModifiedDate

Supplier data flows from NetSuite to Zudello to maintain a comprehensive vendor master file. This integration supports multi-currency vendors, multiple bank accounts, payment terms, and subsidiary-specific configurations.

Key Benefits

✅ Multi-Currency Vendors - Handle international suppliers with ease
✅ Banking Integration - Multiple bank accounts per supplier
✅ Payment Optimization - Terms and methods synchronized
✅ Entity Segregation - Subsidiary-specific vendor management

Field Mappings

Zudello Field	NetSuite Field	Data Type	Notes
code	entityId	String	Vendor code/number
legal_name	legalName	String	Legal entity name
trading_name	companyName	String	Trading/display name
currency	currency	Relation	Links to Currency
payment_term	terms	Relation	Links to Payment Term
subsidiary	subsidiary	Relation	Links to primary Subsidiary
tax_number	taxIdNum	String	Tax registration number
status	isInactive	String	true = INACTIVE, false = ACTIVE
credit_limit	creditLimit	Decimal	Vendor credit limit
phones	phone	String	Primary phone number
emails	email	String	Primary email address

API Configuration

SuiteQL Configuration

• Primary Table: Vendor
• Join Tables: Terms, Currency, Subsidiary
• Filter Criteria: Based on subsidiary access
• Date Field: lastModifiedDate for incremental sync

Additional Data Tables

• Bank Accounts: Separate query for vendor bank details
• Addresses: Billing and remittance addresses
• Contacts: Vendor contact persons

Sync Configuration

Bank Account Processing

1. Query vendor bank accounts separately
2. Match to vendor using internalId
3. Support multiple accounts per vendor
4. Mark primary/default account

Multi-Subsidiary Vendors

• Vendors can be assigned to multiple subsidiaries
• Primary subsidiary used for main record
• Subsidiary-specific settings preserved
• Cross-entity vendor sharing supported

Processing Logic

Status Determination

• Active Vendors: isInactive = false → Status = "ACTIVE"
• Inactive Vendors: isInactive = true → Status = "INACTIVE"
• On Hold: Credit hold status tracked separately
• Blocked: Purchase blocking tracked independently

Bank Account Handling

For each vendor:
1. Retrieve all associated bank accounts
2. Identify primary account (isPrimary flag)
3. Map bank details:
   - Account name
   - Account number (masked)
   - Bank name
   - Routing/BSB number
   - SWIFT/BIC codes
4. Store as supplier_bank_accounts collection

Currency Management

• Primary currency from vendor record
• Multi-currency capabilities preserved
• Currency-specific pricing supported
• Exchange rate considerations

Special Features

Payment Configuration

• Payment Terms: Full term details synchronized
• Payment Methods: Preferred payment method tracked
• Early Payment Discounts: Discount terms preserved
• Credit Management: Credit limits and holds

Tax Registration

• Primary Tax ID: Federal/national registration
• Secondary IDs: State/provincial numbers
• VAT/GST Numbers: International tax IDs
• Exemption Certificates: Tax exemption tracking

Contact Management

• Primary Contact: Main vendor contact
• Accounts Payable: AP-specific contacts
• Purchasing Contacts: Buyer communications
• Emergency Contacts: Critical contact info

Troubleshooting

Issue	Cause	Solution
Bank accounts missing	Separate permissions required	Check bank account access in role
Currency mismatch	Invalid currency mapping	Verify currency codes in both systems
Terms not linking	Payment terms not synced	Run payment terms sync first
Subsidiary errors	Multi-subsidiary configuration	Review subsidiary assignments
Credit limit issues	Number format problems	Check decimal precision settings

Related Documentation

• Payment Terms - Vendor payment term setup
• Subsidiaries - Multi-entity configuration
• Currency - Multi-currency setup
• Purchase Orders - Vendor transaction processing
• NetSuite Overview - General integration guidelines