Skip to main content
Adaptive Planning
Last Updated: 2023-06-23
Report Using Alternate Ledger Currencies

Report Using Alternate Ledger Currencies

Use alternate ledger currency to:
  • Report on both alternate and primary ledger currencies in OfficeConnect.
  • Drill into the different sets of journal lines for different ledgers and ledger currencies.
  • Generate local statutory reports with more accuracy.
The ledger currency mapping that you apply to a report drives the ledger currency that the report uses. If the ledger currency that you apply matches the reporting currency defined in the data model, then you don't need currency translation adjustments (CTA). As a default, all OfficeConnect reports use the primary ledger currency as the company currency. You can change this default in the report workbook properties.
  1. Run an existing report or create one.
  2. In the
    Elements
    tab, expand the
    Ledger Currency Mapping
    dimension to expose the currency mappings.
  3. Drag and drop the required currency mapping to the desired report row or column.
  4. Refresh the report.
  5. (Optional) To verify that currency mapping has applied correctly to your report, use the
    Show Details
    option or the
    Review
    tab.