<turbo-stream action="update" target="wiki_card"><template>

<h1>Default Dimensions in D365 Finance</h1>
<div class="trix-content"><p>Linking financial dimensions to master records (Customers, Vendors, Products) via integrations in Dynamics 365 Finance requires a specific data format.&nbsp;<br>&nbsp;</p><p><strong><u>The Key Field: </u></strong><strong><code><u>DefaultDimensionDisplayValue</u></code></strong></p><p>Unlike the user interface, integrations (OData, DMF, Power Automate) do not use separate fields for each dimension. Instead, they use a single string field called <strong><code>DefaultDimensionDisplayValue</code></strong>.</p><ul><li><strong>Logic</strong>: A concatenated string of values based on how they were defined in D365 Finance (General ledger &gt; Chart of accounts &gt; Dimensions &gt; <strong>Financial dimension configuration for integrating applications).</strong></li><li><strong>Delimiter</strong>: Use the system-defined character (usually a hyphen <code>-</code> or pipe <code>|</code>).</li></ul><p><strong><u>&nbsp;String Formatting Rules</u></strong></p><p>The string must be precise. The system counts the segments; if the count is wrong, the integration will fail.</p><ul><li><strong>Full Values</strong>: If every dimension has a value: <code>1400-1000-110-RES01</code></li><li><strong>Skipping Middle Values</strong>: If a middle dimension is blank, keep the delimiters: <code>1400--110-RES01</code> (Department is empty).</li><li><strong>Trailing Blanks</strong>: If the final dimensions are empty, include the trailing delimiters: <code>1400-1000-110-</code> (Resource is empty).</li></ul><p>Integration Example: Mapping to <code>DefaultDimensionDisplayValue</code></p><p>When integrating, you must convert the visual fields in D365 into a single <strong>concatenated string</strong>. This table shows how to format that string based on different scenarios for a new customer.</p><p></p><figure class="attachment attachment--content"><table class="table table-bordered"><thead><tr><td>Scenario</td><td>Cost Center</td><td>Department</td><td>Job</td><td>Resource</td><td>Integration string (value to send)</td></tr></thead><tbody><tr><td>All dimensions</td><td>1400</td><td>1000</td><td>110</td><td>RES01</td><td>1400-1000-110-RES01</td></tr><tr><td>Missing "Resource"</td><td>1400</td><td>1000</td><td>110</td><td></td><td>1400-1000-110-</td></tr><tr><td>Missing "Department"</td><td>1400</td><td></td><td>110</td><td>RES01</td><td>1400--110-RES01</td></tr><tr><td>Only "Cost Center"</td><td>1400</td><td></td><td></td><td></td><td>1400---</td></tr></tbody></table><figcaption class="attachment__caption"></figcaption></figure><p></p></div>
</template></turbo-stream>

