You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!