Hello team,

Currently, when we perform consolidation within the same database in Business Central and choose the option in chart of Accounts "Average Rate (Manual)" as the exchange rate method, we have observed that the system incorrectly expected average rate.

This behavior is not aligned with the intended functionality of the "Average Rate (Manual)" option. By definition, when this method is selected, the system should apply an average exchange rate derived from the Currency Exchange Rate master data—ideally calculated based on the rates defined for the consolidation period.

My request is reviewed this and give fix or workaround for this. Ideally, the system should:

• Automatically calculate the average rate from the Currency Exchange Rate table for the selected period,

Addressing this issue would help ensure the consolidation process is both technically accurate and compliant with accounting standards related to currency translation.

Thanks