Adding Capital Templates

Now that your Finance Mode templates are set up, create Capital Templates, which act as place holders to load assets, categories, and defined finance modes to in the Planning Control Panel. End-users will open Capital Templates for input in the Planning Control Panel, then load assets and associated finance mode lines to the template for budgeting purposes.

To add a Capital Template:

1. Navigate to Maintenance > Templates > Template Setup.

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

3. Click the Add button.

4. For Template Type , select Capital Template.

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

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

7. 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.

8. 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.

   • 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.

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

10. Click the Template Columns tab. This is where you will configure template column structures such as Time Set and Template Attribute Columns.

    • 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. 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:

      • 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. Year Totals For - Determines the way the Year Total column is produced on the template.

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

11. Attribute Columns - Attribute selections are not available and are pre-populated based on your configuration on the Define Capital Budgeting Criteria page shown below.

    

12. Click the Segment Members tab.

    • 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.

    • Allow Destination Account Setup - Allows administrators to override the control panel setting.

13. Click Save and click the Back button to return to the Template List page. There is NO Template Setup for Capital templates. Template set up is completed when assets, finance modes, and asset categories set up is complete.