> 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/pro/automation/connectors/microsoft-business-central.md).

# Microsoft Dynamics 365 Business Central

Business Central connector for providers: transfer customers from Pro as customers, products as items and billing as sales invoices to the ERP.

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

With the **Business Central connector**, you connect Equipme Pro in [workflows](https://hub.equipme.io/pro/automation/workflows.md) with your ERP Microsoft Dynamics 365 Business Central. Combined with the ["Equipme Pro"](https://hub.equipme.io/pro/automation/connectors/equipme-pro.md) module, you transfer customers as customer records, product master data as items and billing as sales invoices – and keep the identifiers of both systems linked via metadata.

## What for?

* **Customers as customer records:** new customer in Pro → create the customer in Business Central, store the customer number as metadata on the customer.
* **Billing customers:** new invoice in Pro → create a sales invoice in Business Central, post it and send it to the customer.
* **Product master data:** keep products and purchase prices from Pro as items in the ERP.
* **Suppliers and distributors:** create suppliers as vendors and maintain payment terms.
* **Check payment status:** read a customer's financial details before you grant an order authorization in Pro.

## Prerequisites

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

## 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/pro/automation/connectors/microsoft-entra-id.md) and ["Microsoft Intune"](https://hub.equipme.io/pro/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 Pro.
* **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 Pro"](https://hub.equipme.io/pro/automation/connectors/equipme-pro.md) module (*New Customer*, *New Sales Order*, *New Invoice*, *New Authorization 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 customers in Business Central

1. **Equipme Pro › New Customer** – trigger on a new customer.
2. **Business Central › AddCustomer** – Number = customer number from Pro, Name, Type "Company", Email, address from the billing address, Payment terms, Currency.
3. **Equipme Pro › Update Customer Metadata** – store the Customer ID from Business Central on the customer.

### Transfer invoices from Pro as sales invoices

1. **Equipme Pro › New Invoice** – trigger on a new invoice.
2. **Equipme Pro › Get Customer Metadata** – read the customer's stored Business Central Customer ID.
3. **Equipme Pro › List Billing Items** – items of the invoice.
4. **Business Central › AddSalesInvoice** – Customer ID, External document number = invoice number from Pro, Invoice date, Due date.
5. **Business Central › PostAndSendSalesInvoice** – once the invoice is complete, post it and send it to the customer.

### Order authorization after a payment check

1. **Equipme Pro › New Authorization Request** – a customer requests order authorization.
2. **Equipme Pro › Get Customer Metadata** – read the Business Central Customer ID.
3. **Business Central › ListCustomerFinancialDetails** – balance and overdue amounts of the customer.
4. **Filter** – no overdue amounts?
5. **Equipme Pro › Update Authorization Request** – "Approved", otherwise "In process" with a note for the account manager.

## 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/pro/help/support.md).

## Frequently asked questions

**Do I need Business Central in my customers' tenants?**

No. The connector works with **your** Business Central. Your customers are customer records there.

**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 customers in Pro with customers in Business Central?**

Store the Business Central Customer ID as metadata on the customer (*Update Customer Metadata*), or use the customer number from Pro as "Number" 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/pro/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.
