Example: Enable Alternate Ledger Currency on the Consolidated Trial Balance Report

This example illustrates how to enable the

Ledger Currency Mapping

prompt on the

Consolidated Trial Balance

report. Selecting a ledger currency mapping enables you to choose whether to perform eliminations and translation on the primary or alternate ledger currency (ALC) for each of your companies.

You have 3 companies based in the United Kingdom with different functional currencies.

Company	Functional Currency
VIC Distribution UK	GBP
VIC Distribution EU	EUR
VIC Distribution Worldwide	USD

You need to perform local currency consolidations in GBP, so you’ve configured GBP as an alternate ledger currency for VIC Distribution EU and VIC Distribution Worldwide.

To run the

Consolidated Trial Balance

report for these 3 companies in GBP, you:

Set up a ledger currency mapping that specifies whether to use the primary or alternate ledger currency in reporting for each of your companies.

Create a custom copy of the

Consolidated Trial Balance

report.

Enable the

Ledger Currency Mapping

prompt on the copied report and all subreports, so that you can select the ledger currency mapping when you run the report.

If your investment in subsidiary elimination rules are configured on the

Investment in Subsidiary / Subsidiary Equity (To Be Retired)

tab on the

Maintain Elimination Rules

task, move them to the

Intercompany / Interworktag

and the

Noncontrolling Interest Activity

tabs. See Workday Community: Guide to Updating the Investment in Subsidiary Elimination Rule.

If you're using derived noncontrolling interest, opt-in to persisting noncontrolling interest on the

Noncontrolling Interest Journal Lines Opt-In

task. See Steps: Set Up for Persisting Noncontrolling Interest.

Configure GBP as the alternate ledger currency for companies that have a different functional currency. See Steps: Set Up Alternate Ledger Currency.

Access the

Create Ledger Currency Mapping

task.

In the

Ledger Currency Mapping Name

field, enter Local Currency Reporting (GBP)
.

In the grid, add 2 rows and select these values:

Company	Ledger
VIC Distribution EU	VIC Distribution EU: Actuals (GBP) (This is the alternate ledger.)
VIC Distribution Worldwide	VIC Distribution Worldwide: Actuals (GBP) (This is the alternate ledger.)

Security: Set Up: Alternate Ledger Currency
domain in the Financial Accounting functional area.

Access the

Copy Standard Report to Custom Report

task.

From the

Standard Report Name

prompt, select Consolidated Trial Balance
.

Click

Enter the name Consolidated Trial Balance (GBP Reporting)
.

Click

Security: Custom/Standard Report Copy
domain in the Tenant Non-Configurable functional area.

From the

View Custom Report

report, access the related actions menu of the report and select

Custom Report

Edit

Security: Manage: All Custom Reports
domain in the System functional area.

On the

Edit Custom Report

task, navigate to the

Prompts

tab and the

Subreport Prompts (Not Prompted)

grid.

Click the header of the

Field

column to filter the grid.

From the

Value

prompt, select Ledger Currency Mapping
.

Workday displays the 3 rows that contain the Ledger Currency Mapping
field for each subreport.

In the

Subreport Name

column, access the related actions menu of the first subreport, with the name that ends with

Journal Lines Eliminations

, and select

Custom Report

Edit

On the

Edit Custom Report

task for the subreport, navigate to the

Prompts

tab.

In the

Prompt Defaults

grid, find the Ledger Currency Mapping
row and clear the

Do Not Prompt at Runtime

check box.

Click

and

Done

Workday returns you to the

Edit Custom Report

task for the copied consolidated trial balance report.

On the copied consolidated trial balance report, navigate to the

Prompts

tab and the

Subreport Prompts (Not Prompted)

grid.

In the

Subreport Name

column, access the related actions menu of the second subreport, with the name that ends with

Journal Lines Translated

, and select

Custom Report

Edit

On the

Edit Custom Report

task for the subreport, navigate to the

Prompts

tab.

In the

Prompt Defaults

grid, find the Ledger Currency Mapping
row and clear the

Do Not Prompt at Runtime

check box.

Click

and

Done

Workday returns you to the

Edit Custom Report

task for the copied consolidated trial balance report.

On the copied consolidated trial balance report, navigate to the

Prompts

tab and the

Subreport Prompts (Not Prompted)

grid.

In the

Subreport Name

column, access the related actions menu of the third subreport, with the name that ends with

Journal Lines Translated Summary

, and select

Custom Report

Edit

On the

Edit Custom Report

task for the subreport, navigate to the

Prompts

tab.

In the

Prompt Defaults

grid, find the Ledger Currency Mapping
row and clear the

Do Not Prompt at Runtime

check box.

Click

and

Done

Workday returns you to the

Edit Custom Report

task for the copied consolidated trial balance report.

Click

Run

When you run your

Consolidated Trial Balance (GBP Reporting)

custom report, you can select your Local Currency Reporting (GBP)
ledger currency mapping.

Workday retrieves the company ledgers (primary and alternate) and performs eliminations as configured on the ledger currency mapping:

Company	Result
VIC Distribution UK	Workday displays and performs eliminations on the primary ledger currency (GBP).
VIC Distribution EU	Workday displays and performs eliminations on the alternate ledger currency (GBP).
VIC Distribution Worldwide	Workday displays and performs eliminations on the alternate ledger currency (GBP).

Steps: Set Up Ledger Currency Mappings

Copy Reports