Supplier
Overview
📥 Direction: Sage X3 → Zudello
🔄 Sync Type: Incremental sync
⏱️ Frequency: Based on _updateStamp
Supplier data flows from Sage X3 to Zudello with comprehensive business partner information including contact details, banking information, and extensive relationship mappings.
✅ Comprehensive Data - Banking, contact, and address information included
✅ Business Partner Model - Uses Sage X3's advanced business partner structure
✅ Contact Integration - Maintain phone and email information
✅ Banking Details - Include bank account details for payment processing
Field Mappings
Zudello Field | Sage X3 Field | Data Type | Notes |
---|---|---|---|
code | code.code | String | Supplier code |
legal_name | companyName1 or shortCompanyName | String | Company name with fallback |
trading_name | companyName1 or shortCompanyName | String | Same as legal name |
tax_number | code.vatNumber | String | VAT/tax number |
status | isActive | String | ACTIVE if true, INACTIVE if false |
bank_account_name | code.bankDetails.query.edges[0].node.beneficiary | String | Bank account beneficiary |
bank_account_number | code.bankDetails.query.edges[0].node.bankId | String | Bank account number |
tax_inclusive | amountType | Boolean | false if "excludeTax", true otherwise |
Configuration Requirements
Only suppliers from these countries will be synchronized:
- 🇦🇺 Australia (AU)
- 🇨🇦 Canada (CA)
- 🇫🇷 France (FR)
- 🇮🇪 Ireland (IE)
- 🇳🇿 New Zealand (NZ)
- 🇿🇦 South Africa (ZA)
- 🇬🇧 United Kingdom (GB)
- 🇺🇸 United States (US)
Processing Logic
Sync Behavior
- Global Import: No legislation filter - imports suppliers from all supported countries
- Incremental Updates: Uses
_updateStamp
to fetch only changed records - Complex Structure: Handles nested GraphQL relationships for comprehensive data
Contact Information Processing
- Email Handling: Creates contact items with email addresses
- Phone Priority: Prioritizes cellPhone over landline for phone data
- Contact Replacement: Phone and email data completely replaces existing contacts
Banking Integration
- Bank Account Details: Includes beneficiary name and account number
- Payment Processing: Enables automated payment processing
- BIC Codes: Includes bank identification codes for international transfers
Business Partner Structure
The integration leverages Sage X3's business partner capabilities:
- Comprehensive Data: Includes all business partner site information
- Legal Relationships: Maintains legal company and site relationships
- Tax Configuration: Determines tax-inclusive/exclusive settings
- Payment Terms: Includes payment term relationships
Country and Address Handling
Address and country information is processed with restrictions:
- Allowed Countries: Strict filtering to supported countries only
- Address Details: Includes city, state, zipCode, and country information
- Geographic Filtering: Ensures compliance with supported regions
Tax Configuration
Tax handling includes various considerations:
- Tax Inclusive Flag: Determined by amountType field
- Exclude Tax: amountType "excludeTax" sets tax_inclusive to false
- Default Behavior: All other amountType values set tax_inclusive to true
- VAT Numbers: Includes VAT/tax identification numbers
Troubleshooting
Issue | Cause | Solution |
---|---|---|
Supplier not syncing | Country not in allowed list | Verify supplier country code |
Missing contact info | Empty phone/email fields | Check contact data in Sage X3 |
Banking details missing | No bank account configured | Verify bank details in business partner |
Tax configuration incorrect | amountType misconfigured | Review tax settings in Sage X3 |
Related Documentation
- Payment Term - Supplier payment configurations
- Currency - Multi-currency supplier support
- BP Supplier Invoice - Supplier invoice processing
- Tax Code - Supplier tax configurations