Generating cost and profitability report

Select the “Cost and Profitability Report” activity under the “Reports – Management Accounting” business component.

The “Generate Reports” page appears.

Select any one of the radio buttons:

Offline Report Save

Select this radio button if you wish to print more than one Cost and Profitability Reports as a single output.

Note that the report is generated and the relevant link displayed in the header / multiline.

On-Screen Launch

Select this radio button if you wish to print a single Cost and Profitability Report.

Note: The system displays only the Company displays field if “On-Screen Launch” radio button is selected.

Enter the following fields:

Run #.

A unique number identifying the generation of reports. This number is automatically generated by the system at the time of processing.

Leave this field blank while in create mode as the system automatically generates the Run # based on the Numbering Type.

Ensure that the run number entered in this field exists for the login OU.

Help facility available

Select Go icon to retrieve all the details pertaining to the Run # specified.

Report Type

Use the drop-down list box specify the basis on which you wish to generate the report. The system lists the following options:

Bulk - Select this option if you wish to generate more than one report consolidated into one single PDF
Individual - Select this option if you wish to generate individual PDF for every report.
Individual Excel - A new Report Type - Individual Excel is introduced in report type..

The system displays “Bulk” by default in this field.

The system displays the following fields:

Company

The name of the company for which report is generated.

The system displays the login OU company by default in this field.

File Name

The file name link which has been processed.

Status

Indicates the status of the Run #, which could be “In-Progress”, “Processed”

To search & sort AMEs

Enter the following fields in the multiline:

Report ID

The number identifying details of CE Structure, CC Structure and Column Structure, and other details defined in the “Manage Cost and Profitability Report Templates” in the “Cost Setup” business component.

Ensure that the ID entered in this field is an active report ID as defined in the Manage Cost and Profitability activity and exists for the login OU.

Help facility available

The system displays the following field:

Report Description

A textual description of the report.

Enter the following fields in the multiline:

CE Structure ID	A unique code identifying the cost element structure. Data entry in this field is mandatory if Report ID is not specified. Ensure that the value entered in this field is an active CE Structure ID as defined in the CE Structure master for the login OU. Help facility available
Col. Structure ID	Use the drop-down list box to specify the column structure you wish to be used to print the report. The system lists all the Column Structure IDs defined for the login OU. Data entry in this field is mandatory if the Report ID is not specified. Note that Cost Column Structure has been enhanced to enable comparison between all cost centers. A new Pre-Defined Cost Column Structure is introduced “STD-CC” which can be used to extract the Cost and Profitability Report with dynamic columns (Actual values for a period and dynamic Cost Centers as columns). Ensure that the Col. Structure entered in this field have formula definitions. By default the system leaves this field blank.
CC Structure ID	Use the drop-down list box to select the cost center structure you wish to be used to print the report. Data entry in this field is mandatory if Report ID is not specified. Ensure that the value selected in this field is an active CE Structure ID that exists for the login OU company. Help facility available
Finance Book	Use the drop-down list box to select the finance book. The system lists all the finance books for the login company and organization unit as defined in the “Organization Setup” business component. The system displays “ALL” by default. Ensure that “All” is selected in this field if for a given row in the multiline “Budget #” is specified. The system displays “All” by default.
Financial Year	Use the drop-down list box to select the year for which the report needs to be run. The system lists the current financial year and the previous financial years for the login Company in descending order along with a blank value. The system displays the current year by default in this field.
Financial Period from	Use the drop-down list box to select the financial period in the specified financial year from which the report needs to be extracted. Ensure that the financial period specified in this field falls within the financial year selected. The system displays the immediate completed period by default in this field.
Financial Period to	Use the drop-down list box to select the financial period up to which the report needs to be extracted. Ensure that the financial period specified in this field falls within the financial year selected. The system displays the immediate completed period by default in this field. Note: If Financial Year is selected as blank (based on option), then the financial period from and to can be selected for across the financial year.
CE Display Level	Use the drop-down list box to select the levels at which the cost elements mapped to the CE Structure should be displayed in the report. All the levels available in the given CE structure ID will get loaded. Note: Select the minimum number for the CE Structure to display all the elements in the CE structure. The system displays the maximum number in this field by default.
CC Entry Level	Use the drop-down list box to select the levels at which the cost centers mapped to the CC Structure must be displayed in the report. The system lists all the levels available in the given CC structure ID. Ensure that the value in this field exists in the CC Structure ID. Note: Select the minimum number for the CC Structure to display all the Cost Centers in the CC Structure. The system displays blank in this field by default.
CC Structure Level	Use the drop-down list box to select the levels at which the cost centers mapped to the CC Structure must be displayed in the report. The system lists all the levels available in the given CC structure ID. Note: Select the minimum number for the CC Structure to display all the Cost Centers in the CC Structure. By default the system leaves this field blank.
CC Report Option	Use the drop-down list box to specify the report option. The system lists the following values: CC Group, CC Detail and CC Structure. CC Group - Select this option if you wish to generate reports only for the Group Cost Centers in the CC Structure ID CC Detail – Select this option if you wish to generate reports only for the Detailed Cost Centers in the CC Structure ID. CC Structure - Select this option if you wish to generate reports for all the Group Cost Centers and Detailed Cost Centers in the CC Structure ID. Note: If the selected cost column structure ID has cost center as dimension, the report will be generated with CC structure ID as the column hierarchy. By default the system leaves this field blank.
Group CC	The code identifying the Group Cost Center. Leave this field blank if a value is specified in the Cost Center field. Ensure the following: The code entered in this field is a valid group cost center that is in active status as defined for the type “Group” for the login OU. The value entered in this field forms part of the CE Structure ID specified. The code identifying the Group Cost Center. Help facility available
Cost Center	A unique code identifying the cost center. Leave this field blank if a value is specified in the Group CC field. Ensure the following: The code entered in this field is a valid cost center in active status as defined for the type “Detail” for the login OU. The value entered in this field forms part of the CE Structure ID specified Help facility available
Budget Display	Use the drop-down list box to specify the period for which the budget is to be displayed in the report. The system lists the following options: All Periods – The Budget is displayed for all the period in the report. Reporting Periods – The Budget is displayed only for the reporting periods in the report. The system displays the value ‘All Periods’, by default.
Report Grouping	Use the drop-down list box to specify the grouping based on which the report is displayed. The system lists the value ‘Cost Center’ along with a blank value. The system leaves the field blank, by default.
Budget #	The code identifying the MAC budget. Data entry in this field is mandatory if the associated CE Structure ID has Cost Budget based values (Source Info in one of the columns is specified as Budget). Ensure the following: The code entered in this field is a budget number as defined for the “Definition Type' - "Cost Center - Cost Element". The budget is a period budget. Help facility available
Version #	The number identifying the version of the budget, (Decimal). Mandatory. Ensure that the value entered here exists for the budget number and is in “Active” status as defined in the “Cost Budget” business component. Data entry in this field is mandatory if Budget # is specified for the given row in the multiline.
Budget # (Adj. Actuals)	The code identifying the MAC budget. Data entry in this field is mandatory if the associated Col. Structure ID has Cost Budget based values (Source Info in one of the columns is specified as Budget (Adj. Actuals). Help facility available.
Version #	The number identifying the version of the Budget (Adj. Actuals), (Decimal). Mandatory. Ensure that the value entered here exists for the budget number and is in “Active” status as defined in the “Cost Budget” business component. Data entry in this field is mandatory if Budget (Adj. Actuals) # is specified for the given row in the multiline.
Incl. Allocation	Use the drop-down list box to indicate whether you want the report to include the amount of allocations made by other cost centers, which includes the real-time processing allocated values to the values of the cost centers as specified in the “CC Structure ID” field or the From and Cost Center To fields. Yes No By default the system leaves this field blank.
Allocation Type	Use the drop-down list box to specify the type of allocation. Data selection in this field is mandatory if “Yes” is selected in the “Ind. Allocation” drop-down list box. The system lists all the active quick codes as defined for the entity “MAC ALLOCATION REPORT TYPE" in the Quick Codes activity of the current business component. By default the system leaves this field blank.
Display Amount In	Use the drop-down list box to select the basis in which you wish the values in the report to be displayed. The system lists the following options: Actuals - Indicates that actual values will be displayed in the report. Billion - Indicates that values will be displayed in billions in the report. Million - Indicates that values will be displayed in millions in the report. Thousands - Indicates that values will be displayed in thousands in the report. The system displays “Actuals” by default in this field.

The system displays the following field:

File Name

The file name link which has been processed.

Note: Ensure that data exists at least for one row in the multiline.

Note: The system displays only the “Print” pushbutton if “On-Screen Launch” radio button is selected.

Click the “Get Details” pushbutton to retrieve the details in the multiline.
Click the “Save” pushbutton to save details of the Run #.

The system performs the following:

Updates the status of the record as “Fresh”.
Allows modification to the information saved against a Run # that is in “Fresh” status only.
Click the “Confirm & Initiate” pushbutton to confirm and initiate the report process.
Click the “Print” pushbutton to generate the Cost & Profitability Report based on the criteria specified.

Note: Ensure that only one record in the multiline is selected for printing.

The system performs the following:

4 Updates the status of the Run # as In-Progress on start of report processing.

4 Updates the status of the Run # as Processed once the report processing is completed.

Click the “Preview as PDF” pushbutton to preview the report layout for the Column Structure ID in PDF.

Note: This pushbutton appears only if the screen is launched from “Manage Cost Column Structure” screen. The header section and the fields 'Budget #','Version #','Incl. Allocation', 'Allocation Type', 'Display Amount In' does not appear if the screen is launched from “Manage Cost Column Structure” screen.

The system displays the following fields in the “Record Statistics” group box:

Created By	The login user who created the report.
Created Date	The date on which the report was created.
Modified By	The login user who modified the report.
Modified Date	The date on which the report was modified.

Prerequisites

4 CE structure, Colomn Structure and Cost Center Structures must have already been defined and in both valid and active status.