Skip to main content
Calxa and Business Central

Best practices and things to note for a smooth integration with Business Central

Shem Bogusz avatar
Written by Shem Bogusz
Updated over 3 weeks ago

Calxa can be used with a number of different accounting packages and integrates with these packages in different ways. Aside from your initial company setup and subsequent syncs, Calxa behaves in much the same way regardless of the chosen accounting package. There are, however, some important differences to be aware of.

This help note will outline the things you should know about using Calxa with Microsoft Dynamics 365 Business Central and discuss best practices for a smooth integration.


Supported Versions

  • Dynamics 365 Business Central (online only)

  • Wiise ERP

Integration (connection) to Business Central

Calxa connects to Business Central using Service-to-Service (S2S) Authentication. This involves registering an application in your Microsoft Entra tenant and granting access for that application in Business Central. A custom API extension is also imported to your Business Central environment to expand on the standard API endpoints and support the syncing of data to Calxa.

Once configured this integration does not require any user interaction for Calxa to sync data from Business Central. The secrets used as part of the authentication flow have a configurable expiry date and therefore, periodic renewal is required based on the expiry date chosen. The connection may also be revoked at any time from within your Microsoft Entra tenant.

Calxa Subscription

A Calxa Enterprise subscription is required to connect to Business Central. See Calxa Pricing for more details.

User Access Rights Required

A user with at least the Cloud Application Administrator role is required to register the application in your Microsoft Entra tenant.

A user with the EXTEN. MGT. - ADMIN permission set is required to configure the integration in your Business Central account.

The Calxa connection will require access to the following Objects:

  • Accounts (Chart of Accounts)

  • Budget Entries

  • Companies & Company Information

  • Dimension & Dimension Values

  • General Ledger Entries

  • General Ledger Setup

  • VAT Product Posting Groups

Companies

Each Business Central company is imported to Calxa as a separate Organisation. One or more Organisation Groups can be configured in Calxa to represent the company structure.

Chart of Accounts

Calxa will import and sync the full Chart of Accounts structure including parent child relationships as seen in the Chart of Accounts menu in Business Central.

Calxa references each account on an internal key rather than the 'No.' or 'Name' field. This means you can safely renumber or rename accounts in Business Central and Calxa will still recognise it as the same account.


If you mark accounts as Blocked in Business Central, then Calxa will mark these accounts as inactive. Inactive accounts are filterable from many views in Calxa, however all actual data is still imported and synced against inactive accounts and thus will be included in reports when data is present.

Business Units

Business units is the generic term in Calxa representing the different ways you can segment data. Calxa configures 2 business unit categories as per the Dimensions configuration in the Business Central General Ledger Setup. From this setup the following 2 dimensions will be imported.

  • Global Dimension 1 Code

  • Global Dimension 2 Code

Business unit names are configurable via the Business Unit Configuration menu.

Calxa references each Business Unit on a key rather than the number or name. This means you can safely renumber or rename these in Business Central and Calxa will recognise them as the same item.

Actuals

General Ledger Entries are summarised and stored in Calxa as monthly amounts on each Organisation and Business Unit Category.

Transaction Detail

Transaction detail is not saved to Calxa and therefore some transaction-based reports such as the Account Transaction and Aged Receivables/Payables reports are not supported for Business Central organisations at this stage.

Budgets

You can select a single budget to be synced from Business Central to Calxa at both the Organisation and Business Unit level. This will create a Read Only budget in Calxa. See Use your Accounting system Budget in Calxa for more details.

Did this answer your question?