Business Central + FDT / Smart - File based
Everything you need to connect Business Central and FDT / Smart - File based: how to connect, which data moves, which settings there are and what to do when something goes wrong.
- 2 data flows
1. Getting started
Prepare both systems first, then connect them in Junipeer.
- about 3 minutes
Prepare Business Central
- Open the Business Central connector in Junipeer
- Click Connect
- Sign in with the right Microsoft account
- Review and approve the OAuth consent
- Confirm environment or company if needed
- Return to Junipeer and verify the connection
Prepare FDT / Smart - File based
Have your login details for this system ready. The full instructions show what Junipeer needs.
Full instructionsConnect and test
Enter the details in Junipeer, switch on the flows you need and test with one order before you go live.
Getting started with Junipeer
2. How the data flows
What Junipeer can move between the two systems. The arrow shows which way the data goes.
Junipeer - Orders
- Products
3. Settings
The settings you see in Junipeer, in plain words. Open one to read more. The key is the technical name.
You don't need to read them all
In Junipeer every setting has a ? that opens the same explanation next to the form, right when you need it. With the Junipeer MCP your AI assistant can also propose the settings from your own data.
How the Junipeer MCP worksSettings for Business Central (47)
| Setting | What it controls | Key |
|---|---|---|
| Add return fee as a Return Line | Decide whether the return fee should be added as its own line on returns in Business Central. | bc_add_return_fee_row |
| Add shipping fee as an Order Line | Decide whether the shipping fee should be added as its own line on orders in Business Central. | bc_add_shipping_on_order_rows |
| Add shipping fee as an Order/Return Line | Decide whether the shipping fee should be added as its own line on orders and returns in Business Central. | bc_order_add_shipping_fee_row |
| Company ID | Enter the Company ID of the company in Business Central that Junipeer should connect to. | bc_company_id |
| Create missing articles in Business Central | Decide what happens when an order contains an article that doesn't exist in Business Central. | bc_create_missing_order_products |
| Create payout after order invoiced in Business Central | Decide whether a payout transaction should be created in Business Central when an order is invoiced there. | bc_create_payout_on_order_invoiced |
| Customer number by currency | Use a different Business Central customer number depending on the order's currency. | bc_houdini_customer_number_by_currency |
| Default General Product Posting Group | Choose the general product posting group given to articles that Junipeer creates in Business Central. | bc_default_general_product_posting_group_id |
Show all 47 settings
| Setting | What it controls | Key |
|---|---|---|
| Default Payment Journal for Payout Transactions in Business Central | Choose the payment journal in Business Central where payout transactions are created. | bc_default_payment_journal_id |
| Default Payment Method in Business Central | Choose the payment method Junipeer uses on orders in Business Central by default. | bc_default_payment_method |
| Default Shipping Item number in Business Central | Enter the Business Central item number used for the shipping fee line on orders. | bc_default_shipment_article_no |
| Default Terms of Payment in Business Central | Choose the terms of payment Junipeer uses on orders in Business Central by default. | bc_default_terms_of_payment |
| Default customer number | Enter the Business Central customer number used on orders when no customer number is set for the order's currency in Customer number by currency . | bc_houdini_default_customer_number |
| Default order type | Choose the order type set on orders when no order type is set for the order's currency in Order type by currency . | bc_houdini_default_order_type |
| Default payment method | Choose the Business Central payment method used on orders when no payment method mapping matches in Map payment methods . | bc_houdini_default_payment_method |
| Environment | Choose which Business Central environment Junipeer connects to. | bc_env |
| Exclude Orders created before this date | Orders created before this date are not synced. | stdintegration_filter_business_central_order_created_date |
| Include parent item when using variants | Decide whether the main (parent) item should be included together with its variants. | bc_variants_include_parent_item |
| Map Payment Methods | Connect the payment methods in your webshop with the payment methods in Business Central. | bc_payment_methods |
| Map Shipping methods | Connect the shipping methods in your webshop with the shipping methods in Business Central. | bc_shipping_methods |
| Map payment methods | Connect the payment methods in your webshop with the payment methods in Business Central. | bc_houdini_payment_methods |
| Match shipping methods by name | Use this if your shipping methods have the same names in both systems, so you don't have to map them one by one. | bc_match_shipping_methods_by_name |
| OData Sales Order Updates | Set specific fields on the sales order in Business Central to a fixed value when the order is updated. | bc_update_order_odata_fields |
| OData Sales Order Updates | Set specific fields on the sales order in Business Central to a fixed value when the order is updated. | bc_update_order_odata_fields_step_2 |
| Order Filters | Only sync orders from Business Central that have specific values in specific fields. | bc_retrievable_order_filters |
| Order create API profile | Choose which way Junipeer creates orders in Business Central. | bc_order_store_profile |
| Order type by currency | Use a different order type depending on the order's currency. | bc_houdini_order_type_by_currency |
| Order/Shipment retrieve API profile | Choose which way Junipeer reads orders and shipments from Business Central. | bc_order_retrieve_profile |
| Payment Method to Update in Business Central | Choose the payment method that is set on the sales order and the customer in Business Central when the order is updated. | bc_update_selected_payment_method_step_2 |
| Release order after create | Decide whether orders should be released in Business Central right after Junipeer creates them. | bc_houdini_release_order |
| Return Fee Item number in Business Central | Enter the Business Central item number used for the return fee line. | bc_default_return_fee_article_no |
| Shipping Agent Code | Enter the shipping agent code to use. | shipping_agent_code |
| Shipping Fee Item number in Business Central | Enter the Business Central item number used for the shipping fee line. | bc_default_shipping_fee_article_no |
| Shipping Service Code | Enter the shipping service code to use. | shipping_service_code |
| Shipping fee map | Use different Business Central items for the shipping fee depending on the shipping method the customer chose. | bc_shipment_article_no |
| Stock warehouse filter | Enter a warehouse (location code) to only load stock for that warehouse. | bc_stock_location |
| Sync only 'person' customers | Decide whether only private customers (persons) should be synced, and company customers skipped. | bc_customers_sync_person_only |
| Terms of Payment to Update in Business Central | Choose the terms of payment that orders are updated to in Business Central. | bc_update_selected_terms_of_payment |
| Terms of Payment to Update in Business Central | Choose the terms of payment that orders are updated to in Business Central. | bc_update_selected_terms_of_payment_step_2 |
| Update Business Central Customers | Decide whether customers that already exist in Business Central should be updated when customers are imported from your webshop. | bc_update_customers |
| Update Terms of Payment in Business Central | Decide whether the terms of payment on orders should be updated in Business Central. | bc_update_terms_of_payment_step_2 |
| Update Terms of Payment in Business Central | Decide whether the terms of payment on orders should be updated in Business Central. | bc_update_terms_of_payment |
| Update customer information in Business Central | Decide whether the customer in Business Central should be updated each time one of their orders is sent to Business Central. | bc_update_customer_when_order_is_synced |
| Use Multi Stock | Decide whether stock should be synced per warehouse or as one total per item. | bc_use_multistock |
| Use variants | Decide whether variants should be included when items are read from Business Central. | bc_use_variants |
| VAT included in order rows | Tell Junipeer whether the prices on order rows are sent to Business Central including or excluding VAT. | bc_vat_included_order_rows_price |
| Variant SKU delimiter | Enter the character placed between the item number and the variant code when Junipeer builds the SKU for a variant. | bc_variant_sku_delimiter |
Settings for FDT / Smart - File based (7)
| Setting | What it controls | Key |
|---|---|---|
| FTP Host | Enter the host of the FTP server, for example example.com or an IP address such as 200.121.211.131 . | fdt_ftp_host |
| Host Key | Enter the server's public SSH key (for example ssh-ed25519 AAAA... | fdt_ftp_host_key |
| Map Payment methods | Connect the payment methods in your webshop with the payment method sent on the order. | fdt_map_payment_methods |
| Password | Enter the password used to log in to the FTP/SFTP server. | fdt_ftp_password |
| Port | Enter the SFTP port. Leave empty to use port 22 . | fdt_ftp_port |
| Shipping Article Number | Enter the article number that the shipping row on an order is sent as. | fdt_shipping_article_nr |
| Username | Enter the username used to log in to the FTP/SFTP server. | fdt_ftp_username |
4. Troubleshooting
Choose what you see. Each case shows the cause and the solution.
MediumFor error codes and patterns, see the Error Codes guide. Common Business Central
Cause
For error codes and patterns, see the Error Codes guide. Common Business Central-related issues include:
Solution
Refer to the platform setup guide for resolution steps.
5. More guides
Did this page help you?