d/EPM Analytics

Report Configuration needs to include Chart Structure selection

Report Configuration for both Consolidated Income Statement and Statement of Capital Expenditures need to add the ability to select Chart Structure if you need to override the one defaulted by reporting basis.

Without this, users are limited to using Chart Structures that belong to a Reporting Basis.

Program/Business class/Process affected:

• Chart Configuration (gl_ChartConfigurationWidget)

Use these steps to test the enhancement:

1. Select Dashboards > Administration > Report Configuration.
2. In, Consolidated Income Statement and Statement of Capital Expenditures:
   • Verify the Chart Structure selection is displayed
   • Verify that the caption will be removed once the user changed the chart of account structure. To keep the caption you can select the Reporting Basis only. Do not change the structure.
   • Caption is applied to all chart accounts under the reporting basis.

JT-1683055

Summary Trial Balance

Create a report titled 'Summary Trial Balance' with these requirements:

The summary trial balance report will provide a snapshot of account balances as of a certain selected date. Balances by account should be separated into columns of beginning balance, aggregation of all debit transactions, aggregation of all credit transactions, and closing balance based on the type of account.

Program/Business class/Process affected:

n/a

Use these steps to test the enhancement:

1. Launch Financial Reporting Home Dashboard
2. Set Finance Enterprise Group, Reporting Basis, calendar period in the Required Reporting selections
3. Set the scenario values
4. Select and click Summary Trial Balance Report.

JT-1596092

Comparative Balance Sheet

Create a report titled 'Comparative Balance Sheet' with these requirements:

The balance sheet shall have the capability to show a organization’s assets, liabilities, and equity at specific points in time, including end of month, end of quarter and end of year, calendar or fiscal.

Program/Business class/Process affected:

n/a

Use these steps to test the enhancement:

1. Launch Financial Reporting Home Dashboard.
2. Set Finance Enterprise Group, Reporting Basis, calendar period in the Required Reporting selections
3. Set the scenario values.
4. Select and click Comparative Balance Sheet Report.

JT-1596085

Consolidated Income Statement

Create a report titled 'Consolidated Income Statement' with these requirements:

The income statements shall have the capability to show an organization’s revenues and expenses over a period of time, such as month, a quarter or a year. Within the income statement the expenses should be subtracted from the revenues to show the net income or loss for that selected accounting period.

These are the minimum requirements of the income statements:

• User-selectable filters should be the period, and a Reporting Basis.
• The Reporting Basis selected defines the entities to be displayed in the columns of the report, as well as the ledgers, etc.

Program/Business class/Process affected:

n/a

Use these steps to test the enhancement:

1. Launch Financial Reporting Home Dashboard.
2. Set Finance Enterprise Group, Reporting Basis, calendar period in the Required Reporting selections.
3. Set the scenario values.
4. Select and click Comparative Balance Sheet Report.

JT-1596089

Income Statement - Budget vs Actual

Create a report titled 'Income Statement - Budget vs Actual' with these requirements:

The report shares all of the same formatting of the Income Statement – Consolidating but it will have a “split layout” with the accounts going down the middle.

Selectable filters should be the period, and a Reporting Basis. Only the data for the Reporting Basis should then display (respective of its entities, ledgers, etc.)

Columns in the report should include Actual, Budget, Prior Period and Same Period Prior Year.

Program/Business class/Process affected:

n/a

Use these steps to test the enhancement:

1. Launch Financial Reporting Home Dashboard
2. Set Finance Enterprise Group, Reporting Basis, calendar period in the Required Reporting selections.
3. Set the scenario values.
4. Select and click Income Statement - Budget vs Actual Report.

JT-1596091

Add Filter to Reporting Basis selectors

A new attribute was added to the reporting basis dimension to allow filtering of shadow reporting basis.

Program/Business class/Process affected:

• Updated Select Reporting Basis report

JT-1449389