Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-03-08
Steps: Set Up Ledger Currency Mappings

Steps: Set Up Ledger Currency Mappings

  • Configure alternate ledger currencies for your companies. See Steps: Set Up Alternate Ledger Currency.
  • Security: configure these domains in the Financial Accounting functional area:
    • Set Up: Alternate Ledger Currency
    • Reports: Alternate Ledger Currency
When you enable alternate ledger currencies for your companies, you can use ledger currency mappings to define the ledger currencies to use for specific reporting requirements. You can then add a prompt to custom reports and select the mapping, enabling you to view a report in the required primary or alternate currency. Example: You need to generate financial reports in a local currency that differs from your functional currency.
  1. Access the
    Create Ledger Currency Mapping
     task and configure a mapping for a company to either a primary or alternate ledger.
    You can include more than 1 row in a mapping, but only include a company once per mapping.
    For consolidated financial reporting, Workday recommends you configure all companies in a single mapping with multiple rows, rather than separate mappings for each company. See Concept: Alternate Ledger Currency in Consolidated Financial Reporting.
  2. Enable the
    Ledger Currency Mapping
     prompt on custom reports or copies of Workday delivered reports. See Copy Reports.
    Configure the report to include a data source filter that supports ledger currency mappings. Navigate to the
    Prompts
     tab, add a row for
    Ledger Currency Mapping
     to the
    Prompts Default
     grid, and clear the
    Do Not Prompt at Runtime
     check box.
    When you enable the prompt on all subreports of a report, the
    Ledger Currency Mapping
     field displays in the
    Subreport Prompts (Not Prompted)
     grid as:
    • Multiple rows for a composite report, 1 for each subreport.
    • A single row for a matrix report.
When you run a report, select a mapping in the
Ledger Currency Mapping
 prompt. When you don't select a mapping, Workday displays the report in the primary currency for your company.
Workday recommends you copy the
Trial Balance - Composite
 report and configure a
Ledger Currency Mapping
 report field to view general ledger details. The
Trial Balance
 report doesn't support ledger currency mappings.