Salesforce ↔ SAP Business One (Bidirectional)
Apps Required
Detects when new quotations are created in Salesforce and fetches quotation details including line items, account, and address information.
Searches SAP Business One Items using the Salesforce Product2Id (U_WebID) to find the matching item code for the quoted product.
A Merge node combines the SAP item search results with the original Salesforce quotation data using an inner join to create a unified dataset.
Filters quotations to process only those with a status of 'In Review', ensuring only review-ready quotes are synced to SAP.
Creates a new quotation in SAP Business One with mapped document lines, item codes, quantities, unit prices, and billing/shipping address details from Salesforce.
A scheduled trigger runs every hour to check Salesforce for quotations that have been approved and are ready for order conversion.
Retrieves all quotations from Salesforce with Status='Approved' using a filtered query to identify quotes ready for conversion to sales orders.
Fetches the detailed quote line items for each approved quotation using the quote ID.
Searches SAP Business One Items using the Product2Id from the quote line to find the matching SAP item code for order creation.
Two Merge nodes combine the SAP item search results with quote line data (inner join) and then with the original Salesforce quote data (outer join) to assemble a complete order dataset.
Filters the merged data to confirm the quotation status is still 'Approved' before proceeding with sales order creation.
Creates a new sales order in SAP Business One with mapped item codes, quantities, unit prices, and complete billing/shipping address details from the approved Salesforce quote.
Checks if the sales order was successfully created in SAP by verifying the existence of a DocEntry in the response.
Updates the original Salesforce quotation status to 'Accepted' after the sales order has been successfully created in SAP Business One.
| Modules | Trigger |
|---|---|
| Contacts updated | Trigger when an existing Contact record is updated in Salesforce. |
| New quotations created | Trigger when a new Quotation record is created in Salesforce. |
| Accounts updated | Trigger when an existing Account record is updated in Salesforce. |
| New leads created | Trigger when a new lead record is created in Salesforce. |
| New orders created | Trigger when a new order record is created in Salesforce. |
| New contact created | Trigger when a new Contact record is created in Salesforce. |
| New opportunities created | Trigger when a new Opportunity record is created in Salesforce. |
| New account created | Trigger when a new Account record is created in Salesforce. |
| New Case Created | Trigger that executes when a new case is created in Salesforce. |
Automates the entire lifecycle from Salesforce quotation creation to SAP sales order generation, eliminating manual data entry at every stage.
1
2
Keeps Salesforce quote statuses in sync with SAP order creation, automatically updating quotes to 'Accepted' once orders are confirmed.
Ensures SAP item codes, billing addresses, and shipping addresses are correctly mapped from Salesforce, reducing order errors.
3
4
Only approved Salesforce quotations are converted to SAP sales orders, maintaining proper business approval workflows.
Quotations are synced every 3 minutes and approved quotes are converted to orders hourly, significantly speeding up the quote-to-order cycle.
5
1
Automates the entire lifecycle from Salesforce quotation creation to SAP sales order generation, eliminating manual data entry at every stage.
2
Keeps Salesforce quote statuses in sync with SAP order creation, automatically updating quotes to 'Accepted' once orders are confirmed.
3
Ensures SAP item codes, billing addresses, and shipping addresses are correctly mapped from Salesforce, reducing order errors.
4
Only approved Salesforce quotations are converted to SAP sales orders, maintaining proper business approval workflows.
5
Quotations are synced every 3 minutes and approved quotes are converted to orders hourly, significantly speeding up the quote-to-order cycle.
Common questions about this automation template.
Automate smarter with an AI-native platform designed for the way mid-market businesses really work.