Connex for QuickBooks Desktop User Guide
Connex for QuickBooks Online User Guide
Frequently Asked Questions
Integrations Help Guide
Rules Engine Guide
General Troubleshooting Guide
QuickBooks Point of Sale (POS) - ARCHIVED
Integration Guides (No Longer Supported)
The transaction could not be locked
Updates to orders in QuickBooks fail, if other users are editing orders.
You receive an error that a transaction could not be modified because it is locked by another user. Some updates fail to sync.
While trying to Mod a(n) Sales Order with name or order number of R21-2880, QB responded There was an error adding, modifying or deleting BB1BD-1626965492 because it is already in use. QuickBooks error message: The transaction could not be locked.
This error occurs when the transaction being modified in QuickBooks is already in use by another user or the QuickBooks database has temporarily locked the transaction from editing or updates. It's how the system protects multiple users from modifying the same transaction at the same time.
Stop editing the order or related transactions
The first step is to see if other users in QuickBooks are editing transactions. If so, request that they complete their editing. Once the edits are saved, try to sync again. If you receive this error, first confirm if another QuickBooks user is manipulating this journal or the related transaction. If they are, wait until they save and complete their task before running the sync again.
Single user mode
If you continue to see the error, switch the company file to single-user mode, close QuickBooks, and sync again.