Payment Terms
Overview
Direction: Business Central → Zudello
Sync Type: Incremental sync
Entity: Payment terms and due date rules
Payment terms data flows from Business Central to Zudello to ensure consistent payment scheduling and due date calculations across purchase transactions.
Payment Terms Features
- Due Date Calculation - Automatic payment due date determination
- Numeric Extraction - Smart parsing of days from text descriptions
- Standardized Type - Consistent "DAYS_AFTER_DATE" processing
- Supplier Integration - Link payment terms to vendor records
Field Mappings
| Zudello Field | Business Central Field | Data Type | Notes |
|---|---|---|---|
| code | code | String | Payment terms code |
| name | displayName | String | Payment terms description |
| type | N/A | String | Always set to "DAYS_AFTER_DATE" |
| unit | dueDateCalculation, displayName | Decimal | Extracted numeric value for days |
| status | N/A | String | Always set to ACTIVE |
Processing Logic
Days Extraction
To determine the number of days for a payment term, the integration intelligently extracts the first numeric value it finds in the term's dueDateCalculation or displayName field. For example, a term named "Net 30 Days" will result in 30 being extracted. If no number is found, it defaults to 0.
Data Processing
- Source Fields: The system first checks the
dueDateCalculationfield for a value, and if it's empty, it checks thedisplayNamefield. - Default Fallback: If no numeric value can be found in either field, the number of days is set to
0. - Type Consistency: All payment terms are standardized to a "days after date" format for consistent processing in Zudello.
Common Payment Terms
| Business Central Code | Description | Extracted Days | Usage |
|---|---|---|---|
| NET30 | Net 30 Days | 30 | Standard 30-day terms |
| NET15 | Net 15 Days | 15 | Short-term payment |
| NET60 | Net 60 Days | 60 | Extended payment period |
| COD | Cash on Delivery | 0 | Immediate payment |
| EOM | End of Month | 30* | Month-end processing |
*Note: EOM terms may require special handling
Troubleshooting
| Issue | Cause | Solution |
|---|---|---|
| Wrong due dates | Incorrect unit extraction | Check text format in BC payment terms |
| Zero days extracted | No numeric values in text | Add numeric value to description |
| Missing terms | Not syncing from BC | Verify payment terms exist in Business Central |
| Calculation errors | Complex term logic | Use standard day-based descriptions |