BP Supplier Invoice
Overview
📤 Direction: Zudello → Sage X3
🔄 Sync Type: Real-time
⏱️ Frequency: Transaction-based
Business Partner Supplier Invoices flow from Zudello to Sage X3 using GraphQL mutations with comprehensive analytical dimensions and cost center allocations.
✅ Business Partner Model - Uses Sage X3's advanced business partner supplier invoice structure
✅ Analytical Dimensions - Full support for cost center and analytical tracking
✅ Chart of Accounts Integration - Leverages account group relationships for GL posting
✅ Australian Configuration - Uses "AUINV" invoice type and "AUDOM" tax rule
Field Mappings
Header Fields
| Sage X3 Field | Zudello Field | Data Type | Notes |
|---|---|---|---|
| company | subsidiary | Relation | Company reference |
| site | location | Relation | Site reference |
| invoiceType | N/A | String | Always "AUINV" |
| category | N/A | String | Always "invoice" |
| accountingDate | date_issued | Date | Invoice date (YYYY-MM-DD) |
| rateDate | date_issued | Date | Same as accounting date |
| billBySupplier | supplier | Relation | Supplier reference |
| currency | currency | Relation | Currency reference |
| sourceDocument | document_number | String | Invoice document number |
| sourceDocumentDate | date_issued | Date | Source document date |
| payToBusinessPartner | supplier | Relation | Same as billBySupplier |
| dueDateCalculationStartDate | date_due | Date | Due date |
| paymentTerm | Extracted from supplier | String | Payment term code |
| taxRule | N/A | String | Always "AUDOM" |
Line Item Fields
| Sage X3 Field | Zudello Field | Data Type | Notes |
|---|---|---|---|
| lineNumber | line_number | Integer | Line sequence number |
| site | location | Relation | Location reference |
| ledgersCoa[0].chartOfAccount | account.account_group | Relation | Chart of account reference |
| ledgersCoa[0].account | account | Relation | Account reference |
| lineAmountExcludingTax | total_exclusive | Decimal | Line amount excluding tax |
| taxCode | tax_rate | Relation | Tax code reference |
| quantity | quantity | Decimal | Line quantity |
Configuration Requirements
This integration uses fixed Australian configuration values:
- Invoice Type: Always "AUINV"
- Tax Rule: Always "AUDOM"
- Date Format: Consistent YYYY-MM-DD formatting
Processing Logic
Analytical Dimensions
The integration supports comprehensive analytical tracking:
- Cost Center Support: Full support for cost center and analytical tracking
- Dimensional Analytics: Includes amount, quantity, and dimension information
- Denormalized Index: Uses index 1 for dimension organization
Cost Centre Processing
Cost centres are processed using a combination of their name and code:
- ID Format: "costCentreName|costCentreCode"
- Extraction Logic: Splits the ID to get name and code components
- Analytical Integration: Maps to Sage X3 analytical dimensions
Payment Term Extraction
Payment terms are extracted from supplier relationships:
- ID Format: Uses the first part of a pipe-delimited ID (
|) - Supplier Relationship: Extracted from the supplier's payment term
- Code Assignment: Uses extracted code for payment term assignment
Chart of Accounts Integration
The integration leverages account group relationships:
- Account Group Reference: Uses the account's group for the chart of account
- Account Reference: Uses the account reference for the specific account
- GL Posting: Enables proper general ledger posting in Sage X3
Date Formatting
All dates use consistent YYYY-MM-DD formatting:
- Accounting Date: Uses date_issued from Zudello
- Rate Date: Same as accounting date
- Source Document Date: Uses date_issued
- Due Date Calculation: Uses date_due from Zudello
Troubleshooting
| Issue | Cause | Solution |
|---|---|---|
| Invoice creation fails | Missing supplier reference | Verify supplier exists in Sage X3 |
| Account posting errors | Invalid account references | Check account and account group setup |
| Cost centre allocation fails | Invalid cost centre ID | Verify cost centre format and existence |
| Payment term errors | Missing payment term code | Check supplier payment term configuration |