Skip to main content
Version: Current

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.

Key Benefits

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 FieldSage X3 FieldData TypeNotes
codecode.codeStringSupplier code
legal_namecompanyName1 or shortCompanyNameStringCompany name with fallback
trading_namecompanyName1 or shortCompanyNameStringSame as legal name
tax_numbercode.vatNumberStringVAT/tax number
statusisActiveStringACTIVE if true, INACTIVE if false
bank_account_namecode.bankDetails.query.edges[0].node.beneficiaryStringBank account beneficiary
bank_account_numbercode.bankDetails.query.edges[0].node.bankIdStringBank account number
tax_inclusiveamountTypeBooleanfalse if "excludeTax", true otherwise

Configuration Requirements

Country Restrictions

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

IssueCauseSolution
Supplier not syncingCountry not in allowed listVerify supplier country code
Missing contact infoEmpty phone/email fieldsCheck contact data in Sage X3
Banking details missingNo bank account configuredVerify bank details in business partner
Tax configuration incorrectamountType misconfiguredReview tax settings in Sage X3