FRD Reports Not Matching GL Detail

Issue No: GL-6648
Created 9/11/2018 11:39:58 AM
Type Bug
Priority Major
Status Closed
Resolution Fixed
Fixed Version 18.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-217822 - A/R GL doesn't match Financial Reports|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-217822] There is a discrepancy between FRD reports and GL Detail. First I tried to recalc the summary table but that didn't work, so I dug into the view and SQL query running that gets the value.   It seems that something to do with the way the date data is converted that is making this issue happen.   !pastedImage_d104632_0.png!