Introducing the Chargebee CLI

QuickBooks - Error code:6000; Business validation error

Problem Statement

QuickBooks Online returns error code 6000 with a business validation message when Chargebee syncs invoices or other records. The exact wording depends on what QuickBooks rejected.

  • Custom field mapping: Third party request failed [ERROR CODE:6000, ... Business Validation Error: You cannot enter more than 31 characters in the sales_custom_1_val field ...] during initial sync after mapping a Chargebee custom field to a QuickBooks Online sales custom field.
  • Memorized sales transactions: Business Validation Error: Do you also want to update memorized sales transactions to use the new values? after plan or product changes in Chargebee.

Solution

QuickBooks Online uses error 6000 for more than one validation failure. Use the error detail text to choose the fix below.

Custom field mapping value is too long

This error appears when a Chargebee custom field mapped during Custom Field Mapping in the QuickBooks setup wizard sends a value that exceeds the QuickBooks Online limit for that sales custom field (for example, sales_custom_1_val allows 31 characters).

Custom field mapping is available only after Chargebee Support enables it for your site. If Custom Field Mapping is not in the QuickBooks setup wizard, contact Chargebee Support before the steps below.

A common case is mapping a customer custom field that stores a 36-character UUID. Removing hyphens shortens the value to 32 characters, which is still over the limit.

To fix the mapping during setup:

  1. On the Custom Field Mapping step, remove the mapping that points to the failing QuickBooks sales custom field. Map the Chargebee field to another QuickBooks field only when that field accepts the full value. Another sales string custom field often has the same 31-character limit.
  2. If you keep the mapping, ensure the synced value is 31 characters or fewer. Do not truncate the value unless you can preserve uniqueness for your process.
  3. Click Proceed, complete the remaining setup steps, and click Run Initial Sync. The 6000 validation error for that field should no longer appear in the initial sync results. Other sync errors can still appear.

If you have already moved past Custom Field Mapping and cannot return to that step in the wizard, contact Chargebee Support. Support can reset the integration to the Custom Field Mapping step so you can change or remove the mapping. You must then redo the later setup steps, including product catalog mapping, tax mapping, and sync rules, before you click Run Initial Sync again.

For background on QuickBooks custom fields in Chargebee, see QuickBooks custom field mapping.

Memorized sales transactions need updating

This QuickBooks Online error typically appears when you change a plan in Chargebee (for example, a price change or adding a setup cost) and the change affects an SKU or field used in a recurring (memorized) transaction in QuickBooks. QuickBooks prompts whether to update memorized transactions to use the new values.

To resolve this error, accept the update in QuickBooks Online when prompted so that memorized transactions use the new values. The warning clears after QuickBooks accepts the new values. If the prompt does not appear in Chargebee, check the QuickBooks Online settings for recurring transactions and ensure they are configured to allow updates.

Error code: 6000 in Chargebee

QuickBooks Settings: Recurring transactions

Additional Information

What are Recurring (Memorized) Transactions?

Recurring or memorized transactions in QuickBooks Online save plan details (payment details, customer ID, email, and so on) to avoid manual errors and reduce data entry for future transactions.

When an item is saved to a recurring transaction in QuickBooks Online, any change in plan details in Chargebee will trigger this warning.

Important Notes

  • QuickBooks Online exposes only the first three active string custom fields on sales forms through the API. See QuickBooks custom field mapping.
  • If error 6000 persists after you adjust custom field mapping, capture the full error detail from the initial sync results and contact Chargebee Support.