SAP + FDT / Smart - File based
Everything you need to connect SAP and FDT / Smart - File based: how to connect, which data moves, which settings there are and what to do when something goes wrong.
- 1 data flow
1. Getting started
Prepare both systems first, then connect them in Junipeer.
- Varies by project
Prepare SAP
- Confirm the exact product and environment
- Let Junipeer confirm the auth pattern
- Create or receive the technical credentials
- Add the credentials in Junipeer
- Verify in a non-production environment first
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
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 SAP (21)
| Setting | What it controls | Key |
|---|---|---|
| API URL | Enter the base address of the SAP Business One API. | sap_b1_api_base_url |
| Company DB | Enter the name of the company database in SAP Business One that Junipeer should connect to. | sap_b1_ba_company_db |
| Confirm order? | Decide whether orders should be marked as confirmed when they are sent to SAP Business One. | sap_b1_order_confirmed |
| Default SAP pricelist [Export Items] | Choose the SAP Business One price list whose price is sent along with each article. | sap_b1_default_pricelist |
| Default SAP warehouse [Export Stock] | Choose the SAP Business One warehouse to use as the default when stock is exported. | sap_b1_default_warehouse |
| Default Terms of Payment in SAP | Choose the SAP Business One terms of payment to use when no payment method matches in Map Terms of Payment . | sap_b1_order_default_terms_of_payment |
| Exclude Orders created before this date | Choose a date to stop older orders from being synced. | stdintegration_filter_sap_order_created_date |
| Format for fromDate parameter in SQL query for updated stock items | Enter the date format for the fromDate parameter in the query chosen in Use SQL Query for updated stock items . | sap_b1_query_for_updated_stock_items_from_date_format |
Show all 21 settings
| Setting | What it controls | Key |
|---|---|---|
| Format for fromTime parameter in SQL query for updated stock items | Enter the time format for the fromTime parameter in the query chosen in Use SQL Query for updated stock items . | sap_b1_query_for_updated_stock_items_from_time_format |
| How many days for setting due date (default: 10)? | Enter the number of days to add to the order date to get the due date on orders in SAP Business One. | sap_b1_order_due_days |
| Map Shipping methods | Connect the shipping methods in your webshop with the shipping types in SAP Business One. | sap_b1_order_map_shipping_methods |
| Map Terms of Payment | Connect the payment methods in your webshop with the terms of payment in SAP Business One. | sap_b1_order_map_terms_of_payments |
| Map Vat percent with VatGroups | Connect the VAT percentages on orders from your webshop with the VAT groups in SAP Business One. | sap_b1_order_map_vat |
| Multiple warehouses on SAP [Export Stock]? | Decide how stock from your SAP Business One warehouses is exported. | sap_b1_multiple_warehouses |
| Only load articles which have this property set (e.g. Properties1) | Load only the SAP Business One articles (items) that have a certain property set. | sap_b1_article_filter |
| Only load customers which have this property set (e.g. U_LIFMagId) | Load only the SAP Business One customers that have a certain property set. | sap_b1_customer_filter |
| Password | Enter the password for the user in Username . | sap_b1_ba_password |
| Shipping fee Item Code | Enter the item code to use when the shipping fee is added as an order row on orders in SAP Business One. | sap_b1_order_default_shipping_article_nr |
| Use SQL Query for updated stock items | Choose a custom SQL query in SAP Business One that finds the items whose stock has changed. | sap_b1_query_for_updated_stock_items |
| Username | Enter the username Junipeer uses to log in to SAP Business One. | sap_b1_ba_username |
| What prefix is used for customer CardCode? | Enter the prefix for the customer number (CardCode) when Junipeer creates a new customer in SAP Business One. | sap_b1_order_card_code_prefix |
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 |
Did this page help you?