Default Dimensions in D365 Finance

Linking financial dimensions to master records (Customers, Vendors, Products) via integrations in Dynamics 365 Finance requires a specific data format. 
 

The Key Field: DefaultDimensionDisplayValue

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

  • Logic: A concatenated string of values based on how they were defined in D365 Finance (General ledger > Chart of accounts > Dimensions > Financial dimension configuration for integrating applications).
  • Delimiter: Use the system-defined character (usually a hyphen - or pipe |).

 String Formatting Rules

The string must be precise. The system counts the segments; if the count is wrong, the integration will fail.

  • Full Values: If every dimension has a value: 1400-1000-110-RES01
  • Skipping Middle Values: If a middle dimension is blank, keep the delimiters: 1400--110-RES01 (Department is empty).
  • Trailing Blanks: If the final dimensions are empty, include the trailing delimiters: 1400-1000-110- (Resource is empty).

Integration Example: Mapping to DefaultDimensionDisplayValue

When integrating, you must convert the visual fields in D365 into a single concatenated string. This table shows how to format that string based on different scenarios for a new customer.

ScenarioCost CenterDepartmentJobResourceIntegration string (value to send)
All dimensions14001000110RES011400-1000-110-RES01
Missing "Resource"140010001101400-1000-110-
Missing "Department"1400110RES011400--110-RES01
Only "Cost Center"14001400---