Payment Transaction Sync (Invoice Settlement Enabled)
Overview
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 integration syncs applied, unapplied, and unassigned payments to and from NetSuite payments with Zuora if Invoice Settlement is enabled for your Zuora Tenant. The payment integration is implemented as two separate syncs: Zuora payments to NetSuite and NetSuite payments to Zuora.
About the Payment Transaction Sync (Invoice Settlement Enabled)
Custom fields will be added to the NetSuite payment object:
- Only processed payments will be synced to NetSuite.
- One payment may be applied to one or more invoices.
- No actual credit card data will be synced in either direction.
- The accounting code for the payment is determined by the payment method and is configured and maintained manually within the associated NetSuite Payment Method.
- Payments that are voided or canceled before they are transferred to accounting will not be synced.
- A payment that has been transferred to accounting cannot be voided.
- Overpayments and partial payments are supported.
Review the Transaction Sync Preferences. These preferences are important, and they control the behavior and data mapping of the sync, including the payment number.
Transaction Sync Notes
- Either payment sync can be disabled completely from the NetSuite Connector Advanced Settings page. However, you should disable this only under the guidance of Zuora Global Services.
- The NetSuite Payment sync is disabled by default. To enable it, go to the NetSuite Connector Advanced Settings.
- The Zuora Payment sync will not execute if Zuora does not calculate taxes (if the NetSuite Connector Advanced Setting for Use Standard Invoice Sync is false).
- To sync ‘unassigned’ payments, ensure that the “Unassigned Payments” field is populated with the internal ID of an appropriately designated NetSuite customer account.
Payment Transaction Sync Rules: Zuora to NetSuite
This process syncs Zuora payments to NetSuite customer payments.
This integration syncs records according to the following rules:
- Zuora Payment records are synced if they meet the following criteria:
- The related customer account option Sync To NetSuite is not set or set to
Yes
. - The Status is
Processed
. - The Transferred to Accounting status is
No
,Error
, orProcessing
. - The Effective Date is greater than or equal to the Payment Cutover Date (if the value is specified in the NetSuite Connector Advanced Settings).
- The related customer account option Sync To NetSuite is not set or 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 invoices have been synced (they have 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
Creating Payment
and Transferred to Accounting is updated toProcessing
to indicate the record is currently being synced and to assist with error recovery. - If the Zuora payment is applied to more than one invoice or debit memo, the NetSuite payment will also be applied to multiple invoices and/or debit memos.
- Upon successful creation of the NetSuite payment, the new NetSuite internal ID is written back to the Zuora payment record, the Integration Status is set to
Sync Complete
, and Transferred to Accounting is set toYes
.
Sync Notes
- With Invoice Settlement enabled, you can apply, unapply, or transfer a payment. After a payment is synced successfully, Transferred to Accounting will be set to
Yes
. To sync changes on this payment record, you must update the Transferred to Accounting value toNo
. - Transferred to Accounting value of
Null
in the API will appear asNo
in the Zuora UI. - See NetSuite Classifications for information about how classifications are mapped for NetSuite transaction header and details.
- Credit card data is not transferred.
Deposit-To Account Information
The Deposit-To account is where the payment amount will be placed. This is determined by the Deposit-To account configured on the referenced payment method within NetSuite. NetSuite Connector does not use the Accounting Code field on the Zuora payment method.
Payment Transaction Sync Rules: NetSuite to Zuora
This process syncs NetSuite customer payments to Zuora payments.
This integration syncs records according to the following rules:
- NetSuite payment records are synced if they meet the following criteria:
- The related customer account must be synced (the Zuora Customer ID cannot be empty).
- The payment must be applied to at least one invoice or debit memo that came from Zuora (where transaction type is
invoice
and Zuora ID is not empty), or fully unapplied (the Amount Remaining is greater than 0 and Amount Paid is 0). - The Zuora Origin is not
ZUORA
. - If the payment is fully applied, it must be applied to at least one invoice or debit memo that came from Zuora (where transaction type is
invoice
and Zuora ID is not empty). - The Zuora Sync Updates field is
Yes
.
- The following validations are performed during the sync to ensure data integrity:
- The associated Zuora invoice or debit memo has been synced (it has an Integration ID), if there is one.
- The NetSuite payment method matches a valid Zuora payment method.
- The NetSuite payment’s Integration Status is updated to
Creating Payment
to indicate the record is currently being synced and to assist with error recovery. - If the NetSuite payment is applied to more than one Zuora invoice or debit memo, the Zuora payment will also be applied to multiple invoices and/or debit memos.
- After creating the Zuora payment successfully, the new Zuora ID is written back to the NetSuite payment record and the Integration Status is set to
Sync Complete
.
Sync Notes
- With Invoice Settlement enabled, you can apply, unapply, or transfer a payment. After a payment is synced successfully, changes will continue to sync so long as the Effective Date is greater than or equal to the Payment Cutover Date if the value is specified in the NetSuite Connector Advanced Settings.
- If you need to resync a payment, you must manually cancel the Zuora payment and clear the Integration Status and Zuora ID fields on the NetSuite payment.