Skip to main content

Error - 'This record is locked by another user and therefore cannot be used' when receipting goods

This error means a user exited Dimensions unexpectedly while viewing this transaction, leaving it locked. This usually occurs in Dimensions rather than FocalPoint. To resolve it, clear the multi-user flags in Dimensions:

  1. Login to Dimensions as the ‘sa’ user or a user with an equivalent or master security profile.

  2. Ensure all other users are logged out of Dimensions.

  3. Confirm this at System Control > Users > User Records.

⚠️ Warning: Take a recent backup of the Dimensions database before proceeding. Contact your IT service provider if you are unsure how to do this.

  1. Click System Control.

  2. Click Data Utilities.

  3. Click Clear Multi-User Flags.

  4. In the ‘Multi-User Flags’ window, tick the ‘All Multi-User Flags’ tick box.

  5. Click the green tick.

The routine clears all multi-user flags in the database. Read any messages that appear during the process. 🤓 Tip: If selecting All Multi-User Flags does not resolve the issue, try selecting the affected module and system options individually and running each one.

Did this answer your question?