HDTN-234198 - Settlement transaction not being part of the clearing report

Issue No: GRN-2205
Created 6/13/2020 2:48:59 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 19.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-234198 - Open Clearing Detail report gives inaccurate results|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-234198] There are over a thousand settlement storage in GL, but in the query of the report it is only returning about less than 50 records.   Here's an example of a storage settlement transaction.   {noformat}SELECT * FROM vyuAPGrainClearing WHERE strTransactionNumber = 'STR-1009/1'{noformat}