Skip to main content

Debit Memo Field Mappings: Zuora to NetSuite Sync (Invoice Settlement Enabled)

Zuora

Debit Memo Field Mappings: Zuora to NetSuite Sync (Invoice Settlement Enabled)

This feature is currently in development and is subject to change without advance notice. We are actively soliciting feedback from a small set of early adopters.

This reference describes the mappings of the Debit Memo sync from Zuora to NetSuite. Note that the Debit Memo sync is supported only if Invoice Settlement is enabled for your Zuora tenant.

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

Debit Memo Field Mappings

The Destination column lists the default names for the fields in NetSuite. Your fields may have been modified from the default values.

Source Field Destination Field Notes

Account.IntegrationId__NS

Customer

 

Account.Currency

Currency

Defaulted by NetSuite from NetSuite Customer record.

DebitMemo.Amount

n/a

This is the total amount of the debit memo. NetSuite will automatically calculate the existing Total field.

n/a

Class

If not populated, map from NetSuite Connector preference NetSuite Default Location if populated. See NetSuite Classifications for more information.

n/a

Department

If not populated, map from NetSuite Connector preference NetSuite Default Location if populated. See NetSuite Classifications for more information.

n/a

Location

If not populated, map from NetSuite Connector preference NetSuite Default Location if populated. See NetSuite Classifications for more information.

DebitMemo.TotalAmountWithoutTax

Zuora Amount Without Tax

This is a custom field because we load tax as item.

DebitMemo.TaxAmount

Zuora Tax Amount

 

DebitMemo.TotalTaxExemptAmount

Zuora Tax Exempt Amount

 

DebitMemo.CreatedDate

Zuora Created Date

 

DebitMemo.Id

External Id

 

DebitMemo.Id

Zuora ID

 

n/a

Zuora Origin

"ZUORA"

n/a

Zuora Type

"DEBIT_MEMO"

n/a

Zuora Sync Date

Current timestamp

n/a

Posting Period

Required if enabled. Set automatically by NetSuite based on Invoice Date.

DebitMemo.MemoNumber

Zuora Reference Number

 

DebitMemo.MemoNumber

Transaction Number (tranId)

If NetSuite Connector preference Transaction Number Mapping is Use Number From Source Record, map the Zuora Number; otherwise, leave it blank and let NetSuite default to the next number (assuming NetSuite Auto-generated Numbers are enabled).

DebitMemo.TargetDate

Zuora Target Date

 

DebitMemo.PostedOn

Zuora Posted Date

 

DebitMemo.UpdatedDate

Zuora Updated Date

 

DebitMemo.DueDate

dueDate

 

DebitMemo.IntegrationId__NS

Internal ID

Update Zuora after initial creation only

DebitMemo.IntegrationStatus__NS

n/a

Update Zuora after sync. See Integration Status and Error Recovery for more information.

DebitMemo.SyncDate__NS

n/a

Update Zuora after initial creation only. Current timestamp.

n/a

Taxable (isTaxable)

If NetSuite Connector Advanced Setting Use Standard Invoice Sync is Yes, this field is forced to "false" to prevent NetSuite from calculating the tax. Otherwise, no value is mapped and NetSuite will set it based on the NetSuite Customer record.

n/a

Tax (taxItem)

Mapped from NetSuite Connector preference NetSuite Default Tax Code if populated.

Debit Memo Item Field Mappings

The Destination column lists the default names for the fields in NetSuite. Your fields may have been modified from the default values.

Source Field Destination Field Notes

ProductRatePlanCharge.IntegrationId__NS

Item (item.internalId)

NetSuite item reference

DebitMemoItem.Id

Zuora ID

 

DebitMemoItem.AmountWithoutTax

Amount

Charge Amount is the amount on the Transaction line.

DebitMemoItem.ChargeDate

Charge Date

Charge Date is the date of the transaction line.

DebitMemoItem.Quantity

Quantity

 

DebitMemoItem.ProcessingType

Zuora Item Type

For example, "Charge"

DebitMemoItem.ServiceStartDate

Rev. Rec. Start Date

Rev. Rec. End Date

Service Start Date

Service End Date

Defer Rev Rec.

Rev. Rec. Schedule

See Detailed Delayed Revenue Recognition Rules.

DebitMemoItem.ServiceEndDate

Subscription.SubscriptionEndDate

ProductRatePlanCharge.RevRecCode

ProductRatePlanCharge.RevRecStart__NS

ProductRatePlanCharge.RevRecEnd__NS

ProductRatePlanCharge.RevRecTemplateType__NS

ProductRatePlanCharge.Name

RatePlanCharge.RevRecCode

Subscription.Name

Zuora Subscription Number

 

Subscription.Notes

Zuora Subscription Notes

 

Subscription.Project__NS

Job (job.internalId)

NetSuite Project reference

n/a

itemList.replaceAll

"false". Only applicable for updating Invoice for delayed revenue recognition.

Zuora Debit Memo Taxation Item Field Mappings

The Destination column lists the default names for the fields in NetSuite. Your fields may have been modified from the default values. 

Source Field Destination Field Notes

DebitTaxationItem.AccountingCode

Item (item.internalId)

NetSuite Item reference for the "tax item".

DebitTaxationItem.Id

Zuora ID

 

DebitTaxationItem.TaxAmount

Amount

 

DebitTaxationItem.TaxDate

Zuora Charge Date

The Transaction line date

DebitTaxationItem.TaxRateDescription

Zuora Tax Rate Description