Performance

When the Replication Counter update is enabled, it can sometimes lead to table locking issues. However, since all the POS devices are online, there is no need to update the replication counter.

To skip the update of the replication counter, you need to assign a Distribution Location to the Retail Setup page. If you do not have one already, create a new Distribution Location. Then, follow these steps:

  1. Open the Distribution Location page in the Retail Setup.
  2. Enable the Skip Repl. Counter Update toggle on the Distribution Location page.

If you still encounter table locking issues despite skipping the replication counter update, you can refer to the Business Central documentation for further assistance. The documentation provides information on current table locks and analyzing database lock timeout trace telemetry. You can access the documentation through the following links:

Ability to see current database locks

Analyzing Database Lock Timeout Trace Telemetry