Exchange rate calculation for override type account
Summary:
Now, all accounts (both balance sheet and P/L acoount ) are set as flow accounts.
Since the closing balance of balance sheet account need to be calculated as YTD closing and its movement need to be calculated as Periodic average, we created two rules to achieve this result. (first we override the exchange method of closing balance to YTD closing, second we override the exchange method of movement to the average periodic, and the movement exchange differences will automatically calculated to Foreign Exchange Subtotal as expected) For normal BS account, the calculation is correct (shown as below).
However, the result for the account using Historical Amount Override as its exchange rate type will be affected by the second rule, and the closing balance will follow Periodic Average.