HDTN-241968 - Bank Transfers Foreign Exchange

Issue No: GL-7471
Created 2/6/2020 2:26:40 PM
Type Bug
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 18.3
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-241968 - Bank reconciliaton|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-241968]   On Bank Transfers between 2 banks with DIFFERENT currency (USD and CAD), the Bank Transaction Amount is not matching the G/L Amount       The Bank Transaction and the G/L Detail both show the same exchange rate, but when calculated out, it is different.   Example BTFR-102   Foreign Currency Transferred was 300,000   Exchange rate is 1.326656   tblCMBankTransaction shows dblAmount = 398028   tblGLDetail shows dblDebit = 397996.8   Using Calculator get the following:   !pastedImage_d129616_0.png|height=224,width=316!   There are MULTIPLE transactions that are between two bank accounts. The Exchange/Totals need to be consistent between CM and GL   Currently, we cannot reconcile the bank account.