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