Report Using Alternate Ledger Currencies
- Configure alternate ledgers and ledger currency mappings in Workday. See Steps: Set Up Alternate Ledger Currency.
- Enable OfficeConnect for Workday Financial Management (Financials) data source. See Set Up Your Tenant for OfficeConnect for Financial Management
- Install OfficeConnect as an End User. Install the latest version.
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.
- Run an existing report or create one.
- In theElementstab, expand theLedger Currency Mappingdimension to expose the currency mappings.
- Drag and drop the required currency mapping to the desired report row or column.
- Refresh the report.
- (Optional) To verify that currency mapping has applied correctly to your report, use theShow Detailsoption or theReviewtab.