Skip to main content

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central connector for managing customers, vendors, items, and the sales order and invoice cycle including posting, through the Business Central API v2.0.

What you can ask​

  • Create a sales order for customer C00010 and ship and invoice it once it is picked
  • List unposted purchase invoices from vendor Fabrikam Inc. and post the approved ones
  • Add a general journal line for a month-end accrual and post the journal

Set up​

Microsoft Dynamics 365 Business Central needs an OAuth application from your organization before anyone can connect. An organization admin completes these steps once.

  1. Go to Organization > Connectors and find Microsoft Dynamics 365 Business Central. Click Enable, and choose which tools to allow.
  2. Create an OAuth application in the Microsoft Dynamics 365 Business Central developer portal.
  3. Add the Redirect URI shown in the connector settings to the application.
  4. Copy the application's Client ID and Client Secret into the connector, then save it.
  5. Each member connects their own account the first time they use it.

⚠️ Warning: Do not enter your Devs.ai or Microsoft Dynamics 365 Business Central login email or password in the OAuth application fields.

To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.

OAuth scopes used by these tools (1)

Grant the scopes for the tools you plan to allow.

  • https://api.businesscentral.dynamics.com/Financials.ReadWrite.All

Tools​

Microsoft Dynamics 365 Business Central offers 82 tools. Admins choose which ones agents can use. See Tool permission groups.

Read (30)​

View and search information without changing it.

ToolWhat it does
discover_entity_metadataInspect one entity set's fields and expandable relations by sampling a real record.
get_accountGet one general ledger account by GUID, including its category, type and net change.
get_customerGet one customer by its GUID, including its '@odata.etag' for safe updates.
get_itemGet one item by its GUID, including its '@odata.etag' for safe updates.
get_purchase_invoiceGet one purchase invoice header by GUID, including its '@odata.etag' for safe updates.
get_purchase_orderGet one purchase order header by GUID, including its '@odata.etag' for safe updates.
get_recordGet one record by GUID from any Business Central entity set, including its '@odata.etag' for safe updates.
get_sales_invoiceGet one sales invoice header by GUID, including its '@odata.etag' for safe updates.
get_sales_orderGet one sales order header by GUID, including its '@odata.etag' for safe updates.
get_vendorGet one vendor by its GUID, including its '@odata.etag' for safe updates.
list_accountsList the chart of accounts for a company.
list_companiesList the companies in the connected Business Central environment.
list_customersList customers in a Business Central company.
list_entitiesList the API entity sets this Business Central environment exposes, such as customers or salesInvoices.
list_itemsList items in a Business Central company.
list_journal_linesList the unposted lines in one journal batch.
list_journalsList general journal batches in a company.
list_payment_journalsList customer or vendor payment journal batches, selected with the party parameter.
list_paymentsList customer or vendor payment lines from one payment journal batch, selected with the party parameter.
list_purchase_invoice_linesList the lines on one purchase invoice.
list_purchase_invoicesList purchase invoices in a Business Central company.
list_purchase_order_linesList the lines on one purchase order.
list_purchase_ordersList purchase orders in a Business Central company.
list_recordsList records from any Business Central entity set, for entities with no dedicated tool such as salesQuotes or dimensions.
list_sales_invoice_linesList the lines on one sales invoice.
list_sales_invoicesList sales invoices in a Business Central company.
list_sales_order_linesList the lines on one sales order.
list_sales_ordersList sales orders in a Business Central company.
list_vendorsList vendors in a Business Central company.
validate_credentialValidate Business Central credentials by listing the companies in the configured environment.

Write (17)​

Create or send data.

ToolWhat it does
create_customerCreate a customer.
create_itemCreate an item in a Business Central company.
create_journal_lineAdd an unposted line to a journal batch.
create_purchase_invoiceCreate a draft purchase invoice header.
create_purchase_invoice_lineAdd a line to a draft purchase invoice.
create_purchase_orderCreate a purchase order header.
create_purchase_order_lineAdd a line to a purchase order.
create_recordCreate a record in any Business Central entity set.
create_sales_invoiceCreate a draft sales invoice header.
create_sales_invoice_lineAdd a line to a draft sales invoice.
create_sales_orderCreate a sales order header.
create_sales_order_lineAdd a line to a sales order.
create_vendorCreate a vendor in a Business Central company.
make_corrective_credit_memoCreate a draft corrective credit memo from a posted sales invoice.
send_sales_credit_memoEmail a posted sales credit memo without posting or cancelling it.
send_sales_invoiceEmail a sales invoice Business Central permits to send; docs do not specify draft versus posted.
send_sales_quoteEmail a sales quote Business Central permits to send; the action docs do not specify a narrower status.

Delete or overwrite (35)​

Remove or replace existing data.

ToolWhat it does
cancel_and_send_sales_credit_memoCancel and email only a posted corrective sales credit memo created by cancel_sales_invoice; standalone memos return 400.
cancel_and_send_sales_invoiceCancel a posted sales invoice and create its corrective credit memo, then email the cancellation.
cancel_purchase_credit_memoCancel a posted corrective purchase credit memo created by cancelling a purchase invoice; a standalone memo returns 400.
cancel_sales_credit_memoCancel only a posted corrective sales credit memo created by cancel_sales_invoice; standalone memos return 400.
cancel_sales_invoiceCancel a posted sales invoice by issuing a corrective credit memo.
delete_customerDelete a customer.
delete_itemDelete an item.
delete_journal_lineDelete an unposted journal line.
delete_purchase_invoiceDelete a draft purchase invoice and its lines.
delete_purchase_orderDelete a purchase order and its lines.
delete_recordDelete a record from any Business Central entity set.
delete_sales_invoiceDelete a draft sales invoice and its lines.
delete_sales_orderDelete a sales order and its lines.
delete_vendorDelete a vendor.
make_invoice_from_sales_quoteConvert an open sales quote that Business Central permits to convert into a sales invoice; the action page does not specify a narrower status.
make_order_from_sales_quoteConvert an open sales quote that Business Central permits to convert into a sales order; the action page does not specify a narrower status.
post_and_send_sales_credit_memoPost and email a draft sales credit memo.
post_and_send_sales_invoicePost and email a draft sales invoice.
post_journalPost every line in a journal batch to the general ledger at once.
post_purchase_credit_memoPost a draft purchase credit memo to finalize the vendor credit.
post_purchase_invoicePost a draft purchase invoice to the general ledger.
post_sales_credit_memoPost a draft sales credit memo to finalize the customer credit.
post_sales_invoicePost a draft sales invoice to the general ledger.
receive_and_invoice_purchase_orderReceive and invoice a purchase order, creating posted receipt and invoice documents.
restart_job_queue_entryRestart a failed job queue entry in a restartable state (typically Error); docs do not specify the exact status.
ship_and_invoice_sales_orderShip and invoice a sales order, creating posted shipment and invoice documents in the ledger.
update_customerUpdate fields on an existing customer.
update_itemUpdate fields on an existing item.
update_journal_lineUpdate an unposted journal line.
update_purchase_invoiceUpdate header fields on a draft purchase invoice.
update_purchase_orderUpdate header fields on a purchase order.
update_recordUpdate a record in any Business Central entity set.
update_sales_invoiceUpdate header fields on a draft sales invoice.
update_sales_orderUpdate header fields on a sales order.
update_vendorUpdate fields on an existing vendor.
⌘J