Payment Term

Overview

📥 Direction: Sage X3 → Zudello
🔄 Sync Type: Incremental sync
⏱️ Frequency: Based on _updateStamp

Payment term data flows from Sage X3 to Zudello with intelligent type detection and unit extraction to support flexible payment configurations.

Key Benefits

✅ Intelligent Processing - Automatically determine payment term types from descriptions
✅ Unit Extraction - Extract numeric values from payment term codes
✅ Flexible Types - Support multiple payment term types (days after date, end of month, etc.)
✅ Australian Focus - Filtered for Australian legislation

Field Mappings

Zudello Field	Sage X3 Field	Data Type	Notes
code	code	String	Payment term code
name	localizedDescription or localizedShortDescription or code	String	Fallback hierarchy
type	Calculated from description	String	Intelligent type detection
unit	Extracted from code	String	Numeric value extraction
status	N/A	String	Always "ACTIVE"

Configuration Requirements

Australian Legislation

This integration filters for Australian legislation only. Payment terms must be configured with 'AUS' legislation in Sage X3.

Processing Logic

Sync Behavior

• Intelligent Type Detection: Automatically determines payment term types from descriptions
• Unit Extraction: Extracts numeric values from payment term codes using pattern matching
• Keyword Analysis: Uses keyword matching for type determination

Type Detection Logic

The system automatically determines payment term types based on description keywords:

DAYS_AFTER_MONTH

• Keywords: "end of month", "eom"

OF_CURRENT_MONTH

• Keywords: "current month", "of month", "this month"

OF_FOLLOWING_MONTH

• Keywords: "following month", "next month", "subsequent month"

DAYS_AFTER_DATE (Default)

• Keywords: "net", "invoice date", "from invoice", "after invoice", "days net"
• Also used as fallback when no keywords match

Unit Extraction Logic

The system extracts numeric values from payment term codes:

• Pattern Matching: Uses regex to find first number in code
• Default Value: Returns "1" if no number found
• First Match: Returns first numeric value found in code

Payment Term Types

The integration supports various payment term configurations:

• Days After Date: Standard net payment terms
• End of Month: Payments due at month end
• Current Month: Payments due within current month
• Following Month: Payments due in subsequent month

Troubleshooting

Issue	Cause	Solution
Payment term not syncing	Legislation not set to 'AUS'	Verify legislation configuration in Sage X3
Incorrect type detection	Ambiguous description	Review description keywords in Sage X3
Unit extraction failure	No numeric values in code	Include numeric values in payment term codes
Type defaults to DAYS_AFTER_DATE	Keywords not recognized	Check description against keyword list

Related Documentation

• Supplier - Vendor payment term assignments
• BP Supplier Invoice - Payment term usage in transactions
• Currency - Currency-specific payment terms
• Tax Solution - Tax and payment term relationships