GeneralThe BRZ Interface app connects Microsoft Dynamics 365 Business Central to the BRZ payroll and cost-accounting environment. It exchanges CSV files for employee master data, payroll postings, and project data through a SharePoint document library, using Microsoft Graph for secure file access.
The app is used by finance and payroll administrators who import employee and payroll data delivered by BRZ into Business Central, and who export project data from Business Central back to BRZ. Every import or export run is logged so that administrators can trace which files were processed and when.
App SetupThe BRZ Import/Export Setup page holds all information the app needs to connect to the BRZ SharePoint document library and to post imported payroll data correctly. Configure this page once before running any import or export.
For company-specific BRZ identifiers, use the Companies page. These values are stored per company and are used in project export data.
| Field | Description |
| Tenant ID | The Tenant ID (directory ID) of the Azure AD App Registration used to sign in to Microsoft Graph. |
| Client ID | The Application (client) ID of the Azure AD App Registration. |
| Client Secret Key | The client secret of the App Registration. The value is stored encrypted and only asterisks are shown once it has been entered. |
| Base URL | The base URL of the SharePoint site that hosts the document library, for example https://company.sharepoint.com. |
| Site Name | The name of the SharePoint subsite, if the document library is not located directly under the base URL. |
| Archive Folder | Folder where a successfully imported file is moved to after processing. |
| Error Folder | Folder where a file is moved to if the import finished with errors. |
| Field | Description |
| BRZ-Bauartnr. | Construction type number used by BRZ, included in the project export file. |
| BRZ Mgt. Cost Type | Management cost type used by BRZ, included in the project export file. |
| Prefix Cost Center | Prefix that is added to the cost center code in the project export file. |
| Field | Description |
| Payroll FI Journal Template | General journal template that receives the financial accounting (F) lines from the payroll import. |
| Payroll FI Journal Batch | General journal batch that receives the financial accounting (F) lines from the payroll import. |
| Payroll CO Journal Template | Cost accounting journal template that receives the cost accounting (B) lines from the payroll import. |
| Payroll CO Journal Batch | Cost accounting journal batch that receives the cost accounting (B) lines from the payroll import. |
| Payroll Cost Object empty | Default cost object used when a payroll line does not specify one. |
These fields provide default values used when new resources are created during the employee import.
| Field | Description |
| Res. Gen. Prod. Posting Group | Default general product posting group assigned to new resources. |
| Res. CO Posting Group | Default cost accounting posting group assigned to new resources. |
| Res. Pricing Group | Default pricing group assigned to new resources. |
The Files part on the setup page lists one entry per record type (Employee, Payroll, Project) and defines where the corresponding file is picked up. See Import/Export File Setup for details.
Opens the CSV Field Mapping page, where Business Central table fields are linked to a column position in the CSV import file.
Opens the Import/Export Log page, which lists every import and export run together with its result file.
TODO image: Screenshot of the BRZ Import/Export Setup page showing the Connection section and the Field Mapping and Log actions.
Import/Export File SetupThe Files part on the App Setup page defines, for each record type, where the file to be imported or exported is located. One line exists for every record type (Employee, Payroll, Project).
| Field | Description |
| Record Type | The kind of data the line applies to: Employee, Payroll, or Project. |
| Library Name | The exact name of the SharePoint document library (or folder) the file is picked up from or uploaded to. |
| File Name | The exact file name to look for, for example employees.csv. If left empty, the newest CSV file in the library is used. |
| File Extension | The file extension expected for this record type, for example csv. |
| Delimiter | The character used to separate columns in the CSV file, for example a semicolon. |
Make sure the Library Name, File Name, and Delimiter match the file that BRZ actually delivers, otherwise the import cannot find or parse the file.
CSV Field MappingThe CSV Field Mapping page links Business Central table fields to a column position in the CSV file that BRZ delivers, for example for the employee import. Each line describes one field.
| Field | Description |
| BC Table No. | The number of the Business Central table the field belongs to. |
| BC Table Caption | The caption of the selected table (read-only, shown for readability). |
| Sorting | The position at which the field appears in the CSV file. Each position must be unique per table. |
| BC Field No. | The number of the field within the selected table. Use the Field Selection lookup to find the correct field. |
| BC Field Caption | The caption of the selected field (read-only, shown for readability). |
| CSV File Field | The column header or identifier as it appears in the CSV file. |
If a Sorting position is entered that is already used for the same table, an error is shown so that duplicate mappings are avoided.
Working with the AppThe BRZ Interface app moves data between Business Central and BRZ by exchanging CSV files through a SharePoint document library. The app never connects to BRZ directly; instead it downloads and uploads files from the library that both systems share.
CompaniesThe Companies list stores BRZ-specific company information that is required when project data is exported to BRZ. The value is maintained per company and is reused in the CSV export process.
| Field | Description |
| BRZ-BETRNR | The BRZ business number assigned to the company. It is included in the project export file and helps BRZ identify the correct company context. |
Use this page when a company must be linked to its BRZ identifier before project data is sent to the BRZ environment. The value is stored in the company-specific setup and is not part of the global BRZ import/export setup.
Import/Export LogThe Import/Export Log page lists every import and export run performed by the app, so administrators can verify which files were processed and when, and locate the archived or erroneous file afterwards.
| Field | Description |
| Entry No. | Unique identifier of this log entry. |
| Type | Whether the entry describes an Import or an Export run. |
| Record Type | The kind of data that was processed: Employee, Payroll, or Project. |
| Run Date/Time | Date and time when the run was started. |
| File Name | Name of the CSV file that was processed. |
| Arch File Name | Name under which the processed file was stored in the archive or error folder, typically the original file name with a timestamp added. |
Use this page as the first place to check after running an import or export, to confirm the run completed and to find the file that was used.
Field SelectionThe Field Selection page lists all fields of Business Central tables and is used as a lookup when entering a field in the CSV Field Mapping page. It helps you find the correct field number without needing to know it in advance.
| Field | Description |
| Table No. | The number of the table the field belongs to. |
| Table Name | The internal name of the table the field belongs to. |
| No. | The number of the field within the table. |
| Field Caption | The caption of the field as shown in Business Central. |
| Type | The data type of the field, for example Text, Code, or Decimal. |
| Class | The field class, for example Normal or FlowField. |
Release Notes
