Refreshing or scrolling through creditor records while in the Transactions tab can error 'New transaction not allowed due to other threads running'

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

Users are are encountering a thread error whenever in the transaction tab of Creditor Maintenance.  The error can be encountered simply by pressing the refresh icon or when scrolling through the creditors when in the tab. It does not stop users from processing transactions or refreshing the grid.

Solution

The issue has been logged as bug DEV-5783 in Version 7.00.175.  Here is an extract of what the programmers found

'the sort routine was always saving to the database even if the sort hadn't changed. This caused problems in a few special cases like the creditors form when scrolling through records when the transaction tab was visible - this grid would persist it's sorting, which meant sort was firing incorrectly during the read'

The work around is to turn off Use Custom Columns in the forms that are causing the issue (each relevant tab). In this instance, turn off Use Custom Columns in the Creditors > Transactions tab.