Skip to main content
Version: Current

Dimension

Overview

Direction: Business Central → Zudello
Sync Type: Incremental sync
Entity Types: Projects, Departments, Cost Centres, Cost Types, Locations

Dimension values from Business Central synchronize to Zudello to support cost center tracking, project accounting, and departmental reporting across purchase transactions.

Configuration Required

Metadata Setup: Dimension mappings require metadata configuration to specify which Business Central dimensions map to which Zudello entities

Field Mappings

Zudello FieldBusiness Central FieldData TypeNotes
codecodeStringDimension value code
namedisplayNameStringDimension value description
statusN/AStringAlways set to ACTIVE

Dimension Type Mappings

Business Central DimensionZudello EntityConfiguration Required
ProjectsProjectdimension_project metadata
DepartmentsDepartmentdimension_department metadata
Cost CentresCost Centredimension_cost_centre metadata
Cost TypesCost Typedimension_cost_type metadata
LocationsLocationdimension_location metadata

Configuration Setup

Metadata Configuration

To correctly map dimensions from Business Central to Zudello, you must configure metadata settings. This tells the integration which Business Central dimension corresponds to which entity in Zudello.

For example, to map the Business Central dimension for projects, you would set up a mapping that links the PROJECT dimension in Business Central to the Project entity in Zudello.

Example Mappings:

  • Map Business Central's PROJECT dimension to Zudello's Project entity.
  • Map Business Central's DEPARTMENT dimension to Zudello's Department entity.
  • Map Business Central's COST_CENTRE dimension to Zudello's Cost Centre entity.
Important Notes
  • Dimension Code Matching: The dimension code used in the configuration must exactly match the code in Business Central.
  • Entity Type Values: The Zudello entity type must be one of the supported types (e.g., Project, Department).
  • Case Sensitivity: The codes and values used in the configuration are case-sensitive.

Processing Logic

Sync Behavior

  • Incremental Updates: The integration efficiently syncs only dimensions that have been added or changed since the last synchronization.
  • Grouping: Dimension values are grouped by their parent dimension during processing to ensure correct mapping.
  • Status Handling: All synchronized dimensions are automatically set to ACTIVE in Zudello.

Data Flow

  1. The integration fetches dimension values from Business Central.
  2. It then groups these values based on the dimension they belong to (e.g., all project codes are grouped together).
  3. The system applies the configured metadata mappings to direct the values to the correct Zudello entity.
  4. Finally, it creates or updates the corresponding records in Zudello (e.g., new projects, departments).

Troubleshooting

IssueCauseSolution
Dimensions not syncingMissing metadata configAdd dimension mapping to metadata
Wrong entity typeIncorrect metadata valueUse supported entity types only
Duplicate entriesDimension code mismatchVerify dimension codes match exactly
Status issuesProcessing errorCheck dimension values exist in BC