Zeroing out Historical Currency accounts in reporting currency in MR

(0) Share

Report

Posted on by Community Member

From another thread this was pointed out.

MR can return a translated amount even when there is a $0 balance in the functional currency. A simple example to explain this:

An account is set to use Historical for the translation type.
Debit Amount of 1,000 posted to the account on 1/15/2016. Exchange rate on that date of 1.1, so the translated amount is 1,100.
Credit amount of 1,000 posted to account on 1/22/2016. Exchange rate on that date of 1.2, so the translated amount is 1,200.
report generated on 1/31/2016. The amount in the functional currency is $0. The translated amount will be a credit of -100 (1,100-1,200).
This situation can occur with accounts set to Historical or Average translation types.

This is the exact situation we are running into. How do we fix this problem. The account is zero in functional currency and needs to be zero in reporting currency as well. I tried revaluing the account and that didn't work.

*This post is locked for comments