This article talks about temporary solutions for the QuickBooks “ErrorCode : 6000 - Business Validation Error”.
What's Happening
You may see an error while syncing orders with QuickBooks Online “ErrorCode : 6000 - Business Validation Error”. The error messages are usually:
"Items attached to a large number of transactions can't be processed."
or
"The action could not be completed because another user was creating, editing, or deleting a transaction with inventory products at exactly the same time. Please try again in 30 min."
Why is it Happening
We are actively working with Intuit to find out what the root cause is. One of the possible issues is that QuickBooks follows a FIFO (First-In, First-Out) model for inventory cost accounting. For inventory items, QuickBooks tracks the current number of inventory items in stock, the cost of goods sold, and the asset value of the inventory after the purchase and sale of every item. This means that with each new transaction, QuickBooks may need to make millions of cost adjustments, especially for companies with a large number of transactions corresponding to the same inventory item.
This problem is exacerbated when transactions are not created in chronological order. These transactions can take hours to complete and place a lock on the company database until the operation is finished. This issue can lead to significant delays and disruptions in creating sales transactions via API.
However, it is possible that other issues might be involved in this type of error. We are still actively investigating it with Intuit to find out more.
Things to consider
If you get the above error, please try the suggested workaround until the issue is resolved by Intuit.
Possible Workarounds
Create New Items (Recommended): To manage your inventory more effectively, we recommend creating new items with the same name while renaming the old items with many transactions. This method helps reduce the number of transactions linked to a single inventory item, simplifying your records and enhancing system performance.
Rename the Old Item:
Go to the item list in QuickBooks.
Find the old item that has many transactions.
Edit the item and rename it by adding a suffix like "OLD" or a date. For example, if the original item name is "Widget," rename it to "Widget_OLD" or "Widget_2023."
Create a New Item with the Same Name:
Go to the "Products and Services" section.
Click on "New" to create a new item.
Enter the original item name, e.g., "Widget."
Fill in the required details and save the new item.
Pro Tip: To duplicate an item quickly, click the down arrow and select "Duplicate" as shown in the screenshot below
By following these steps, you maintain a clean inventory system and ensure that your old transactions are preserved without cluttering your current item list. [Add product and service items to QuickBooks Online]
Use Non-Inventory Items:
Check if you need to track inventory in QuickBooks for your items.
If tracking inventory is not required, opting for non-inventory items can simplify your process.
If not, create an item with a Non-Inventory type.
Non-inventory items do not let you track inventory, meaning they won't impact your inventory counts or be subject to FIFO (First In, First Out) cost accounting. This can prevent complications and errors related to inventory tracking and cost calculations.
Create/change these items as Non-Inventory types to avoid the error. [Change product and service item types in QuickBooks Online ]
Using non-inventory types ensures that these items won't interfere with your inventory management and cost accounting processes, helping you maintain accuracy and avoid errors.
Alternatively, you can use QuickBooks desktop versions like QuickBooks Enterprise with Webgility. This way, you won’t need to change your process or application.
By using these workarounds, you can reduce the impact of Error Code-6000. These temporary solutions should help you continue your work smoothly until Intuit provides a permanent fix.
Long-Term Solutions
The QuickBooks team is working on long-term solutions to fix this issue. However, there is no ETA to this issue. Webgility team is in continuous follow up with the Intuit team to find a resolution to the problem.
If you have any questions or need more help, please contact our support team.