How to Add a Line Item Template Type
  • 8 Minutes to read
  • Dark
    Light
  • PDF

How to Add a Line Item Template Type

  • Dark
    Light
  • PDF

Article summary

Complete the following steps to add a Line Item template.

  1. Navigate to Maintenance > Templates > Template Setup.
    template%20setup

  1. Select the Default scenario. All templates must be created on the Default scenario and then mapped to your scenarios of choice.

  1. Click the Add button.
    add%20template

  1. For Template Type, select Line Item Template.
    line%20item

  1. Enter Template Code (enter any code that correlates with your company's current identification practices).

  1. Enter Template Name (enter a descriptive and identifiable name).

  1. Select the Entity Type for the template. This information is populated from the Entity Types set up in Hierarchy Management. Entity types are associated with the lowest level members of the budget hierarchy.

  1. For Data Transfer select Apply Sign Reversal or No Sign Reversal. This selection works with the Debit/Credit field in the Natural Account segment. Debit accounts typically display data in the same sign as stored in the database. Credit type accounts typically store data in the opposite sign of that stored in the database. Therefore, a credit becomes a debit (or negative) in the database, but is displayed as a positive in reports and during input.
    data%20transfer(2)

    • Apply Sign Reversal - Select this option so that credit type accounts are displayed and entered opposite the sign they are stored.

    • No Sign Reversal - Select this option to display and enter balances as they should be stored in the database.

  1. For Line Code Header and Line Name Header, enter a code to identify the column and a label for columns with line names. These fields are optional. You can lock these fields so that users working on the template in the Planning Control Panel can't edit.

  1. Customize the Default Line Name for templates. The change will be reflected once the template is opened and closed or processed via the Simulation Engine. For example, an Admin might configure the Line Name column to display account or product name. In the image below, the Default Line Name is Vendor. Additionally, Admin users can hide the Line Code column so that unnecessary information is not displayed to the end user. The Default Line Name and Seed Lines Based On fields in the image above must be selected to get a second dimension to budget to. In this case it is by category by vendor. For Seed Lines Based On, All must be selected because if None is selected, there will be no history data. Select All for history data.

To change the Default Line Name for an existing template:

  1. Navigate to Maintenance > Templates > Template Setup.

  2. Select a template and click the Edit icon.

  3. Change the Default Line Name and then click Save. It is recommended that this action is performed in the Default scenario and ensure the updated template is mapped to other scenarios.

  4. Next, navigate to the Planning Control Panel. Open and close (manually or via simulation engine) the template to process the change so that the Default Line Name is updated.

Note:
This functionality is available for all template types except for HR, Capital, Initiative and Block.
  1. For Seed Lines Based On, select to seed template line data from all scenarios as set up on the scenario page, the compare scenarios selected on the Scenario page or history periods.

  1. Select Enable Subline Processing if you want all sublines associated with the template are processed along with the template. For more information, see Avoiding Line Discrepancies Between Sub and Main Templates.

  1. For Display Line Code, select the checkbox to display a separate column in the template for the line codes.

  1. For Enable Global Fields, select the checkbox to allow global fields in the template setup. Administrators may centrally maintain drivers used in the calculations within a template. See Setting Up and Applying Global Fields to Templates.

  1. For Enable Spreads, select the checkbox to allow users to spread data from a total column to period columns, based on the selected spread method. See Setting Up and Using Spreads in Templates.

  1. For Enable Compare Scenarios, select the checkbox to enable the scenario associated with the template to be compared against another scenario. See Compare Scenarios.
    enable(2)

  1. Click the Template Columns tab. This is where you will configure template column structures such as Time Set and Template Attribute/Summary Columns. See Template Line Types and Column Types.

    Default Time Set/Custom Time Set - Time Sets allow budget input at a selected time period frequency in a budget template for each budget input year. This flexibility allows you to create templates with accurate operational plans and provide a means for long term strategic planning. By default, the Planful system assumes a one fiscal year (12 period) configuration, which is equal to months. This option is selected by default. Deselect this option and select Custom Time Set to allow additional time set fields to create time sets with varying frequencies. Once created, they are mapped to templates.

    Fields available when Custom Time Set is selected:
    template%20columns(1)

    • Time Set - Select the time set you want associated with the template. The Time Set options available are those you defined on the Define Time Sets page.

    • Year Total Columns - This selection determines the position of the Year Total(s) columns on the template with respect to the Budget Periods.

      • Before Budget Periods – Places the Year Total(s) column before all budget periods.

      • After Budget Periods - Places the Year Total(s) column after all budget periods.

      • By Budget Periods (Before) – Places the Year Total(s) column before the budget periods per time set structure (year, quarter, month).

      • By Budget Periods (After) - Places the Year Total(s) column after the budget periods per time set structure (year, quarter, month).

    • Year Totals For - Determines the way the Year Total column is produced on the template.

      • Required Budget Periods - Creates the Year Total column, which contains data for periods with non-year level budget input.

      • All Periods - Creates the Year Total column which contains data for all years.

    • Annual Value - Applicable for managing spread values for multi-year scenarios. Select to have separate spread columns for each year annual value or a single spread column for all years.

Note:
Time sets are available for Global Template Single Copy, Global Template Entity Copy, Line Item, and Allocation template types.
  1. For Attribute Columns, select the number of Attribute Columns you want to associate with the template. You can add up to 10 attribute columns.

    • Header - Enter the column name for the attribute column.

    • Width - Specify the column width. You may re-initiate template column widths from the template directly for any template type except for Initiative and Capital templates.

    • Format:

      • Row Format - Allows for attribute values with varying formats.

      • Text – Allows for text characters.

      • Number - Allows numerical values to be entered within the template.

      • Currency - Applies a currency symbol ($) to the first digit in each cell of the column.

      • Percent - Applies a percentage symbol (%) and allows users to enter numbers in a percent format.

    • Decimal - Specify the number of decimals.

    • Formula - This field is optional. You can apply a formula to the column. The formulas entered here are not adjusted automatically to respective lines when opened from the Planning Control Panel if the formulas contain absolute reference conditions.

    • Lock - Select to lock or unlock the attribute column from budget users. Budget users may not enter or edit data in locked attribute columns.

  1. For Summary Columns, by default, templates display a summary column to show the calculated year-to-date amounts. Up to 5 summary columns may be added to display other information.

    Header - Enter the column name for the summary column.

    Width - Select the column width.

    Format:

    Row Format - Allows for attribute values with varying formats.

    Text – Requires a textual character.

    Number - Requires numerical values to be entered within the template.

    Currency - Applies a currency symbol ($) to the first digit in each cell of the column.

    Percent - Applies a percentage symbol (%) and allows users to enter in a percent format.

    Lock - Select to lock or unlock the attribute column to allow or not allow budget user input.

    Formula - This field is optional. You may apply a formula to the column. The formulas entered here are not adjusted automatically to respective lines when opened from the Planning Control Panel if the formulas contain absolute reference conditions.

    Decimal - Specify the number of desired decimals.

Note:
There are maximums for attribute and summary columns. For example, the maximum number of attributes for the Global Template-Entity Copy and Global Template-Single Copy template types is 10. The maximum number of summary columns for these templates is 5. For Capital template types, attribute selections are not available and are pre-populated based on your configuration.
  1. Click the Segment Members tab. You can change Segment Member Sources (for Global Template Single Copy, Global Template Entity Copy, Allocation and Line item templates for the Default scenario). For example, if you have the Department segment set to 020 – HR, you can change this mapping and update the segment member selected. However, reporting currency default values may not be updated.
    segment%20members(1)

    • Segment - Displays the name of the segment.

    • Source- Select one of the following options, which determines how the segment is mapped for the input lines:

      • Control Panel - Select this option to have segments included in the budget entity definition default of the Control Panel. Click Allow to allow the control panel setting to be overridden.

      • Fixed Segment Member - Select this option to have segments with a fixed value for the entire template.

      • All Members - Indicates that the mapping for the respective definition is performed from the Template Input page along with the segment identified as a ‘Load’ segment. Note, a Load type segment is also a template segment.

      • Template Design Segment -Indicates that the mapping for the respective definition is performed from the template setup page.

      • Filtered Segment Members - Select for a dimension to select and map segment leaf level members to the template.

      • Planning Control Panel Member - Select a Fixed source to enable this field to assign the fixed segment value to the template.

      • Allow Destination Account Setup - Available when the Control Panel source is selected and allows administrators to override the control panel setting.

  1. Click the Report Mapping tab and select the Dynamic Reports you want mapped to the template.
    Report%20Mapping

  1. Click Save and click the Back button to return to the Template List page. Or, click More, Template Setup to select the line item categories set up on the Line Item Categories page.

Before you can perform Template set up, navigate to Maintenance > Templates > Line Item Category. Complete the set up. For information on how to do so, click on the Line Item Category link.


Was this article helpful?