Skip to main content
Version: Current

Payment Terms

Overview​

The NetSuite Payment Terms integration synchronizes payment term configurations from NetSuite to Zudello, ensuring consistent payment scheduling and accurate cash flow management across systems.

Integration Details:

  • Direction: NetSuite → Zudello (📥 Inbound)
  • Sync Type: Incremental
  • Sync Frequency: Every 12 hours
  • API Used: SuiteQL
Key Benefits
  • Consistent payment term definitions
  • Automated payment due date calculations
  • Supports complex payment schedules
  • Enables accurate cash flow forecasting

Field Mappings​

NetSuite FieldZudello FieldDescriptionData Type
nameTermsNamePayment terms identifierString
daysuntilnetdueNetDaysNet payment daysInteger
discountdaysDiscountDaysEarly payment discount daysInteger
discountpercentDiscountPercentEarly payment discount percentageDecimal
isinactiveStatustrue = INACTIVE, false = ACTIVEString
dateDrivenDateDrivenDate-driven calculation flagBoolean
duenextmonthifwithindaysNextMonthThresholdNext month due thresholdInteger
discountdayofmonthDiscountDayOfMonthSpecific discount dayInteger
duedayofmonthDueDayOfMonthSpecific due dayInteger
gratuitousNoChargeNo charge indicatorBoolean
installmentInstallmentInstallment payment flagBoolean

API Configuration​

SuiteQL Query Structure​

The integration queries payment terms with comprehensive calculation rules for accurate payment scheduling and discount management.

Authentication​

  • Method: Token-based Authentication (TBA)
  • Required Permissions:
    • Terms (View)
    • Lists → Accounting (View)
    • Payment Terms (View)

Sync Configuration​

Incremental Sync Logic​

The integration tracks payment term changes:

  • Initial sync retrieves all payment term configurations
  • Subsequent syncs fetch terms where lastmodifieddate > last sync timestamp
  • Calculation rules updated with term modifications
  • Historical terms preserved for existing transactions

Data Transformation​

  • Status Conversion: NetSuite boolean isinactive (T/F) → Zudello string status (INACTIVE/ACTIVE)
  • Calculation Rules: Preserves complex payment calculation logic
  • Discount Validation: Ensures discount percentages are within valid ranges

Processing Logic​

  1. Terms Retrieval: Query modified payment terms
  2. Calculation Validation: Verify payment calculation rules
  3. Discount Processing: Handle early payment discount rules
  4. Date Logic: Process date-driven calculation options
  5. Status Management: Update active/inactive term flags
  6. Rule Consistency: Ensure calculation rule integrity

Troubleshooting​

IssuePossible CauseSolution
Missing payment termsPermission restrictionsVerify Terms view permissions
Calculation errorsComplex rule conflictsReview calculation logic
Discount mismatchesPercentage validationCheck discount range limits
Date calculation issuesTimezone differencesVerify date handling
Performance slowdownLarge terms datasetOptimize query conditions