No Records Found to Sync

Error Message

No records found to sync.

Sync Process

Any

Cause

No records of the given type (for example, Account, Charge, or Invoice) were found that match the sync criteria.

Resolution

Confirm that the to-be-synced record meets the sync criteria. If it does not, modify the record to meet the sync criteria.

Service Temporarily Unavailable

Error Message

First document failure: Error invoking soap operation; Caused by: The server sent HTTP status code 503: Service Temporarily Unavailable

Sync Process

Any

Cause

Sync cannot connect to Zuora or NetSuite application endpoints. Application may currently be unavailable due to maintenance downtime or network problems.

Resolution

Wait several minutes and retry the sync. If the problem persists, contact the appropriate vendor (NetSuite or Zuora) to inquire about application availability.

Unable to Get InternalId for Script ID

Error Message

First document failure: Unable to get internalId for script id: customlistzuorabillcycleday

Sync Process

Customer

Cause

Required NetSuite configuration has not been performed.

Resolution

In NetSuite, go to Setup > Company > Enable Features > SuiteFlex tab, and enable Server SuiteScript (accept agreement).

Script Execution Usage Limit Exceeded

Error Message

Netsuite warning: nullWarning received from NetSuite for record "ZD00070743 Indigovern - 20220429 000000.000"

Code: SSS_USAGE_LIMIT_EXCEEDED

Type: ERROR

Message: Script Execution Usage Limit Exceeded

Sync Process

Any

Cause

This is a limitation on the NetSuite side. NetSuite imposes restrictions on its API calls.

Resolution

Review and optimize the script execution to stay within NetSuite's API usage limits. For guidance on managing and optimizing API calls, refer to NetSuite's API documentation.

There are no Records of this Type

Error Message

NetSuite Warning: Warning received from NetSuite for record record: (Error Received during Netsuite Update

Code: RCRD_DSNT_EXIST

Type: ERROR

Message: There are no records of this type.

) null

Sync Process

Zuora account or charge to NetSuite

Cause

The Integration ID value is populated on the Zuora record but does not match a valid NetSuite internal ID, preventing the from being able to update the record. The invalid Integration ID may have been populated manually by accident, reference a record that no longer exists, or reference a record from a different NetSuite environment.

Resolution

Locate the corresponding record in NetSuite. If found, copy the NetSuite internal ID from the browser’s URL, paste into the Zuora record’s Integration ID, and run the sync. If not found, simply clear out the Zuora record’s Integration ID and run the sync to create a new record in NetSuite.

Inventory Items Must Have a Positive Amount

Error Message

Inventory items must have a positive amount.

Sync Process

Zuora Invoice (negative invoice) to NetSuite

Cause

NetSuite does not allow Inventory-type items to have negative amounts. Remember that the Zuora invoice item amounts are negated when syncing to NetSuite Credit Memos.

Resolution

Edit or regenerate the Zuora Invoice and adjust amounts for Charges with different item types. This means any Inventory-type Charges on a "negative invoice" must be edited to negative amounts.

Invalid Account Reference Key for Customer

Error Message

NetSuite Warning: Warning received from NetSuite for record record: (Error Received during Netsuite Update

Code: INVALID_KEY_OR_REF

Type: ERROR

Message: Invalid account reference key key for customer customer.) null

Sync Process

Zuora Refund to NetSuite

Cause

The GL Account reference for a Refund must match that of the original Payment. The integration retrieves the GL Account from the NS Payment Method so if the account was manually changed between when the Payment and Refund were synced, this error could result.

Resolution

Manually edit the NS Payment or Payment Method as necessary to reconcile the account references.

Invalid Account Reference Key for Entity

Error Message

NetSuite Warning: Warning received from NetSuite for record record: (Error Received during Netsuite Update

Code: INVALID_KEY_OR_REF

Type: ERROR

Message: Invalid account reference key key for entity entity.

) null

Sync Process

Zuora Refund to NetSuite

Cause

The Zuora Product Rate Plan Charge must have an assigned Accounting Code. That code must also exist for the NetSuite Item GL code.

Resolution

Make sure that the Zuora Product Rate Plan Charge has an assigned Accounting Code, and that it also exists for the NetSuite Item GL code.

TypeError: Cannot Read Property "length" from Null

Error Message

Warning received from NetSuite for record "INV00000001": (Error Received during Netsuite Update

Code: USER_ERROR

Type: ERROR

Message: TypeError: Cannot read property "length" from null (AVA_Functions.js#1)) null

Sync Process

Invoice

Cause

AVATAX users must specify a NetSuite Default Tax Code in the integration settings.

Resolution

Assign a NetSuite Default Tax Code in the Sync Preferences.

ProductRatePlanId is Invalid

Error Message

Zuora Warning: Warning received from Zuora for record record: SubscriptionData.SubscriptionRatePlanData[0].ProductRatePlanId is invalid.

Sync Process

NetSuite Sales Order

Cause

One of the Zuora items referenced on the NetSuite Sales Order does not represent a Zuora Rate Plan record. It may represent a Zuora charge by accident.

Resolution

Review the NetSuite Sales Order and remove any Zuora items that do not represent a Zuora Rate Plan. If you cannot determine the item type from the its name, open the Item record and look at the Zuora Type field. The type should be RATE_PLAN.

Invalid invoice item in subsidiary

Error Message

NetSuite Warning: Warning received from NetSuite for record "INV12283099": (Error Received during Netsuite Update)

Code: INVALID_KEY_OR_REF

Type: ERROR

Message: Invalid item reference key xxxxx for subsidiary x.

Sync Process

REST Zuora Invoice Sync to Netsuite

Cause

This Netsuite error occurs when the item added to the invoice does not belong to the subsidiary's internal ID.

Resolution

Ensure that the correct subsidiary is selected in Zuora and matches the subsidiary to which the item is assigned in NetSuite.

Invalid CUSTBODYZUORASYNCUPDATES reference key for syncing NS payments to Zuora

Error Message

Error Code: INVALID_KEY_OR_REF

Type: ERROR

Message: Invalid CUSTBODYZUORASYNCUPDATES reference key

Sync Process

NetSuite payments to Zuora

Cause

This Netsuite error occurs when you sync the Netsuite payment object to Zuora. This error is due to the edit permission not being enabled in the custom list.

Resolution

Enable edit access to the "Custom List" permission.

Attempting to Create an Amortization or Revenue Recognition Schedule Outside the Range of Available Accounting Periods

Error Message

NetSuite Warning: Warning received from NetSuite for record "INVxxxxxxx": (Error Received during Netsuite Update)

Code: MISSING_ACCT_PRD

Type: ERROR

Message: You are attempting to create an amortization or revenue recognition schedule outside the range of available accounting periods. Please adjust the periods on this transaction or go to Setup > Accounting > Manage Accounting Periods to set up more periods. )

Sync Process

Zuora Invoice

Cause

1. One or more of the Revenue Recognition Schedules referenced on one or more Zuora Invoice Item Charges extends beyond the list of Accounting Periods currently configured in NetSuite. For example, the Revenue Recognition Schedule is for 24 months but you have not created Accounting Periods two years out yet.

2. Alternatively, this error may also occur if the Revenue Recognition Template is configured with a Start Offset that falls outside the Revenue Recognition Start and End Dates for a given Item/Charge.

Resolution

1. Configure additional Accounting Periods as necessary and try again. Within NetSuite, go to Setup > Accounting > Manage Accounting Periods.

2. Review the Revenue Recognition Template configuration within NetSuite (Lists > Accounting > Revenue Recognition Templates), verify the Revenue Recognition Start and End Dates encompass any Start or Period Offsets, adjust the Revenue Recognition dates on the Zuora Invoice Item accordingly, and resync the invoice.

REST Syncing Zuora ProductRatePlanCharges to NetSuite

Error Message

Type: ERROR

Message: The G/L impact of a transaction in a closed period cannot be changed.

Sync Process

Product Rate Plan Charges

Cause

The user is trying to update a non-G/L impacting field; however, the user encounters an error in this notice: The G/L impact of a transaction in a closed period cannot be changed upon saving it. Here's an example as how it appears on the error screen:

The relevant G/L impact before changes:

| Accounting Book | Account | Amount |

| Primary Accounting Book(1) | Account XXX | -30000 |

| 605 Accounting Book(3) | Account XXX | -30000 |

After changes:

| Accounting Book | Account | Amount |

| Primary Accounting Book(1) | Account ZZZ | -30000 |

| 605 Accounting Book(3) | Account ZZZ | -30000

Resolution

This error will normally appear if you are editing a transaction posted in a closed period. User must verify the following:

1. Verify if the account is not inactive:

   1. Navigate to Lists > Accounting > Accounts .

   2. Click Edit next to the account name.

   3. Check the Inactive box.

   4. If it is marked, you may opt to set Inactive = False temporarily and revert this change after applying the desired change on the transaction.

2. Verify if any of the custom scripts or workflow attempts to change the account. Note: Consult your Administrator to review customizations.

3. Verify if you have a custom Global Account Mapping.

   1. Navigate to Setup > Accounting > Global Account Mappings .

   2. Find the source account if you have any custom mappings for it. Ensure that it has the correct combination of Subsidiary, Source Account and Destination Account.

   3. Click Edit.

   4. If there is a relevant mapping, the user may temporarily modify the mapping to reflect the same Destination Account as the Source Account or set the End Date to prior date.

      Note:

      Make sure to revert this change after applying the desired change on the affected transaction.

4. Verify the Item Account Mapping.

   1. Navigate to Lists > Accounting > Items.

   2. Look for the specific item used in the transaction.

   3. On the Item record, click Accounting subtab.

   4. Check if the Revenue Account/Deferred Revenue Account is now different from is in the transaction's GL Impact.

This means that the mapping was changed after the user originally recorded the affected transaction. If the user tries to edit and save the transaction, the system will re-validate the account and will attempt to map it with the existing account specified on the Item record. The change will be G/L impacting; hence, it will throw the error message if the period is already closed. As a workaround, you may temporarily change the account back to the previous one.

Netsuite Payments Not Syncing to Zuora

Error Message

No error message is displayed.

Sync Process

Netsuite payments are intended to sync to Zuora.

Cause

Payments that have a journal applied to them are not supported by the connector, resulting in a failure to sync.

Resolution

Prior to syncing again, undo the journal entry associated with the affected payment.