Skip to main content

Invoice Item Adjustment Transaction Sync

Zuora

Invoice Item Adjustment Transaction Sync

Overview

This integration syncs Zuora invoice item adjustments to NetSuite for invoices that have been previously synced. Credit-type adjustments are synced as credit memos and charge-type adjustments are synced as invoices.

About the Invoice Item Adjustment Sync Transaction

  • Each invoice item adjustment is synced as a separate transaction in NetSuite.
  • Zuora Billing has a tenant permission to restrict advanced invoice adjustment functionality. The Zuora user cannot adjust negative invoice items on a positive invoice, or positive invoice items on a negative invoice. Do not use invoice adjustments with NetSuite Connector. Zuora does not allow complex or compound invoice item adjustments: Each adjustment is independent, and if a user creates adjustments for two items in the user interface, then Zuora creates two invoice item adjustments. NetSuite does not have the concept of debit memos. The closest object in NetSuite is an invoice. 
  • Review the Transaction Sync preferences. These preferences are important and control the behavior and data mapping of the sync including Invoice item Adjustment Number.

Transaction Sync Notes

  • You can disable the invoice item adjustment sync from the NetSuite Connector Advanced Settings. However, you should disable this only under the guidance of Zuora Services.
  • The Zuora invoice item adjustment sync will not execute if Zuora does not calculate taxes (if the NetSuite Connector Advanced Setting for Use Standard Invoice Sync is set to false).
  • Transferred to Accounting values of Null in the API will appear as No in the Zuora UI. 

Invoice Item Adjustment Transaction Sync Rules

This integration syncs records according to the following rules:

  1. Zuora invoice item adjustment records are synced if they meet the following criteria:
    • The Status is Processed.
    • The Transferred to Accounting is No, Error, or Processing.
    • The Adjustment Date is greater than or equal to the Invoice item Adjustment Cutover Date (if specified in the NetSuite Connector Advanced Settings).
  2. The following validations are performed during the sync to ensure data integrity:
    • The associated Zuora invoice has been synced (it has an IntegrationID).
    • If populated, the associated Zuora account's NetSuite Location matches a valid NetSuite location.
    • If populated, the associated Zuora Account's NetSuite Class matches a valid NetSuite class.
    • If populated, the associated Zuora Account's NetSuite Department matches a valid NetSuite department.
  3. The Zuora invoice item adjustment’s Integration Status is updated to Creating Invoice or Creating Credit Memo and Transferred to Accounting updated to Processing to indicate the record is currently being synced and to assist with error recovery.
  4. If the Adjustment Type is Credit, a NetSuite credit memo is created and applied (using the native NetSuite applied transaction functionality) to the existing NetSuite invoice that was synced from the original Zuora invoice.
  5. If the Adjustment type is Charge, a NetSuite invoice is created. If the original Zuora invoice was positive, a soft link is established using the Related Transaction custom field to relate the original invoice with the new invoice from the adjustment. This soft link is for reference only and has no accounting impact. The original invoice’s balance as displayed in NetSuite is unaffected. If the original Zuora invoice was negative (and was synced to NetSuite as a credit memo), the new invoice from the adjustment is applied to that existing credit memo by updating the credit memo and using the native NetSuite applied transaction functionality.
  6. Upon successful creation of the NetSuite invoice or credit memo, the new NetSuite internal ID is written to the Zuora invoice item adjustment record, the Integration Status is set to Sync Complete, and Transferred to Accounting is set to Yes.

Invoice Item Adjustment Transaction Sync Process Flow

 

overview_invoiceitemadjustment_txn.png

  1.