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
PROJECTdimension to Zudello'sProjectentity. - Map Business Central's
DEPARTMENTdimension to Zudello'sDepartmententity. - Map Business Central's
COST_CENTREdimension to Zudello'sCost Centreentity.
- 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
ACTIVEin 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