Skip to main content
Version: Current

Vendor Credits

Overview

The Vendor Credits integration creates vendor credit records in NetSuite from Zudello credit note data.

Direction: 📤 Zudello → NetSuite
Type: Real-time sync
API: NetSuite SOAP API
Frequency: On-demand processing

Key Benefits
  • Real-time vendor credit creation
  • Automatic absolute value conversion
  • Custom field array processing
  • Support for both item and expense lines
  • Linked transaction support

Header Field Mappings

The following fields are mapped from Zudello to NetSuite vendor credit headers:

Zudello FieldNetSuite FieldDescription
CreditNoteNumbertranIdTransaction reference number
VendorCodeentityVendor reference
CreditDatetranDateTransaction date
CurrencycurrencyTransaction currency
MemomemoTransaction memo/description
LocationlocationLocation reference
DepartmentdepartmentDepartment reference
ClassclassClass reference
SubsidiarysubsidiarySubsidiary reference
AccountaccountAP account reference
AppliedToappliedToApplied transaction reference

Line Processing

Item Lines

Item-based vendor credit lines with absolute value conversion:

Zudello FieldNetSuite FieldDescription
ItemCodeitemItem reference
DescriptiondescriptionLine description
QuantityquantityItem quantity (absolute value)
RaterateUnit price (absolute value)
Amountamount/grossAmtLine amount (absolute value)
LocationlocationLine-level location
DepartmentdepartmentLine-level department
ClassclassLine-level class
TaxCodetaxCodeTax code reference
CustomercustomerCustomer reference
IsBillableisBillableBillable flag

Expense Lines

Expense-based vendor credit lines with absolute value conversion:

Zudello FieldNetSuite FieldDescription
AccountaccountExpense account reference
DescriptionmemoLine description
Amountamount/grossAmtLine amount (absolute value)
LocationlocationLine-level location
DepartmentdepartmentLine-level department
ClassclassLine-level class
TaxCodetaxCodeTax code reference
CustomercustomerCustomer reference
IsBillableisBillableBillable flag

API Configuration

SOAP API Method

The integration uses the add operation with the following configuration:

  • Record Type: VendorCredit
  • Operation: add
  • Response Handling: Captures internal ID on success

Authentication

Uses token-based authentication with:

  • Account ID
  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret

Special Processing

Absolute Value Processing

All credit amounts are automatically converted to absolute values:

  • Negative amounts become positive
  • Ensures proper credit application
  • Applies to quantity, rate, and amount fields

Custom Field Array Conversion

Custom fields support array-based processing:

  1. Array Detection

    • Identifies array-type custom fields
    • Converts single values to arrays
  2. Multi-Select Support

    • Handles multi-select list fields
    • Preserves selection order
  3. Type Conversion

    • Automatic type detection
    • Proper formatting for each field type

Applied Transaction Linking

Vendor credits can be linked to original bills:

  • Uses appliedTo field for linking
  • Supports partial application
  • Maintains audit trail

Processing Logic

Vendor Credit Creation Flow

  1. Header Preparation

    • Map standard fields
    • Convert custom field arrays
    • Set applied transaction
  2. Line Processing

    • Apply absolute value conversion
    • Determine line type
    • Process tax handling
  3. API Submission

    • Submit via SOAP API
    • Capture response
    • Store internal ID

Custom Field Processing

Custom fields undergo special processing:

  • Script ID validation
  • Array conversion for multi-select
  • Type-specific formatting
  • Null value handling

Error Handling

Common Errors

Error TypeDescriptionResolution
INVALID_REFInvalid vendor referenceVerify vendor exists in NetSuite
INVALID_FLDInvalid field valueCheck field mappings and data types
INSUFFICIENT_PERMISSIONUser lacks permissionReview user role permissions
APPLIED_TXN_NOT_FOUNDApplied transaction missingVerify bill exists in NetSuite
INVALID_ARRAY_VALUEInvalid array field valueCheck custom field configuration
NEGATIVE_AMOUNTNegative credit amountSystem auto-converts to positive

Retry Logic

  • Automatic retry for transient errors
  • Maximum 3 retry attempts
  • Exponential backoff strategy

Troubleshooting

IssuePossible CauseSolution
Credit not createdAuthentication failureVerify API credentials
Custom fields missingArray conversion issueCheck field type configuration
Application failsBill not foundEnsure bill exists before credit
Amount sign issuesManual negative entrySystem handles conversion
Multi-select errorsInvalid array formatReview custom field setup