Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Configure Alternate Account Set Mapping Rules in AP&C

Configure Alternate Account Set Mapping Rules in AP&C

In Adaptive Planning and Consolidation (AP&C), you can add mapping rule conditions to your forward and reverse alternate account sets mapping rules for a ledger account type or a ledger account.
  1. Access the
    View Alternate Account Set Mapping
     report.
  2. Select an
    Alternate Account Set Mapping
     and a ledger account or ledger account type.
  3. As you add rule conditions, consider:
    Option Description
    Edit Default Ledger Account
    In the
    Include Specific Ledger Accounts
     or
    Include All from Ledger Account Types
     fields, select 1 or more ledger accounts or ledger account types. Workday displays a list of the ledger accounts for the selected alternate account set mapping.
    For each row, select a related
    Default Ledger Account
    , as needed.
    You can only use a ledger account as a default once per mapping rule
    Workday post journals to the default ledger account when transactions don't match any of the alternate account set mapping rule conditions.
    Edit Mapping Name
    Change an existing mapping name.
    View Specific Mapping Rules
    Filter mapping rules to display a smaller range for selected ledger accounts and ledger account types for either forward or reverse alternate account set mapping.
    Sort Specific Mapping Rules
    Manually order a selected subset of mapping rule conditions.
    Order conditions from most to least restrictive. Workday evaluates alternate account set condition rules from the top down.
    Add New Mapping Rules
    Add mapping rule conditions to your mapping rules. You can only use a ledger account once per mapping rule. When defining mapping rule conditions:
    Enter 1 or more condition values or resulting values.
    You can select either a condition value or a resulting value for mapping rules, but not both.
    Use unique mapping
    Condition Values
     for each line of a forward or reversal mapping rule.
    Workday derives the reverse mapping rules based on the rules you define.
    Edit Mapping Rule
    Modify mapping rule conditions.
    When you retire ledger accounts, update any relevant mapping rules as soon as the account set changes. The alternate account set mapping rules won't have condition rules that resolve to the retired accounts.
    Test Mapping Rule
    The test displays the conditions a selected account set mapping rule meets. You can test the values for existing alternate account set mapping rules for a selected ledger account to view:
    • Condition Values
    • Ledger Account Returned
    • Resulting Values
Workday creates the forward mapping rules with condition dimensions and dimension values that have reverse mapping rules with:
  • Resulting ledger accounts.
  • Resulting dimensions.
  • Resulting dimension values.
  • Worktags.