Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Create Supplemental Data Templates in AP&C

Create Supplemental Data Templates in AP&C

  • Create text lists.
  • Create Calc fields.
  • Security:
    Setup: Supplemental Data
     security domain in the Advanced Close and Consolidation functional area.
Create Supplemental Data Templates in Adaptive Planning and Consolidation (AP&C) to:
  • Ensure consistent data collection across distributed teams.
  • Create a template configuration based on your organization’s specific use cases.
  • Configure each supplemental data template with these 5 delivered Data Types:
    • Currency
    • Date
    • Numeric
    • Text
    • Text List
  1. (Optional) Create calculated fields if you want to define arithmetic expressions for certain columns within a template. See Concept: Calculated Fields in Supplemental Schedules in AP&C.
  2. Access the
    Create Supplemental Data Template
     task.
  3. As you complete the template header, consider:
    Option Description
    Name (Required)
    Enter a unique name for the supplemental data template.
    Description (Required)
    Enter a description for the supplemental data template.
    Fiscal Schedule (Required)
    Select a fiscal schedule for the template. Supplemental Data you create from this template will only display periods from the selected fiscal schedule.
    This schedule will likely be the shared fiscal schedule for your reporting hierarchy.
    Default Account Translation Method (Required when Currency Data Types are configured)
     When you configure at least 1 Currency Data Type on a template, the
    Default Account Translation Method
     field becomes available and is required. Select the appropriate Account Translation Method configuration that you’ll use to determine the correct currency conversion Rate Type for all
    Currency Data Types
     configured on the template.
    Workday will apply the Account Translation Method configured at the header level to all Currency Data Types configured in the Template.
    For alternative Account Translation Method configuration options, you can override the template header level configuration by using either of these configurations at the column or row level:
    • Currency Data Type at the column level within the
      Properties
       section for the Currency Data Type.
    • Text List Data Type at the row level with the Account Translation Method configuration. See Create Supplemental Data Text List in AP&C.
    Roll Forward (Optional)
    Enable the option to define additional template configurations when creating a balance sheet roll-forward type of schedule.
    If you enable
    Roll Forward
     you must select or create a calculated field on the
    Data Type
     column of Currency.
  4. In the
    Data Type
     grid, each row represents a column you want to include in your template.
    You can enter a maximum of 25 columns and each column name must be unique.
  5. As you enter data for the 5 Workday delivered Data Types, consider:
    Option Description
    Currency
     - Data type used to capture currency amount values. Example: $0.00.
    Click
    Properties
     to:
    • (Optional) Select an Account Translation Method configuration to override the value you specified in the
      Default Account Translation Method
       field in the template header for the specific
      Currency Data Type
       columns. (Column Level).  If the specific Currency Data Type column is the result of an arithmetic calculation (Example: Ending Balance when rolling forward ending balances, then select or create a Calculated Field to derive calculations in Worksheets. See Concept: Calculated Fields in Supplemental Schedules in AP&C.
    Date
     - Data type used to capture date values. Example: MM/DD/YYYY.
    For certain Account Translation Method selections that have a Currency Rate As of Date set to Transaction Date or Transaction Period End Date, you must specify 1 Date Data Type column on a Supplemental Data Template.
    Text
     - Data type to to capture free-form text.
    None
    Text List
     - Data type to capture specific text list items from a configured text list.
    Select a Text List in
    Properties
    .
    You can’t have more than 1 Text List with an Account Translation Method Configuration configured on a given Supplemental Data Template.
    To specify a translation method at the Row Level, select a
    Text List
     that has an Account Translation Method configuration.
    Row level configurations will override these 2 specified values:
    • In the
      Default Account Translation Method
       field in the template header(Header Level).
    • Translation configurations in the
      Properties
       section for a
      Currency Data Type
       (Column Level).
    Numeric
     - Data type used to capture non-currency numeric values. Example: 0.00.
    Click
    Properties
     to select or create a calculated field to calculate the column values when performing data entry based on the arithmetic expression configured.
    When creating calculated fields, keep these guidelines in consideration. Se
  6. Click
    OK
     and then
    Done
    .
Workday creates a Supplemental Data Template.
  • Once you generate and approve Supplemental Data from a given Supplemental Data Template, you can’t modify the template.
  • You can copy the Header information and column properties of Supplemental Data Templates at any time.
  • Supplemental Data Templates that you create will have a default status of
    Inactive: No
    .  To prevent an end user from creating new Supplemental Data from a given template, you can change it to a status of
    Inactive
     using the
    Maintain Supplemental Data Templates
     task. See Maintain Supplemental Data Templates in AP&C.
Create supplemental data. See Create Supplemental Data in AP&C.