Skip to main content

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

Zuora

Credit 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 Credit Memo sync from Zuora to NetSuite when Invoice Settlement is enabled for your Zuora tenant.

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

Credit 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

NetSuite Customer reference

n/a

Currency

Defaulted by NetSuite from NetSuite Customer record.

CreditMemo.MemoDate

Date (tranDate)

 

CreditMemo.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).

CreditMemo.MemoNumber

Zuora Reference Number

 

CreditMemo.TotalAmountWithoutTax

Zuora Amount Without Tax

 

CreditMemo.CreatedDate

Zuora Created Date

 

CreditMemo.PostedOn

Zuora Posted Date

 

CreditMemo.TargetDate

Zuora Target Date

 

CreditMemo.UpdatedDate

Zuora Updated Date

 

n/a

Zuora Sync Date

Current timestamp

CreditMemo.Id

Zuora ID

 

n/a

Zuora Origin

 

n/a

Zuora Type

"CREDIT_MEMO"

CreditMemo.TaxAmount

Zuora Tax Amount

 

CreditMemo.TotalTaxExemptAmount

Zuora Tax Exempt Amount

 

CreditMemo.Id

External Id

 

n/a

Department

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

n/a

Class

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.

CreditMemo.IntegrationId__NS

Internal Id

Update Zuora after initial creation only.

CreditMemo.IntegrationStatus__NS

n/a

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

CreditMemo.SyncDate__NS

n/a

Update Zuora after initial creation only. Current timestamp.

CreditMemo.Comments

Memo

 

DebitMemo.IntegrationId__NS AND/OR Invoice.IntegrationId__NS

ApplyTo.Doc

 

CreditMemoPart.Amount

ApplyTo.Amount

 

Credit 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

CreditMemoItem.AmountWithoutTax

Amount

 

CreditMemoItem.Id

Zuora ID

 

CreditMemoItem.ChargeDate

Zuora Charge Date

 

CreditMemoItem.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.

CreditMemoItem.ServiceEndDate

Subscription.SubscriptionEndDate

ProductRatePlanCharge.RevRecCode

ProductRatePlanCharge.RevRecStart__NS

ProductRatePlanCharge.RevRecEnd__NS

ProductRatePlanCharge.RevRecTemplateType__NS

ProductRatePlanCharge.Name

RatePlanCharge.RevRecCode

Subscription.Notes

Zuora Subscription Notes

 

Subscription.Name

Zuora Subscription Number

 

Subscription.Project__NS

Job (job.internalId)

NetSuite Project reference

Credit 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

CreditTaxationItem.AccountingCode

Item (item.internalId)

NetSuite Item reference for the "tax item".

CreditTaxationItem.Id

Zuora ID

 

CreditTaxationItem.TaxAmount

Amount

 

CreditTaxationItem.TaxDate

Zuora Charge Date

The Transaction line date

CreditTaxationItem.TaxRateDescription

Zuora Tax Rate Description

 

n/a

Taxable (isTaxable)