Generate Vendor Rebate File - Generate Preview tab number of records didn't match on SQL

Issue No: ST-1965
Created 8/11/2021 4:24:41 AM
Type Bug-QC
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 19.1, 20.1, 21.1, 21.2
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-246118 - Store - Cleanup/Obsoletion - Non-Customer|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-246118]   *STEPS :*   1. Go to Main Menu > Store > Generate Vendor Rebate File   2. Enter/select the following details   * Store : 1,2,3,4,5,6,7 * Beginning Date : 8/2/2021 * Ending Date : 8/8/2021 * File Format : RJ Reynolds   3. Click Generate button   4. Verify in SQL   *ISSUE :*   Number of records that display on Generate Preview tab are didn't match when verifying on SQL.   !pastedImage_d167479_0.png|height=441,width=558!   !pastedImage_d167479_1.png|height=140,width=535!   *ACCEPTANCE :*   In Generate Preview tab, it should display the correct number of records based on the given filter in Details tab and will match to number of rows in SQL.