> For the complete documentation index, see [llms.txt](https://hub.equipme.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://hub.equipme.io/dokumentation/automation/connectors/microsoft-business-central.md).

# Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central connector: read and maintain vendors, items, customers and sales invoices from flows – connection, actions, examples.

**Path:** "Automation" → "Workflows" → flow designer → module **"Microsoft Dynamics 365 Business Central"**

The **Business Central connector** connects equipme in [workflows](https://hub.equipme.io/dokumentation/automation/workflows.md) with your ERP Microsoft Dynamics 365 Business Central. Vendors, items and billing data from equipme reach accounting without retyping, and master data from the ERP is available in your flows.

## What for?

* **Reconcile vendors:** create or update suppliers from equipme as vendors in Business Central.
* **Maintain the item master:** keep services and products from equipme as items in the ERP – with price, category and unit.
* **Internal recharging:** create, post and send invoices from equipme as sales invoices to subsidiaries or cost units.
* **Look up master data:** read currencies, payment terms, tax groups or locations from the ERP to set values correctly in flows.

## Prerequisites

* The enabled [automation module](https://hub.equipme.io/dokumentation/automation.md)
* A Business Central environment (online) in your company's Microsoft tenant
* A Microsoft account with a Business Central license and permissions for the affected areas (customers, vendors, items, sales invoices)
* Consent to the Business Central permission in the tenant
* For examples using equipme data, a connection of the [equipme connector](https://hub.equipme.io/dokumentation/automation/connectors/equipme.md) as well

## Setting up the connection

1. In the flow designer, drag a component of the module onto the canvas (e.g. *ListCompanies*).
2. Click **Connect account**.
3. Sign in with the account in the Microsoft sign-in window and accept the requested permissions.
4. The connection appears with the name of the Microsoft account under **"Accounts"**.

{% hint style="info" %}
Business Central, ["Microsoft Entra ID"](https://hub.equipme.io/dokumentation/automation/connectors/microsoft-entra-id.md) and ["Microsoft Intune"](https://hub.equipme.io/dokumentation/automation/connectors/microsoft-intune.md) use the same Microsoft sign-in. All actions run with the permissions of the signed-in account.
{% endhint %}

## Basic concepts

* **Company ID:** Business Central can hold several companies. Every action asks for the **Company ID**. Determine it once with *ListCompanies* and enter it in the components.
* **Selection lists:** fields such as Currency, Payment terms, Payment method, Shipment method, Tax area, Tax group, Category or Base unit of measure load their values from Business Central. Alternatively, enter the code directly (e.g. "Currency code").
* **IDs:** Customer ID, Vendor ID, Item ID and Invoice ID are the internal IDs from Business Central. You get them from *Add…*, *List…* or *Get…* and can store them as metadata in equipme.
* **List actions:** the *List…* actions return the result as one list (without "Output Type").

## Triggers

The connector has **no triggers of its own**. Flows start via other triggers – e.g. a trigger of the [equipme connector](https://hub.equipme.io/dokumentation/automation/connectors/equipme.md) (*New Invoice*, *New Order Request*), a schedule (Scheduler) or a webhook.

## Actions

### Companies

| Component     | Purpose                                                        | Important options |
| ------------- | -------------------------------------------------------------- | ----------------- |
| ListCompanies | List the companies of the environment (returns the Company ID) | –                 |
| GetCompany    | Read a company                                                 | Company ID        |

### Customers

| Component                                    | Purpose                                        | Important options                                                                                                                                                                                                                                 |
| -------------------------------------------- | ---------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| AddCustomer                                  | Create a customer                              | Number, Name, Type ("Company", "Person"), Phone number, Email, Website, Tax liable, Tax area, Tax registration number, Currency, Payment terms, Shipment method, Payment method, Blocked transactions ("None", "Ship", "Invoice", "All"), address |
| UpdateCustomer                               | Change a customer                              | Customer ID and the same fields                                                                                                                                                                                                                   |
| GetCustomer / ListCustomers / DeleteCustomer | Read, list, delete a customer                  | Customer ID                                                                                                                                                                                                                                       |
| ListCustomerFinancialDetails                 | Financial details of a customer (e.g. balance) | Customer ID                                                                                                                                                                                                                                       |
| ListContacts                                 | List contacts                                  | –                                                                                                                                                                                                                                                 |

### Vendors

| Component                              | Purpose                     | Important options                                                                                                                                                                                         |
| -------------------------------------- | --------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| AddVendor                              | Create a vendor             | Number, Name, address, Phone number, Email, Website, Tax registration number, Currency, IRS1099 code, Payment terms, Payment method, Tax liable, Blocked transactions ("None", "Payment", "All"), Balance |
| UpdateVendor                           | Change a vendor             | Vendor ID and the same fields                                                                                                                                                                             |
| GetVendor / ListVendors / DeleteVendor | Read, list, delete a vendor | Vendor ID                                                                                                                                                                                                 |

### Items

| Component                        | Purpose                    | Important options                                                                                                                                                 |
| -------------------------------- | -------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| AddItem                          | Create an item             | Number, Name, Type ("Inventory", "Service", "Non Inventory"), Category, Blocked, GTIN, Unit price, Price includes tax, Unit cost, Tax group, Base unit of measure |
| UpdateItem                       | Change an item             | Item ID and the same fields                                                                                                                                       |
| GetItem / ListItems / DeleteItem | Read, list, delete an item | Item ID                                                                                                                                                           |
| ListItemVariants                 | Variants of an item        | Item ID                                                                                                                                                           |
| ListItemCategories               | Item categories            | –                                                                                                                                                                 |

### Sales invoices

| Component                                                            | Purpose                                             | Important options                                                                                                                                                                                                                                      |
| -------------------------------------------------------------------- | --------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| AddSalesInvoice                                                      | Create a sales invoice (draft)                      | Customer ID, Number, External document number, Invoice date, Due date, Currency, Payment terms, Sales person, Discount amount, Customer purchase order reference, groups "Sell to" (billing address) and "Ship to" (shipping address, shipment method) |
| GetSalesInvoice / ListSalesInvoices / DeleteSalesInvoice             | Read, list, delete an invoice                       | Invoice ID                                                                                                                                                                                                                                             |
| ListSalesInvoiceLines / GetSalesInvoiceLine / DeleteSalesInvoiceLine | Read or delete invoice lines                        | Invoice ID, Line ID                                                                                                                                                                                                                                    |
| PostSalesInvoice                                                     | Post an invoice                                     | Invoice ID                                                                                                                                                                                                                                             |
| SendSalesInvoice                                                     | Send a posted invoice to the customer by email      | Invoice ID                                                                                                                                                                                                                                             |
| PostAndSendSalesInvoice                                              | Post and send in one step                           | Invoice ID                                                                                                                                                                                                                                             |
| CancelSalesInvoice / CancelAndSendSalesInvoice                       | Cancel a posted invoice (and send the cancellation) | Invoice ID                                                                                                                                                                                                                                             |
| MakeCorrectiveCreditMemo                                             | Create a corrective credit memo for an invoice      | Invoice ID                                                                                                                                                                                                                                             |

### Master data (read only)

| Component                    | Returns                 |
| ---------------------------- | ----------------------- |
| ListCurrencies               | Currencies              |
| ListPaymentTerms             | Payment terms           |
| ListPaymentMethods           | Payment methods         |
| ListShipmentMethods          | Shipment methods        |
| ListTaxAreas / ListTaxGroups | Tax areas or tax groups |
| ListUnitsOfMeasure           | Units of measure        |
| ListLocations                | Locations               |

## Examples

### Create new suppliers as vendors

1. **Scheduler** – daily.
2. **Equipme › List Suppliers** – suppliers from equipme, Output Type "One item at a time".
3. **Business Central › ListVendors** – read the vendors and use a **filter** to check whether the supplier already exists (e.g. via name or VAT ID).
4. **Business Central › AddVendor** – only for new suppliers: name, address, email, tax registration number, payment terms.

### Transfer invoice data to the ERP

1. **Equipme › New Invoice** – trigger on a new invoice in equipme.
2. **Equipme › List Billing Items** – read the invoice items to determine amounts per cost center.
3. **Business Central › AddSalesInvoice** – recharging invoice to the customer record of the subsidiary or cost unit, External document number = invoice number from equipme.
4. **Business Central › PostAndSendSalesInvoice** – once the invoice is complete, post and send it.

### Item master from the service catalog

1. **Scheduler** – weekly.
2. **Equipme › List Services** – services from equipme.
3. **Business Central › ListItems** – read and compare existing items.
4. **Business Central › AddItem** or **UpdateItem** – Type "Service" or "Inventory", Unit price, Category.

## Notes and limitations

* With this connector, invoice lines can be read and deleted, but not created. Create sales invoices with lines in Business Central itself, or complete the draft there before posting it with *PostSalesInvoice* or *PostAndSendSalesInvoice*.
* Posting, sending, cancelling and corrective credit memos trigger the corresponding processes in Business Central and cannot be undone via the flow. Test such flows in a sandbox environment or a test company first.
* *DeleteCustomer*, *DeleteVendor* and *DeleteItem* delete permanently. Business Central prevents deletion if entries already exist.
* The selection lists show the values of the company. They stay empty as long as the Company ID is empty.

## Troubleshooting

| Problem                                 | Cause / solution                                                                                                    |
| --------------------------------------- | ------------------------------------------------------------------------------------------------------------------- |
| Selection lists stay empty              | Enter the Company ID first. If the list stays empty, enter the code directly (e.g. "Currency code").                |
| Error "Forbidden" or "Unauthorized"     | The account lacks a license or permission sets in Business Central, or consent in the tenant is missing.            |
| Invoice cannot be posted                | The invoice has no lines, or required information (customer, posting groups) is missing. Check in Business Central. |
| *DeleteCustomer* / *DeleteVendor* fails | Entries already exist. Set "Blocked transactions" to "All" instead.                                                 |
| Wrong company                           | Check the Company ID with *ListCompanies*.                                                                          |

You can find the logs of every run under **"Insights"**. For help, contact [support](https://hub.equipme.io/dokumentation/help/support.md).

## Frequently asked questions

**Can I work with several companies?**

Yes. The connection applies to all companies the account can access. You select the company per component via the Company ID.

**How do I link records between equipme and Business Central?**

Store the Business Central ID (e.g. Vendor ID) as metadata in equipme, or enter the equipme number in the "Number" or "External document number" field in Business Central.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://hub.equipme.io/dokumentation/automation/connectors/microsoft-business-central.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
