Pick up an activated Salesforce order
Every 2 minutes the workflow checks Salesforce for an activated order and pulls the full order, including shipping details, line items and product details.
Checks each activated Salesforce order for a valid item, customer and enough stock in Dynamics 365 Business Central before creating the sales order
Apps used in this template
About this template
Orders that reach the ERP with an unknown item, an unmatched customer or too little stock lead to manual corrections in finance. This template checks Salesforce every 2 minutes for an activated order, confirms the item exists, matches or creates the customer by name and phone number, checks stock in Dynamics 365 Business Central, and creates the sales order only when the checks pass.
Key benefits
Inside the flow
Every 2 minutes the workflow picks up an activated Salesforce order and checks the item, customer and stock in Dynamics 365 Business Central. If the item or stock check fails it emails the team through Microsoft Outlook and stops; otherwise it creates the sales order.
Every 2 minutes the workflow checks Salesforce for an activated order and pulls the full order, including shipping details, line items and product details.
Dynamics 365 Business Central is searched for the product by name. If it is not found, the team gets an email and the order stops.
The Salesforce account is searched in Dynamics 365 Business Central by name and confirmed by phone number. If no match is confirmed, the team is notified and a new customer is created from the Salesforce account details.
Once item and customer are resolved, current inventory is compared with the ordered quantity. If stock falls short, an insufficient stock email goes to the team and no order is created.
A sales order is created in Dynamics 365 Business Central with the Salesforce order number, order and posting dates, customer, ship to address, product, quantity and unit price. The requested delivery date is set to the processing day.
What this sales order automation changes for sales and finance teams
01
Salesforce order data is checked for a valid item, customer and stock before it reaches Dynamics 365 Business Central, so finance teams spend less time correcting orders after the fact.
01
Salesforce order data is checked for a valid item, customer and stock before it reaches Dynamics 365 Business Central, so finance teams spend less time correcting orders after the fact.
Keep exploring
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Every trigger and action this template uses is available in the appse ai builder, so the same flow can be rebuilt with your own routing, thresholds and destinations.
Questions & answers
Everything you need to know about this template before you deploy it.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.
Start free — no credit card, no setup calls required. Use this template as-is or customize every step inside the appse ai no-code builder and go live today.