Purchase Credits

Overview

📥 Direction: NetSuite → Zudello
🔄 Sync Type: Incremental sync
⏱️ Frequency: Every 15 minutes
📋 Entity: Vendor credit memos with line items

Vendor credit memos flow from NetSuite to Zudello for tracking returns, price adjustments, and billing corrections. The integration handles absolute value conversion to ensure credits are properly represented as positive values in Zudello.

Key Benefits

✅ Absolute Value Processing - Automatic conversion of negative amounts
✅ Return Tracking - Monitor product returns and defects
✅ Price Adjustments - Handle billing corrections and discounts
✅ Bill Application - Track credits applied to vendor bills
✅ Audit Trail - Complete credit memo history for reconciliation

Processing Strategy

The integration employs specialized processing for credit memos:

• Convert negative NetSuite amounts to positive values
• Maintain credit memo relationships to original bills
• Handle both item returns and price adjustments
• Filter for posted credits only
• Support partial and full credit scenarios

Field Mappings

Header Fields

NetSuite Field	Zudello Transaction Field	Data Type	Notes
tranid	document_number	String	Credit memo number
trandate	date_issued	Date	Credit date
entity	supplier	Relation	Links to Supplier
currency	currency	Relation	Links to Currency
subsidiary	subsidiary	Relation	Links to Subsidiary
postingperiod	posting_period	String	Accounting period
appliedtolinktype	applied_to_type	String	Link type (Bill)
appliedtotransaction	applied_to_bill	Relation	Links to original bill
status	transaction_status	String	Credit status
exchangerate	exchange_rate	Decimal	Currency rate
memo	notes	String	Credit memo reason
total	total_amount	Decimal	Absolute value of total

Line Item Field Mappings

NetSuite Field	Zudello Line Field	Data Type	Notes
line	line_number	Integer	Line sequence
item	item	Relation	Links to Item (if return)
account	account	Relation	Links to Account (if adjustment)
description	description	String	Line description
quantity	quantity	Decimal	Absolute value
rate	unit_price	Decimal	Absolute value
amount	total_exclusive	Decimal	Absolute value
taxamount	tax_total	Decimal	Absolute value
grossamt	total_inclusive	Decimal	Absolute value
department	department	Relation	Links to Department
class	classification	Relation	Links to Classification
location	location	Relation	Links to Location
isbillable	is_billable	Boolean	Billable flag

API Configuration

SuiteQL Query Structure

Specialized query handling:

• Transaction table filtered for VendCred type
• TransactionLine with absolute value conversion
• Applied-to relationships for bill tracking
• Status filtering for posted credits only

Query Filters

• transaction.type = 'VendCred' - Vendor credits only
• transaction.status = 'Posted' - Posted transactions
• transactionline.mainline = 'F' - Exclude headers
• transactionline.taxline = 'F' - Exclude tax lines
• ABS() functions for amount conversion

Sync Configuration

Incremental Sync Details

• Sync Field: lastmodifieddate
• Initial Load: All posted vendor credits
• Updates: Modified credits since last sync
• Frequency: Every 15 minutes
• Special Handling: Absolute value conversion

Processing Requirements

Credits are synced when:

• Status is "Posted"
• Contains valid line items
• Not voided or deleted
• Has proper vendor reference

Special Processing Features

Absolute Value Processing

All credit amounts are converted to positive values:

Original NetSuite Values:

• Amount: -100.00
• Tax: -10.00
• Total: -110.00

Converted Zudello Values:

• Amount: 100.00
• Tax: 10.00
• Total: 110.00

Credit Application Tracking

Track relationships between:

• Credit memo and original vendor bill
• Partial vs full credit applications
• Multiple credits to single bill
• Unapplied credit balances

Return Type Classification

Item Returns:

• Physical product returns
• Quantity and item reference
• Inventory impact tracking

Price Adjustments:

• Billing corrections
• Service credits
• Account-based adjustments

Document Classification

All credits set with:

• Module: "ACCOUNTS_PAYABLE"
• Submodule: "CREDIT"
• Document Type: "VENDOR_CREDIT"
• Amount Sign: Always positive

Processing Logic

Absolute Value Conversion

For each amount field:
  zudello_amount = ABS(netsuite_amount)
  
Special handling:
  - Preserve credit nature through document type
  - Maintain positive values for processing
  - Track original bill relationships

Line Type Processing

1. Identify line type (item return vs adjustment)
2. Apply absolute value to all amounts
3. Preserve quantity signs for returns
4. Map appropriate account/item references
5. Include all dimension allocations

Application Status

NetSuite Status	Zudello Status	Description
Open	OPEN	Unapplied credit
Partially Applied	PARTIAL	Some credit used
Fully Applied	APPLIED	Fully utilized
Posted	POSTED	Available for use
Voided	VOIDED	Cancelled credit

Troubleshooting

Issue	Cause	Solution
Negative amounts showing	Absolute value not applied	Verify ABS() processing
Missing credit memos	Status filtering	Check posted status
Wrong bill reference	Applied-to link missing	Verify bill relationships
Line items missing	Filter too restrictive	Check line type flags
Dimension data gaps	Mapping incomplete	Configure dimensions
Currency conversion errors	Rate calculation	Verify exchange rates
Partial credits wrong	Application tracking	Check credit allocations

Related Documentation

• Purchase Invoices - Original vendor bills
• Suppliers - Vendor master data
• Items - Product returns configuration
• Accounts - Adjustment account setup
• Vendor Credits - Outbound credit processing
• Departments - Department allocations
• Tax Rates - Tax credit handling