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:
- Zuora payment refund records are synced if they meet the following criteria:
- The related customer account Sync To NetSuite is set to
Yesor is empty. - The Status is
Posted. - The Transferred to Accounting is either
No,Error, orProcessing. - The Refund Date is greater than or equal to the Refund Cutover Date (if specified in the NetSuite Connector Advanced Settings).
- The related customer account Sync To NetSuite is set to
- 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.
- The Zuora payment's Integration Status is updated to
Updating Paymentand Transferred to Accounting updated toProcessingto indicate that the record is currently being synced and to assist with error recovery. - 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.
- The Zuora payment's Integration Status is updated to
Creating Refundto indicate the record is currently being synced and to assist with error recovery. - Create a new NetSuite customer refund and references that NetSuite payment. This refunds the payment's unapplied balance.
- 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 Completeand Transferred to Accounting is set toYes.
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
Nullin the API will appear asNoin the Zuora UI. - See NetSuite Classifications for information about how classifications are mapped for NetSuite transaction header and details.