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.
Metadata Setup: Dimension mappings require metadata configuration to specify which Business Central dimensions map to which Zudello entities
Field Mappings
Zudello Field | Business Central Field | Data Type | Notes |
---|---|---|---|
code | code | String | Dimension value code |
name | displayName | String | Dimension value description |
status | N/A | String | Always set to ACTIVE |
Dimension Type Mappings
Business Central Dimension | Zudello Entity | Configuration Required |
---|---|---|
Projects | Project | dimension_project metadata |
Departments | Department | dimension_department metadata |
Cost Centres | Cost Centre | dimension_cost_centre metadata |
Cost Types | Cost Type | dimension_cost_type metadata |
Locations | Location | dimension_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'sProject
entity. - Map Business Central's
DEPARTMENT
dimension to Zudello'sDepartment
entity. - Map Business Central's
COST_CENTRE
dimension to Zudello'sCost Centre
entity.
- 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
- The integration fetches dimension values from Business Central.
- It then groups these values based on the dimension they belong to (e.g., all project codes are grouped together).
- The system applies the configured metadata mappings to direct the values to the correct Zudello entity.
- Finally, it creates or updates the corresponding records in Zudello (e.g., new projects, departments).
Troubleshooting
Issue | Cause | Solution |
---|---|---|
Dimensions not syncing | Missing metadata config | Add dimension mapping to metadata |
Wrong entity type | Incorrect metadata value | Use supported entity types only |
Duplicate entries | Dimension code mismatch | Verify dimension codes match exactly |
Status issues | Processing error | Check dimension values exist in BC |
Related Documentation
- Purchase Invoice - How dimensions are applied to invoices
- Purchase Credit Memo - Dimension usage in credit processing
- Overview - Integration architecture and data flow