Welcome to Zuora Product Documentation

Explore our rich library of product information

Refund transaction sync rules: Zuora to NetSuite

Process that syncs Zuora payment refunds (as opposed to credit balance refunds) to NetSuite customer refunds

This process syncs Zuora payment refunds (as opposed to credit balance refunds) to NetSuite customer refunds. This is a two-step sync. First, it updates the existing NetSuite payment to "unapply" the amount applied to the original invoices (which reopens the invoices' balance). Then it creates a new NetSuite customer refund to refund that payment's open balance. This prevents the NetSuite payment's open balance from being applied to another transaction.

This integration syncs records according to the following rules:

  1. Zuora payment refund records are synced if they meet the following criteria:
    • The related customer account Sync To NetSuite is set to Yes or is empty.
    • The Status is Posted.
    • The Transferred to Accounting is either No, Error, or Processing.
    • The Refund Date is greater than or equal to the Refund Cutover Date (if specified in the NetSuite Connector Advanced Settings).
  2. The following validations are performed during the sync to ensure data integrity:
    • The Zuora payment method matches a valid NetSuite payment method. See Reconcile Data Between Zuora and NetSuite for more information.
    • The associated Zuora payment 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 payment's Integration Status is updated to Updating Payment and Transferred to Accounting updated to Processing to indicate that the record is currently being synced and to assist with error recovery.
  4. Update the referenced NetSuite payment to unapply the given amount from its invoice (or multiple invoices). This results in an unapplied balance for that NetSuite payment.
  5. The Zuora payment's Integration Status is updated to Creating Refund to indicate the record is currently being synced and to assist with error recovery.
  6. Create a new NetSuite customer refund and references that NetSuite payment. This refunds the payment's unapplied balance.
  7. Upon successful creation of the NetSuite refund, the new NetSuite internal ID is written back to the Zuora refund record, the Integration Status is set to Sync Complete and Transferred to Accounting is set to Yes.

Sync notes

  • Once synced successfully, changes to the Zuora refund will not be synced, including cancellations. If you need to resync a refund, you must manually delete the NetSuite refund, reapply the original payment amounts, and set the Zuora refund's Transferred to Accounting to No. If a refund is voided or canceled before it is picked up by the sync, the refund will be ignored.
  • Transferred to Accounting values of Null in the API will appear as No in the Zuora UI.
  • See NetSuite Classifications for information about how classifications are mapped for NetSuite transaction header and details.

Refund transaction sync flow: Zuora to NetSuite

overview_refund_txn.png