GLINF022 - General Ledger Listing with Source report is slow to return data

Owned by Beth Blok (Unlicensed)
Jul 26, 2018
1 min read

Problem

Running this report in some databases takes over two minutes to return data for 1 period for one or more accounts

Solution

SQL skills are required

A working knowledge of SQL Management Studio is required to complete this task

The stored procedure for this report has been re-worked and data is now returned in less than 5 seconds compared to 2 minutes previously.  Applies to 7.00.175 databases