d/EPM Analytics

This section contains enhancements in Infor Financials and Supply Management.

Summary Trial Balance

Create a report titled Summary Trial Balance as described on 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 the Summary Trial Balance Report.

JT-1596092

Comparative Balance Sheet

Create a report titled Comparative Balance Sheet as described on 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 the Comparative Balance Sheet Report.

JT-1596085

Consolidated Income Statement

Create a report titled Consolidated Income Statement as described on 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.

The following 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 the Consolidated Income Statement Report.

JT-1596089

Income Statement - Budget vs Actual

Create a report titled 'Income Statement - Budget vs Actual' and as described on 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 the Income Statement - Budget vs Actual Report.

JT-1596091