Managing Cost Column Structure

Managing cost column structure

Select the “Manage Cost Column Structure” activity under the “Cost Setup” business component.

The “Manage Cost Column Structure” page appears.

Enter the following fields in the “Cost Column Structure Info” group box:

Column Structure ID

Use the drop-down list box to specify the basis on which you wish to create / modify or view a column structure. Mandatory. The system lists the following options:

New - Select this option if you wish to create a New Column Structure ID.
Pre-defined - Select this option if you wish to create / for a predefined structure the modification is not allowed or view a Column Structure ID that has already been defined.
User Defined – Select this option if you wish to create, modify or view a user defined Column Structure ID.

In the drop-down list box alongside, select a value corresponding to the value specified in the Column Structure ID. Data selection in this field is mandatory if “Pre-defined” or “User Defined” is selected as the Column Structure ID. The system lists the options as follows:

Value selected in the Column Structure ID drop-down list box 1:	The system lists the following values in the adjacent drop-down list box:
New	Blank
Pre-defined	All the pre-defined Cost Column Structure IDs
User Defined	All the existing user defined Cost Column Structure IDs for the login OU company

Col. Str. Type

Use the drop-down list box to specify the type of the Cost column structure. The system lists the options ‘Simple’ and ‘Dynamic’. The system displays the value ‘Simple’, by default.

Classification

Use the drop-down list box to specify the classification of the Cost column structure. The system lists the value ‘Income Statement’.

Column Structure ID

A unique code identifying the Column Structure ID. Data entry in this field is mandatory if “New” is specified in the “Column Structure ID” drop-down list box

Ensure the following:

The value entered in this field is without any space or special character except ' - ' (hyphen).
The value entered in this field is a Column Structure ID that is unique for the login OU if “New” is specified as the “Column Structure ID” drop-down list box 1.
The value entered in this field is not modified if “Predefined” or “User Defined” as the “Column Structure ID” drop-down list box 1.

Help facility available

Descriptions

A textual description of Cost Column Structure. Mandatory.

No. of Columns

Use the drop-down list box to select the number of columns in the column structure. The system lists the following options 1, 2, 3, 4, 5, and 6.

Ensure that the number entered in this field is equal to the number of rows in the multiline for which data is entered.

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

This field appears only if the value of ‘Col. Str. Type’ field is selected as ‘Simple’.

The system displays the following fields in the multiline:

Note: Ensure that details of records in the multiline is for not more than 6 rows.

Column ID

The number identifying the column in which the value for the report is displayed.

The system displays the system currently displays ‘blank’” by default in this field.

Enter the following fields in the multiline:

Level #	The number identifying the level of the Column Structure ID.
Col. Seq #	The number identifying the sequence of the Column ID.
Column Name	The name of the column that will be displayed in the report. Data entry in this column is Mandatory if values are entered for other columns in that row. Ensure that the value entered in this field is a unique column name for the given Column Structure ID.
Type	Use the drop-down list box to specify the type of the Column ID. The system lists the values ‘Group’ and ‘Detail’. The system displays the value ‘Detail’, by default.
Parent	The immediate parent of the Column ID.
Nature	Use the drop-down list box to specify the nature of the Column ID. The system displays the following options: § Static –Report displays the Column Name as Header in one Column. § Dynamic – Report displays the Column Name based on the Column Dimension and the values applicable for the Column Dimension. The system displays the value ‘Static’, by default.

The system displays the following field in the multiline:

Dimension Req.

Indicates whether the dimension is required for the column ID. This field displays the value ‘Yes’, if ‘Nature’ field is selected as ‘Dynamic’.

Enter the following fields in the multiline:

Dimension	Use the drop-down list box to specify the dimension of the column ID. The system lists the following values along with a blank value: § Reporting Period – Dimension is based on ‘Financial Period from’ and ‘Financial Period to’ fields in the “Generate Report” Screen. § Cost Center - Dimension is based on the ‘CC Structure ID’ and ‘CC Report option’ in the “Generate Report” Screen. § Analysis Code - Dimension is based on the Analysis Code for which data is available for the ‘Cost Center’ and Period of the Column ID. The system leaves the field blank, by default.
Source Info	Use the drop-down list box to specify the source from where the values for the report are to be derived. Data selection in this field is mandatory if values are entered for other columns in that row. The system lists the following options along with a blank value: · Budget – Select this option if the source of the values for the report is to be from the cost budget · Actuals – Select this option if the values for the report is to be the actual. · User Defined Formula - Select this option if the source for the values for the report is to be derived from the formulae as defined in “Manage Formula” activity. · Budget (Adj. Actuals) – Select this option if the values for the report is to be derived from Actual balances for the Period till the (Financial Period to - 1) in 'Actuals till' and Budget data for the Budget #, Version # given. By default the system leaves this field blank.
Data Based on	Use the drop-down list box to specify the basis of the data for the report. Data selection is mandatory in this field if values are entered for other columns in that row. The system lists the following options along with a blank value: · YTD - Year to Date Balance till the selected Financial Period To. · Period – The balance in the Cost Center/Analysis Code/Account Code to be displayed for the Financial Period from and to in one columns( When there is no period dimension). If Period is a dimension in the report, then display the periods as per the requirement of the period dimension.) · Formula - Column Level – Indicates the formula defined for two columns in this column structure in the “Manage Formula” activity. · Formula - Column-Element level – Indicates formula defined for a column and an element in the “Manage CE Structure” activity. Note that the formula for this column is to be defined for the Report ID which has this column structure. · Comparative Period – When comparative Period is selected, display the values based on value given in Comparison Factor. When -1 is selected in Comparison Factor, display values from the Previous Financial Period to the selected Financial Period to. · Previous Year End - When Previous Year End is selected, display values for the Previous Financial Year - Full year. · Comparative Year – When comparative Year is selected, display the values based on value given in Comparison Factor. Example : (When -1 is selected in Comparison Factor, display values from the Previous Financial Year to the selected Financial Year. When +1 is selected in Comparison Factor, display values from the Next Financial Year to the selected Financial Year.) · Full Year - When Full Year is selected, display the values for the full financial year. · Comparative YTD – When Comparative YTD is given, display Year to Date balance based on the Comparison Factor. Ensure the following: · Either 'Formula - Column level' or 'Formula - Column-Element level' is selected in this field if “User Defined Formula” is specified as the “Source Info”. By default the system leaves this field blank.
Comparison Factor	The factor used for the comparison. Provide an Integer value which is positive or negative.
Qty/Value	Use the drop-down list box to specify the whether the data for the report has to be derived based on quantity or values. Data entry in this field is mandatory if “Budget” or “Actuals” is selected as the “Source Info”. The system lists the following options: · Quantity - Indicates data for the report is to be based on quantity. · Value – Indicates data for the report is to be based on value. Leave this field blank if “User Defined Formula” is specified as the “Source Info”. By default the system displays “Value” in this field.
Total	Use the drop-down list box to specify whether the total of the Column ID is to be displayed in the report. The system lists the value ‘Yes’ along with the blank value. The system leaves the field blank, by default.
Display	Use the drop-down list box to specify whether the Column ID is to be displayed in the report. The system lists the values ‘Yes’ and ‘No’. The system displays the value ‘Yes’, by default.

The system displays the following fields in the multiline

Formula

Indicates whether formula is defined for the row, which could be “fx-defined” or “fx-Not defined”

Note that the system leaves this field blank if “Formula - Column-Element level” is specified as the “Data Based On”.

Formula Display

Formula defined in the Manage formula

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

Click the “Save” pushbutton to save the details against the Column Structure ID.

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

Created by	The login user who created the Column Structure ID.
Created date	The date on which the Column Structure ID was created.
Modified by	The login user who modified the Column Structure ID.
Modified date	The date on which the Column Structure ID was modified.

To proceed, carry out the following:

Select the Preview Report Layout link at the bottom of the page to preview the report layout for the Column Structure ID.