Example: Set Up the Journal Lines by Allocation Report

This example illustrates how to set up a custom report to identify which allocations produce the most result lines.

When you submit the

Run Mass Finalize for Allocations

task, the process takes longer than usual. The reduced performance might be a result of 1 or more allocations exceeding the Workday-recommended limit of 50,000 result lines. You create a custom report to list allocations by the number of result lines so that you can split them if necessary.

Steps: Set Up Allocations

Steps: Process Allocations

Security: These domains in the System functional area:

Custom Field Management

Custom Report Creation

Access the

Create Calculated Field

task.

Enter these values:

Option	Description
Field Name	RPT LRV Journal Line Allocation Definition to Line
Business Object	Journal Line
Function	Lookup Related Value

Click

Enter these values:

Option	Description
Lookup Field	Journal
Return Value	Allocation Definition

Click

and

Done

Access the

Create Custom Report

task.

Enter these values:

Option	Description
Report Name	Journal Lines by Allocation
Report Type	Matrix
Data Source	Journal Lines for Financial Reporting

Click

In the

Row Grouping

section on the

Matrix

tab, add a row to the grid and enter these values:

Group by Field	Label Override	Sort Rows	Options
RPT LRV Journal Line Allocation Definition to Line	Allocation Definition	Alphabetical - Ascending	Leave blank.

In the

Maximum Number of Rows

field, enter 12000
.

In the

Column Grouping (Optional)

section, add a row to the grid and enter these values:

Group By Field	Label Override	Sort Columns	Options
Company	Leave blank	Alphabetical - Ascending	Leave blank.

In the

Maximum Number of Columns

field, enter 200
.

In the

Define the Field(s) to Summarize

section, add 3 rows to the grid and enter these values:

Summarization Type	Summarization Field
Count	None.
Sum	Translated Debit Amount
Sum	Translated Credit Amount

Access the

Drill Down

tab.

In the

Detail Data

section, add 8 rows to the

Columns

grid and select these fields:

Journal

Company

Ledger Account

Accounting Date

Translation Currency

Translated Debit Amount

Translated Credit Amount

Worktags

Access the

Filter

tab.

In the

Filter on Instances

section, add a row to the grid and enter these values:

And/Or	Field	Operator	Comparison Type	Comparison Value
And	Journal Source	in the selection list	Value specified in this filter	Allocation

Access the

Prompts

tab.

In the

Prompt Defaults

grid, add 8 rows and enter these values:

Field	Default Type	Default Value
Company	No default value	Leave blank.
Amount Type	Specify default value	Activity
Ledger	No default value	Leave blank.
Period	No default value	Leave blank.
Time Period	Specify default value	Current Period
Translation Currency	No default value	Leave blank.
Account Translation Rule Set	No default value	Leave blank.
Balancing Worktags	No default value	Leave blank.

After you add the fields, select the

Populate Undefined Prompt Defaults

check box.

Access the

tab.

Select

Share with all authorized users

Click

You can run your

Journal Lines by Allocation

custom report by company or company hierarchy. The report displays:

Allocation definitions for each company.

Result line counts.

Translated debit and credit amounts.

Totals for each company and allocation definition.

Update your allocation definitions to split any allocations that produce more than 50,000 result lines.

Setup Considerations: Allocations