Does anyone know how to pull an 18 month balance sheet that correctly revalues foreign currency amounts? Right now we have a custom Balance Sheet that has the standard column from the canned report and then an additional column that has Alternate Period Range Type set "relative to report date", cumulative value checked, alternate period range "last rolling 18 periods" and range segment "accounting period" The issue that we're running into is that if we look at the canned Balance Sheet on our of foreign bank accounts is showing a balance and if we look at the 18 month BS the foreign bank account is showing a slightly off number. So if we pull the Aug 2020 18 mo balance sheet it shows us August and the preceding 18 months, the balance for fx bank account is 60,711.14 whereas if we pull the canned BS for Feb and the 18 month balance sheet for March (March 2020 and the preceding 18 months) the fx bank account shows a matching 59,259.69. I guess the gist of the question is if anyone has encountered this issue and knows how to lock in the foreign balances when making a rolling balance sheet.

We also have this problem.