I have redirected a similar discussion we have had here.
https://frontaccounting.com/punbb/viewtopic.php?id=2057
I will try to explain how we eventually can solve it in FA. Please correct me if something seems wrong in my explanation.
We save the rate on the debtor_trans and supp_trans and we save the currency on the customer/supplier.
A revaluation could run with the following formula:
SUM all currency customers not fully allocated records with the rate of the record date and SUM all currency customers not fully allocated records with todays rate. The differences are booked on AR account and Exchange Variation Account.
SUM all currency suppliers not fully allocated records with the rate of the record date and SUM all currency suppliers not fully allocated records with todays rate. The differences are booked on AP account and Exchange Variation Account.
Well while we are doing that shouldn't we now replace all the rates on the records with todays rate? Otherwise we can't do this revaluation more times, right?
Can anybody see any side-effects with this?
/Joe
.