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 | Rev. Rec. Start Date | 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 |