CLONE - AP Clearing Account is out of balance

Issue No: AP-8941
Created 7/20/2020 9:09:53 AM
Type Bug
Priority Critical
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-248009 - AP Clearing account is out of balance|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-248009]           *Reproduction Steps:*     1. Run the FRD Report - Systems Account Daily Audit and cleck the AP Clearing account balance.   !pastedImage_d141131_0.png|height=255,width=570!   2. Check the AP Clearing balance in AP Clearing Detail report.   !pastedImage_d141131_1.png|height=245,width=553!   *Issue:*   Both are off by -220.49$   *Analysis:*   When run attached "Clearing per account" sql script, found mismatch in below highlited accounts.   !pastedImage_d141131_2.png|height=276,width=553!   *Expected Result:*   This should be same in AP Clearing Detail vs FRD AP Clearing balance.   Program fix   If we have to match APC with GL, then APC report should consider only posted transactions.