Hi All
Please refer to my attached word document for evidence and calculations.
When One Outgoing Payment applied against two AP invoices, the realised exchange gain loss calculated from lump sum payment amount against two Invoices could be different from the sum of realised exchange gain loss calculated from individual AP Invoice.
This results an unnecessary realised exchange gain loss Revaluation Journal local currency $0.01 created and posted to Vendor Invoice in AP Aging on Original Invoice Date to Vendor Invoice in AP Aging and Payable Control account upon subsequent payment to tally realised exchange gain loss difference posted against Vendor Invoice in AP Aging and Payable Control on subsequent Payment Date in General Ledger.
How to change currency rounding setup for THB so that the backend calculation of realised exchange gain loss on individual AP Invoice is calculated based on maximum decimals rounding to be consistent with realised exchange gain loss calculation on lump sum payment?
Total lump sum payment for AP Invoice Amount in THB (33800 + 8419.19) x 0.03746551 = SGD1581.7634851369 less sum of AP Invoices in Original Invoice rate (SGD1283.386+319.6766443) SGD 1603.0626443, SGD1581.76 – 1603.06 = SGD21.30
Calculation of individual realised exchange gain loss on each AP Invoice paid shows there is a backend rounding $0.01 difference in AP Invoice 2023 2510055196
AP Invoice 195 THB 8419.19 x payment rate 0.03746551=SGD315.4292471369
Less AP Invoice 195 THB (8419.19 x 0.03797) SGD 319.68 = SGD-4.25
AP Invoice 196 THB 33800 x 0.03746551 = SGD 1266.334238
Less AP Invoice 196 THB (33800 x 0.03797) SGD 1283.39 = SGD-17.06 (SGD 1266.334238 - 1283.386 = 17.051762)
SGD 17.06+4.25=SGD21.31
Kedalene Chong