Invoice transaction sync rules
Rules according to which this integration syncs records
This integration syncs records according to the following rules:
- Zuora invoice 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 set to
No,Error, orProcessing. - The Invoice Date is greater than or equal to the Invoice Cutover Date (if the date is 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 associated Zuora account has been synced (the account has an IntegrationId).
- The associated Zuora invoice item's Charge has been synced (the charge has an IntegrationId).
- The associated Zuora invoice item's Tax Code has been synced (the tax code has an Accounting Code).
- If the associated Zuora invoice item's Charge has a NetSuite Revenue Recognition Template Type of
Variable, the associated Zuora subscription's NetSuite Project must be populated. - 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 invoice's Integration Status is updated to
Creating InvoiceorCreating Credit Memoand Transferred to Accounting is updated toProcessingto indicate the record is currently being synced and to assist with error recovery. - If the Invoice amount is greater than or equal to 0, a NetSuite invoice is created. Otherwise a NetSuite credit memo is created.
- Upon successful creation of the NetSuite invoice, the new NetSuite internal ID is written to the Zuora invoice record, the Integration Status is updated to
Sync Complete, and Transferred to Accounting is updated toYes.
Transaction sync notes
- Once synced successfully, changes to the Zuora invoice will not be synced, including cancellations.
- Use invoice item adjustments to make changes to the invoice amounts.
- If you need to resync an Invoice, you must delete the NetSuite invoice and set the Zuora invoice's Transferred to Accounting to
No. - Transferred to Accounting values of
Nullin the API will appear asNoin the Zuora UI. - When you sync Zuora invoices to Netsuite, ordering line items in an invoice is not supported when the invoice has no associated charge.