HDTN-238941 - Open Payable Details Incorrect due to MultiCurrency

Issue No: AP-8095
Created 11/26/2019 9:02:54 AM
Type Bug
Priority Blocker
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-238941 - Accounts Payable issues possibly caused by multi curreny|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-238941] Base Currency is CAD   Open Payable Detail is showing vouchers with small unpaid amounts, though the vouchers have been fully paid.   This is happening on Vouchers that are USD and payments that are USD.   The difference is the realized Gain/Loss, the difference in the Exchange Rate between the time the Voucher was Posted, and the Voucher was Paid.   See Voucher BL-1548 which was paid on payment PAY-345   Both transactions are for USD 6886.33. The Voucher is in fact, fully paid.   However, the CAD on the Voucher was 9166.39 and the CAD on the Payment was 9094.78, leaving a difference of 71.61, which is what shows on the Open Payable Details.   This would cause the Report to not balance to the G/L, as the AP Account is relived at the time of Payment for the Voucher amount, not the Payment amount (given the exchanges).