Poor Performance when using GLTRANSATIONID in REVENUEGLDISTRIBUTION in 2.93

Poor Performance when using GLTRANSATIONID in REVENUEGLDISTRIBUTION in 2.93
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 


Workaround:

Remove the REVENUEGLTRANSATION table from your query and replace with a subquery reference the fields needed for the given query.  Change the line returning the GLTRANSATIONID from

case when isnull(JOURNALENTRY_EXT.DISTRIBUTIONTABLEID,JOURNALENTRY_EXT.ID) is null then null else JOURNALENTRY.ID end as GLTRANSACTIONID,

to

JOURNALENTRY.ID end as GLTRANSACTIONID

on the subquery.


Environment

 2.93 Patch 18
 2.93.2034, patch 23

Was this article helpful?