3.5 Derived Dimensions & Dimension Default Templates

3.5 Derived Dimensions & Dimension Default Templates

To ensure transactional accuracy and accelerate data entry, Dynamics 365 Finance provides automated dimension defaulting mechanisms. Rather than requiring users to manually enter every segment on every transaction line, organizations implement Derived Dimensions, Financial Dimension Default Templates, and Master Data Defaulting Hierarchies.

---

1. Derived Dimensions: Architecture & Configuration

Derived Dimensions (General ledger > Chart of accounts > Dimensions > Financial dimensions > (Select Dimension) > Derived dimensions) establish business rules where selecting a specific value in a "driving" (parent) dimension automatically populates one or more "derived" (child) dimension values.

+-----------------------------------------------------------------------------+
|                        DERIVED DIMENSION LOGIC                              |
+-----------------------------------------------------------------------------+
|  Driving Dimension: CostCenter                                              |
|                                                                             |
|  Rule Mapping:                                                              |
|  When CostCenter = "CC-100" (Manufacturing North)                           |
|  ===> Derived Department   = "DEP-PROD" (Production)                        |
|  ===> Derived BusinessUnit = "BU-MFG"   (Manufacturing Division)            |
|                                                                             |
|  Key Parameter: Replace existing dimension values with derived values       |
|  - Yes: Overwrites any pre-existing Department or BU on the line.          |
|  - No:  Only populates Department or BU if the field is currently blank.   |
+-----------------------------------------------------------------------------+

The "Replace Existing Dimension Values" Parameter

A critical exam concept is understanding the toggle Replace existing dimension values with derived values:

• Set to 'Yes': The derived dimension rule acts as an authoritative override. If a user or an upstream master record (e.g., an Item default) has already stamped Department = DEP-ADMIN, selecting CostCenter = CC-100 will forcefully overwrite Department to DEP-PROD.
• Set to 'No': The derived dimension acts as a fallback. If Department is already populated with DEP-ADMIN, the system preserves DEP-ADMIN and does not overwrite it. It will only populate DEP-PROD if Department was null/blank.

Prevent Changes to Derived Values

Administrators can also enable Prevent changes to derived values. When enabled, once a derived dimension is applied to a transaction line, the derived segment is rendered read-only in the user interface, preventing manual tampering.

---

2. Financial Dimension Default Templates

In scenarios where costs must be shared across multiple departments or business units by a fixed percentage (e.g., allocating facility rent 60% to Operations and 40% to Corporate HQ), creating multiple manual journal lines is inefficient. Dynamics 365 Finance solves this via Financial Dimension Default Templates (General ledger > Chart of accounts > Dimensions > Financial dimension default templates).

+-----------------------------------------------------------------------------+
|             FINANCIAL DIMENSION DEFAULT TEMPLATE: "FACILITY-SPLIT"           |
+-----------------------------------------------------------------------------+
|  Line 1: Percentage = 60.00% | BU: 001 | Department: DEP-OPS  | CC: CC-MFG  |
|  Line 2: Percentage = 40.00% | BU: 001 | Department: DEP-CORP | CC: CC-ADMIN|
|  Total:              100.00%                                                |
+-----------------------------------------------------------------------------+

Application Across Source Documents

Financial dimension default templates can be selected directly on:

• General Journal Lines: Automatically splits the voucher line into multiple offset entries upon distribution.
• Free Text Invoices: Allocates customer billing lines across departments.
• Vendor Invoices & Purchase Orders: Splits procurement expenditure lines across multiple cost centers during accounting distribution.

---

3. Master Data Defaulting & Dimension Merging Hierarchy

When a transaction is generated in Dynamics 365 Finance (e.g., a Sales Order Line, Purchase Order Line, or Vendor Invoice), dimensions originate from multiple master data entities simultaneously. The system uses a deterministic Dimension Merging Pipeline to resolve values.

+-----------------------------------------------------------------------------+
|                    5-LAYER DIMENSION MERGING PIPELINE                       |
+-----------------------------------------------------------------------------+
|  [Layer 1: Document Header]  (Customer / Vendor Header Defaults)            |
|              |                                                              |
|              v                                                              |
|  [Layer 2: Document Line]    (Item / Released Product Defaults)             |
|              |                                                              |
|              v                                                              |
|  [Layer 3: Derived Rules]    (Derived Dimension Automation)                 |
|              |                                                              |
|              v                                                              |
|  [Layer 4: Main Account]     (Legal Entity Overrides - Not Fixed)           |
|              |                                                              |
|              v                                                              |
|  [Layer 5: FIXED VALUE]      (Main Account Legal Entity Override = FIXED)   |
+-----------------------------------------------------------------------------+

Detailed Merging Rules by Scenario

Scenario A: Sales Order Line Creation

1. Header Default: The Customer record has default dimensions BusinessUnit = BU-01, Department = DEP-SALES.
2. Line Default: The Released Product (Item) being sold has default dimensions Department = DEP-PROD, CostCenter = CC-100.
3. Merge Logic: The transaction line inherits BusinessUnit = BU-01 (from Customer Header), CostCenter = CC-100 (from Item Line), and for the conflicting Department segment, the Line/Item default takes precedence over the Header default, resulting in Department = DEP-PROD.

Scenario B: The Main Account "Fixed Value" Override

Main accounts allow setting financial dimension defaults with two distinct behaviors under Legal entity overrides > Default financial dimensions:

• Not fixed: The main account dimension defaults onto the line if blank, but allows upstream defaults (from Customer or Item) and manual overrides.
• Fixed value: The main account dimension strictly overrides all other values. Regardless of what is specified on the Customer, Vendor, Item, or Journal line, the General Ledger posting engine forces the segment to the Fixed Value.

---

4. Configuration Walkthrough: Derived Dimensions Setup

+-----------------------------------------------------------------------------+
|                   DERIVED DIMENSION STEP-BY-STEP FLOW                       |
+-----------------------------------------------------------------------------+
|  1. Open GL > Financial dimensions > Select 'Department'                   |
|  2. Click 'Derived dimensions' in Action Pane                              |
|  3. Add Segment: 'CostCenter' as derived target                            |
|  4. In Values Grid: Add row for Department 'DEP-100'                       |
|  5. Set Target CostCenter = 'CC-100'                                       |
|  6. Set 'Replace existing dimension values' = Yes                          |
|  7. Click Save and Test in General Journal Entry                           |
+-----------------------------------------------------------------------------+

Step-by-Step Implementation

1. Navigate to General ledger > Chart of accounts > Dimensions > Financial dimensions.
2. Select the Department dimension from the grid.
3. In the Action Pane, click Derived dimensions.
4. In the Derived dimensions form, click Add segment and select CostCenter.
5. In the Values tab, click New.
6. In the Department column, select DEP-100 (Human Resources).
7. In the derived CostCenter column, select CC-HR-01.
8. Set the toggle Replace existing dimension values with derived values to Yes.
9. Close the form. When a user creates a journal entry and selects Department = DEP-100, the system automatically inserts CostCenter = CC-HR-01.