Skip to main content

Invoice Item Adjustment Field Mappings: Zuora to NetSuite Sync

Zuora

Invoice Item Adjustment Field Mappings: Zuora to NetSuite Sync

This reference describes the mappings of the invoice item adjustment information sync from Zuora to NetSuite. "Credit" and "Charge" adjustments are synced as Credit Memos and Invoices, respectively, in NetSuite. See Invoice Item Adjustment Transaction Sync overview for more details on how the adjustments are linked to the NetSuite transaction representing the original Zuora Inovice.

In some cases, the Source and Destination fields are associated with different objects.

Invoice Item Adjustment

Source Field Destination Field
(Credit Memo/Invoice)
Notes
Account.NS_IntegrationId Customer NetSuite Customer reference
InvoiceItemAdjustment.AdjustmentDate Date (tranDate)  
InvoiceItemAdjustment.AdjustmentNumber Credit # OR Invoice # (tranId)
Zuora Reference Number
If NetSuite Connector preference Transaction Number Mapping is Use Number From Source Record, map the Zuora Number, otherwise leave blank and let NetSuite default to the next number (assuming NetSuite Auto-generated Numbers are enabled).
InvoiceItemAdjustment.Comment Memo  
InvoiceItemAdjustment.CreatedDate Zuora Created Date  
InvoiceItemAdjustment.Id Zuora ID  
InvoiceItemAdjustment.InvoiceNumber Zuora Related Reference Number  
Invoice.IntegrationId__NS Zuora Related Transaction NetSuite Invoice reference
InvoiceItemAdjustment.ReferenceId Zuora Reference ID  
InvoiceItemAdjustment.Type Zuora Adjustment Type  
n/a Zuora Type "INVOICE_ITEM_ADJUSTMENT"
n/a Zuora Sync Date Current timestamp
InvoiceItemAdjustment.IntegrationId__NS Internal Id Update Zuora after sync
InvoiceItemAdjustment.SyncDate__NS n/a Update Zuora after sync. Use the current timestamp.
InvoiceItemAdjustment.IntegrationStatus__NS n/a Update Zuora after sync. See Integration Status and Error Recovery for more information. 
Invoice.IntegrationId__NS ApplyTo.Invoice (doc) NetSuite Invoice reference. Only populated for Credit-type Adjustments.
InvoiceItemAdjustment.Amount ApplyTo.Amount Only populated for Credit-type Adjustments.
n/a Taxable (isTaxable) If NetSuite Connector Advanced Setting Use Standard Invoice Sync is Yes, force to "false" to prevent NetSuite from calculating tax. Otherwise no value is mapped and NetSuite will set based on the NetSuite Customer record.
n/a Tax (taxItem) Mapped from NetSuite Connector preference NetSuite Default Tax Code if populated.
Account.Class__NS Class If not populated, map from NetSuite Connector preference NetSuite Default Class if populated. See NetSuite Classifications for more information.
Account.Department__NS Department If not populated, map from NetSuite Connector preference NetSuite Default Department if populated. See NetSuite Classifications for more information.
Account.Location__NS Location If not populated, map from NetSuite Connector preference NetSuite Default Location if populated. See NetSuite Classifications for more information.

Invoice Item Adjustment Details

The Item referenced on the Zuora Invoice Item Adjustment is synced as NetSuite transaction line item.

Source Field Destination Field
(Credit Memo/Invoice
Line Item)
Notes
ProductRatePlanCharge.IntegrationId__NS
TaxationItem.AccountingCode
Internal ID NetSuite item reference. If Adjustment.SourceType="InvoiceItem," lookup and map IntegrationId__NS from Zuora Charge, otherwise lookup and map AccountingCode from Zuora Tax.
InvoiceItemAdjustment.Amount Amount  

ProductRatePlanCharge.RevRecCode
ProductRatePlanCharge.RevRecStart__NS
ProductRatePlanCharge.RevRecEnd__NS
ProductRatePlanCharge.RevRecTemplateType__NS
ProductRatePlanCharge.RevRecTriggerCondition
InvoiceItem.RevRecStartDate
InvoiceItem.ServiceStartDate
InvoiceItem.ServiceEndDate
Subscription.SubscriptionEndDate

Rev. Rec. Start Date
Rev. Rec. End Date
Service Start Date
Service End Date
Rev. Rec. Schedule

See Detailed Delayed Revenue Recognition Rules.
Account.Class__NS Class If NetSuite Connector preference Invoice Line Class Mapping is Zuora Charge, no value will be mapped and NetSuite will default from the NetSuite Item reference. If Zuora Account, the value is mapped from the Zuora Account. See NetSuite Classifications for more information.
Account.Department__NS Department If NetSuite Connector preference Invoice Line Department Mapping is Zuora Charge, no value will be mapped and NetSuite will default from the NetSuite Item reference. If Zuora Account, the value is mapped from the Zuora Account. See NetSuite Classifications for more information.
Account.Location__NS Location If NetSuite Connector preference Invoice Line Location Mapping is Zuora Charge, no value will be mapped and NetSuite will default from the NetSuite Item reference. If Zuora Account, the value is mapped from the Zuora Account. See NetSuite Classifications for more information.
n/a Tax (isTaxable) If NetSuite Connector Advanced Setting Use Standard Invoice Sync is Yes, force to "false" to prevent NetSuite from calculating tax. Otherwise no value is mapped and NetSuite will set based on the NetSuite Item record.
Subscription.Project__NS Job (job.internalId) NetSuite Project reference