CLONE - HDTN-238941 - Open Payable Details Incorrect due to MultiCurrency

Issue No: AP-8401
Created 2/28/2020 10:21:07 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] This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-242908 - exchange rate Issue with small balances remaining after full payable has been paid|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-242908]           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-4582 which was paid on payment PAY-1017   The transaction amount for this voucher in USD is 3994.72. The Voucher is in fact, fully paid.   However, the CAD on the Voucher was 5297.78 and the CAD on the Payment was 5254.18, leaving a difference of 43.60, which is what shows on the Open Payable Details.   While the report now balances with the general ledger, the report IS WRONG. There is no amount due on these vouchers, so they should not show on the Open Payable Detail Report, nor should there be a balance for these vouchers in the G/L.