The transaction could not be locked

Updates to orders in QuickBooks fail, if other users are editing orders.

Problem

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.

Description

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.

Solution

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.