In D365 Finance, the consolidation entity stores only a single currency layer based on the option selected during “Consolidate Online” (Accounting Currency or Reporting Currency).

This prevents Financial Reporter from showing both:

• Subsidiary accounting currency (e.g., SGD)
• Consolidation reporting currency (e.g., QAR)

in the same consolidated company.

Business Impact:

• Global companies using multiple subsidiaries with different COA and different functional currencies cannot generate MIS reports with both local currency and group currency in one entity.
• This becomes a significant limitation for multinational organizations operating in 20–50 countries.
• SAP S/4HANA and Oracle ERP Cloud support multi-currency ledgers by default, which allows reporting in subsidiary currency + group currency in a single consolidated ledger.

Requested Behavior:

• Allow the consolidation entity to store multiple currency layers, including:
• Subsidiary accounting currency
• Consolidated reporting currency
• Original transaction currency
• Expose all these layers in Financial Reporting (FR) column definitions.

Value:

• Enables complete global consolidations
• Reduces duplication of consolidation companies
• Aligns D365 with SAP/Oracle capabilities
• Enhances financial accuracy, transparency, and compliance
• Greatly simplifies multi-COA, multi-currency reporting