Connectors

/

Microsoft Dynamics 365 Business Central

/

Create a Dynamics 365 Business Central sales order from a Dynamics 365 Sales order
Write
Cross-Connector

Send won Dynamics 365 Sales orders to Business Central once

For operations teams who want won orders in Business Central at the price sold, without retyping, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Create a Dynamics 365 Business Central sales order from a Dynamics 365 Sales order
Create the Business Central sales order for the Contoso Q4 Rollout order from Dynamics 365 Sales.
Contoso Q4 Rollout is not in Business Central yet; customer C10420 matched. - Lines: 4 of 4 products mapped to items - Prices: sold prices kept, 2 differ from the item price - Total: 18,600.00, same as Dynamics 365 Shall I create the order?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
microsoft-dynamics-365-sales-get-salesorders
microsoft-dynamics-365-sales-get-salesorderdetails
microsoft-dynamics-365-sales-get-accounts

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Won orders get keyed twice before they can ship

Orders won in Dynamics 365 Sales have to be keyed again into Business Central. Finding the customer, matching each product to an item and copying prices is slow, and a missed check means a duplicate or wrongly priced order.

Without PopdockAI

  • Retype the order from Dynamics 365 Sales
  • Match each product to an item by hand
  • Copy quantities and prices line by line
  • Enter the same order twice by mistake

With PopdockAI

  • Business Central is checked for the order id before anything else
  • The customer is matched by account number, then name
  • Each product is mapped to an item, with unmapped lines shown
  • After you confirm, it is created at the sold price and totaled

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt

**Objective:** Create a sales order in Business Central company `{company}` (default: the connector's default company when blank) that matches the Dynamics 365 Sales order `{order-name}`, only after the user confirms the mapping.

**Step 1: Read the order in Dynamics 365 Sales**

Call `dynamics-365-sales-get-salesorders` with name set to `{order-name}` (then order-id, then name.contains). Stop and list matches if more than one. Keep order-id, name, customer, total-amount and requested-delivery-date. Call `dynamics-365-sales-get-salesorderdetails` with order set to the order name and keep each line's product-number, product-name, quantity, price-per-unit and manual-discount.

**Step 2: Make sure it is not already in Business Central**

Call `business-central-get-sales-transaction` with external-document-number set to the Dynamics 365 order-id. If a document comes back, report its document-number and status and stop. Do not create a duplicate.

**Step 3: Map the customer and items in Business Central**

Call `dynamics-365-sales-get-accounts` with account-name set to the order's customer and keep account-number. Call `business-central-get-customer` with customer-number set to that account-number, falling back to name.contains on the customer name. If no customer matches, stop and suggest running backfill-bc-customers-from-d365 first. If the customer is blocked, stop and say so.

For each line call `business-central-get-item` with item-number set to the product-number. Lines whose product has no Business Central item go on an unmapped list.

**Step 4: Show the plan and ask**

Show the Business Central customer, the external document number (the Dynamics 365 order-id), the requested delivery date, and a table of lines: item-number, description, quantity, unit-price (the Dynamics 365 price-per-unit) and the Business Central unit-price for comparison. List unmapped lines separately; they will not be created. Ask the user to confirm. Do not continue without an explicit yes.

**Step 5: Create in Business Central (only after confirmation)**

Call `business-central-create-sales-order` once with customer-number and bill-to-customer-number set to the Business Central customer-number, external-document-number set to the Dynamics 365 order-id, requested-delivery-date, and company `{company}` when given. Keep the returned number and id. Then call `business-central-create-sales-order-line` once per mapped line with document-number set to that number, line-type Item, number-on-line set to the item-number, quantity and unit-price.

**Step 6: Confirm**

Call `business-central-get-sales-transaction-line` with document-number set to the new number and report the created order number, each line created, any line that failed, and the order total against the Dynamics 365 total.

**Rules & Guidelines:**

* Tools named dynamics-365-sales-* are on the dynamics-365-sales server; tools named business-central-* are on the business-central server.
* The only write tools allowed are `business-central-create-sales-order` (once) and `business-central-create-sales-order-line` (once per line), and only after confirmation. Do NOT call any dynamics-365-sales create or update tool, and do NOT update or delete anything in Business Central.
* If the header create fails, stop and do not create lines.

**Validation:**

* If a line create fails, continue with the rest and list the failures at the end.
* If the Dynamics 365 and Business Central prices differ, keep the Dynamics 365 price (that is what was sold) and flag the difference in the plan.

Who it's for

One answer, three teams that use it

Order processing

Move won orders without retyping

Bring a won order into Business Central with mapped lines and prices, ready to ship.

Create the Business Central order for the Fabrikam Spring Restock order in Dynamics 365 Sales.

Sales operations

Keep sold prices intact

Lines keep the price that was sold, with both prices shown so you see any difference before confirming.

Copy Dynamics 365 Sales order ORD-1077 for Northwind Traders into Business Central and show me any price differences.

Finance operations

Stop duplicate orders at the source

An order already carrying the Sales order id stops the create, so the same deal is never booked twice.

Has the Contoso Q4 Rollout order already been entered in Business Central? If not, create it.

How it works

What PopdockAI does when you ask

You name the Dynamics 365 Sales order and your AI assistant checks for a duplicate, maps the customer and items, and shows you the result. Nothing is created until you confirm.

01

Ask

You name the Dynamics 365 Sales order.

Your AI tool

02

Check

It stops if Business Central already has the order, then maps customer and items.

microsoft-dynamics-365-sales-get-salesorders
microsoft-dynamics-365-sales-get-salesorderdetails
microsoft-dynamics-365-sales-get-accounts

03

Confirm

You see mapped lines with both prices and any unmapped lines.

No items found.

04

Create

It creates the order at the price sold and totals it against Dynamics 365.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics 365 Business Central and one secure connection to your AI tool. No code, no exports.

get-data

microsoft-dynamics-365-sales-get-salesorders

Returns Dynamics 365 Sales orders. Filter by name, total amount, created date, customer, owner, order ID and status reason, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-salesorderdetails

Returns Dynamics 365 Sales order products. Filter by product number, requested delivery date, extended amount, product name, quantity and order, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-accounts

Returns Dynamics 365 Sales accounts. Filter by city, annual revenue, status, industry, account number, email, account name and state, and cap how many records come back.
Read only.Nothing in Microsoft Dynamics 365 Business Central Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Won orders in Business Central once, at the price sold

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation