Calculation of Average consolidated exchange rate for Grandchild subsidiary

Average Consolidated Exchange Rates is not being calculated for grandchild subsidiary even if there are transactions in it. This is a standard behavior of the system if both the child and the grandchild subsidiary has the same currency that is different from the parent subsidiary. For example: Parent = USD — Child = AUD —–… Continue reading Calculation of Average consolidated exchange rate for Grandchild subsidiary

Search to identify the Average Consolidated Exchange Rate

Consolidated Exchange Rates are calculated based on the rate type set on Accounts. Average Consolidated Exchange Rate is the weighted average of the exchange rates of transactions applied during the period to Accounts with the Average General rate type. Here are the steps to follow to verify the Average Consolidated Exchange Rate:   1. Create a Transaction Saved Search that will extract posting transactions associated… Continue reading Search to identify the Average Consolidated Exchange Rate