All Collections
Documentation
Onboarding and setup
Connector for Salesbuildr with Dynamics 365
Connector for Salesbuildr with Dynamics 365

Learn how Salesbuildr integrates with Microsoft Dynamics Sales and Business Central

Updated over a week ago

SalesBuildr integrates with Microsoft Dynamics 365 Sales and Microsoft Dynamics 365 Business Central. Here's an overview of what this powerful collaboration brings to your sales management journey, marrying CRM, sales, business administration, and supply channels:

  1. Unified CRM Management: Dynamics 365 Sales is the core for handling your customer, contact, and opportunity data. This data integrates seamlessly with Salesbuildr, providing your sales team with a unified view of customer information and sales opportunities.

  2. Streamlined Product and Service Management: Our integration enables you to manage your product and service catalog in Salesbuildr, with the ability to push this data directly to Business Central upon customer approval of the sales document. This ensures consistent data across platforms and simplifies inventory management.

  3. Smart Catalog for Comprehensive Offerings: With our smart catalog, you can efficiently bundle hardware, software, services, and labour as add-ons or package them into understandable bundles. This allows your customers to enjoy a comprehensive and personalised purchasing experience.

  4. Interactive Sales Document Creation: Our smart template library enables you to create impressive and interactive sales documents that can be easily converted into precise quotes within Salesbuildr and transferred to Business Central for order processing. Also, the buyer's experience is enhanced with easy online approval, accelerating your sales cycle.

  5. Real-Time Inventory Management and Procurement: We've integrated inventory updates from Business Central into Salesbuildr. These instant updates ensure your sales team always has accurate product availability information to share with your customers.

  6. Extensive Distributor Integration: We've established connections with the major IT distributors across the Netherlands, Belgium, the United Kingdom, and Ireland. These integrations provide daily and hourly updates on product availability and pricing, keeping you competitive by offering the best, most accurate service to your customers.

Our latest integration symbolizes a significant stride in our mission: to empower Managed Technology Providers with the tools to provide superior sales experiences. By bridging Dynamics 365 Sales, Business Central, and our distributor partners across Europe, we're facilitating informed business decisions, streamlining sales processes, and boosting profitability.

How does the integration between Salesbuildr and Dynamics 365 Sales work?

Here's how Salesbuildr integrates with Microsoft Dynamics 365 Sales and Business Central:

Overview

Salesbuildr is a tool that integrates with Microsoft Dynamics 365 Sales. It is used for managing and building quotes. The tables below display what fields are updated per entity.

Opportunities

Salesbuildr Information

Synced to Dynamics 365 as

Description

Opportunity Title

Opportunity Name

The name of the sales opportunity.

Estimated Close Date

Estimated Close Date

The expected date to close the opportunity.

Company Information

Account Reference

Links to the company details in Dynamics 365.

Contact Information

Contact Reference

Links to the contact details in Dynamics 365.

Owner Information

Owner Reference

Links to the user who owns the opportunity in Dynamics 365.

Opportunity ID

Salesbuildr Opportunity ID

The unique identifier of the opportunity from Salesbuildr.

Sync Flag

Sync With Salesbuildr Flag

Indicates if the opportunity data should be synced.

Quotes

Salesbuildr Information

Synced to Dynamics 365 as

Description

Quote Title

Quote Name

The name of the quote.

Quote Number

Quote Number

The unique number assigned to the quote.

Associated Opportunity

Opportunity Reference

Links to the related sales opportunity in Dynamics 365.

Company Information

Account Reference

Links to the company details in Dynamics 365.

Owner Information

Owner Reference

Links to the user who owns the quote in Dynamics 365.

Quote ID

Salesbuildr Quote ID

The unique identifier of the quote from Salesbuildr.

Expiry Date

Effective To Date

The date when the quote expires.

Solution Details

Custom Fields

Information about the solution being quoted.

Shipping Costs

Shipping Price & Cost

Costs related to shipping.

Companies

Salesbuildr Information

Synced to Dynamics 365 as

Description

Company Name

Account Name

The name of the company.

-

Account Number

Not provided in Salesbuildr.

Company Type

Account Type

Type of the company (e.g., customer).

Website

Website

The website of the company.

Telephone

Phone

The telephone number of the company.

Address

Address Fields

Includes street, city, zip, state, and country information.

-

Payment Terms

Not provided in Salesbuildr.

Account Manager ID

Account Manager Reference

Reference to the account manager in Dynamics 365.

Parent Company ID

Parent Account Reference

Reference to the parent company in Dynamics 365.

Tax ID

Tax Identification Number

The tax identification number of the company.

Delivery Addresses

Delivery Address Fields

Delivery addresses for the company.

Contacts

Salesbuildr Information

Synced to Dynamics 365 as

Description

First Name

First Name

The first name of the contact.

Middle Name

Middle Name

The middle name of the contact.

Last Name

Last Name

The last name of the contact.

Email

Email

The email address of the contact.

Company ID

Company Reference

Reference to the company the contact is associated with.

Phone

Phone

The phone number of the contact.

Setup

  1. Go to Appsource to download the Salesbuildr Connector for Dynamics 365 Sales and click download now.

  1. Select your environment, (sandbox or production), agree to the terms and click install.

  2. The connector will now install

Changing the settings for the Dynamics Integration

Navigate to Microsoft Dynamics settings page to select the Salesbuildr settings page.

On the setup page you can configure the Salesbuildr integration. "API Key" , "Salesbuildr Uri" and "Salesbuildr Api Endpoint" are essential values used for authentication with Salesbuildr's APIs, so make sure not to alter these.

  • Enable Salesbuildr Integration: Set to yes to enable the Salesbuildr Sync button on Companies, Contacts and Opportunities.

  • Create Salesbuildr Opportunity On: Choose Create to Automatically Create an Opportunity in Salesbuildr when you create an opportunity in Dynamics. Choose Manual if you only want to manually create an opportunity in Salesbuildr from the opportunity card in Dynamics

  • Create Salesbuildr Account On: Choose Create to Automatically Create an Account in Salesbuildr when you create an Account in Dynamics. Choose Manual if you only want to manually create an Account in Salesbuildr from the company card in Dynamics.

  • Create Salesbuildr Contact On: : Choose Create to Automatically Create a Contact in Salesbuildr when you create a Contact in Dynamics. Choose Manual if you only want to manually create a Contact in Salesbuildr from the contact card.

  • "Default Item Tracking Code": This field is used when Salesbuildr sends an item that is being tracked (where "Serial Number Tracked" is checked). In this case, the tracking information will be filled in under this code on the item.

  • "Calculate Stock From": This field denotes the level at which the stock is calculated to be sent to Salesbuildr.

  • "Last Checked Entry Stock Updates": This field specifies which warehouse or item post was last checked for stock updates to be sent to Salesbuildr.

  • "Sync SalesBuildr Quotes to BC Document Type": This field determines the type of sales document created in Business Central (BC): either a quote or an order.

  • "Purchasing Code Drop Shipment": This field is used to fill in the purchase code on the sales order line if it's a drop shipment.

Creating leads in Dynamics 365 Sales

After the creation of a lead in Dynamics 365 Sales, the lead's details, such as their name, company, email, lead source, follow-up date, and the estimated value of the lead, can entered. If the lead becomes a qualified opportunity, these details are used to create an account and a contact in the system.

Creating opportunities in Dynamics 365 Sales

When the lead becomes an opportunity, more fields can be filled in, including estimated close date, estimated revenue, probability of success, and any competitors for the opportunity. Additionally, potential solutions, and stakeholders can added to the opportunity in Dynamics 365 Sales, depending on how you have setup opportunity stages and fields on entities.

Quote Generation in Salesbuildr

After you have created the opportunity in Dynamics 365 Sales, you then need to synchronise the opportunity to Salesbuildr where the quote can be created.

Once you have opened the opportunity in Salesbuildr, you can create a quote for that opportunity with the Create Quote button. Follow the steps in How to create and send a quote from here on.

What will be synchronised back to Dynamics 365 Sales

Synchronised fields include:

  • Quote Details: Basic information about the quote, such as the quote number, date of quote creation, the customer it's for, and the sales representative who created it.

  • Line Items: Specifics about the products or services included in the quote, such as the item description, quantity, price per unit, and total line item cost.

  • Quote Totals: Aggregated information about the quote, such as the subtotal, any applied discounts, and the grand total.

  • Quote Status: The current state of the quote, such as whether it's been sent, viewed, accepted, or declined.

  • Notes and Attachments: Any notes or attachments added to the quote during creation in Salesbuildr.

  • Revision History: Depending on the system's capability, if a quote is revised in Salesbuildr and sent back to Dynamics 365, it will also sync the revision history.

Alternative Quote Generation and revisions

Alternative quotes can be generated and differentiated from the main quote for accurate reporting. Set one of the quotes as the primary quote so that the data from that quote can be used to populate and calculate fields in Microsoft Dynamics based on the line items and order value. when you retract a quote in Salesbuildr, it's possible to revise the quote and resend it.

To do this, you would first need to use the "Retract Quote" function in Salesbuildr. This will pull the quote back from Microsoft Dynamics 365 and mark it as withdrawn. After that, you can revise the quote in Salesbuildr and then send it back to Dynamics 365 using the "Send Quote" function.

The newly revised quote will now replace the original in Microsoft Dynamics 365, and the original quote will remain in the system with a status of 'withdrawn', so it can be reviewed when needed.

Salesbuildr and Dynamics 365 Business Central

Article synchronisation

Items can be manually pushed from Salesbuildr to Business Central (BC). These items will appear on the "Salesbuildr Items" page.

A job queue entry runs to try and create these items. Any errors that occur during this process need to be monitored and corrected in this log. You can manually execute these actions using the buttons at the top of the page.

Fields that SalesBuildr sends to Business Central include:

  • SalesBuildr Item Number

  • Description

  • BC Item Template Code

  • Serial Number Tracked

  • Item Taxes

During import, the system checks if an item with this "Salesbuildr Item Number" already exists:

If it does not, the item is created:

  • The description is filled in

  • If an item template is sent along, it is applied

  • The Salesbuildr Item Number is filled in

  • The item tracking code is filled in with the value from the setup table if necessary

  • Taxes are created

If it does exist:

  • The description is updated

Afterwards, the Business Central Item Number is sent back to Salesbuildr.

How drop shipments work

At the quote line level in Salesbuildr, an Account Manager or Presales can indicate whether it's a drop shipment. This is a manual process since there are no rules for it.

  • By default, drop shipment is activated. Unless there's own stock, then this checkbox is deactivated.

  • When the Salesbuildr quote is confirmed, the drop shipment information flows through the API to Business Central (BC).

  • A Business Central Purchase Order is created with a drop shipment checkbox per line. (If necessary, Purchasing can still adjust this now)

  • The purchase order is placed after validation in Business Central.

Sales orders

Once a customer approves a quote, a sales order will be sent to Business Central. Salesbuildr quotes appear on the "Salesbuildr Quotes" page in Business Central (BC). A job queue entry also runs over this table to process the lines. Fields that Salesbuildr sends to Business Central :

  • SalesBuildr Quote Number

  • SalesBuildr Quote Line Number

  • CRM Quote Number

  • CRM Account ID

  • SalesBuildr Line Type (empty, Services, Labor, Products)

  • SalesBuildr Number (related to SalesBuildr Line Type)

  • Description

  • Quantity

  • Cost Price

  • Unit Price

  • Line Discount

  • Supplier

  • SBO Reference

  • Item Template Code

  • Serial Number Tracked

  • Drop Shipment

  • Procurement

  • Item Taxes

This is how the order will be send to Business Central

{

“quoteidSB”: “”,

“accountidCRM”: “”,

“quoteidCRM”: “”,

“itemnoSB”: “”,

“description”: “”,

“quantity”: “”,

“unitcost”: “”,

“salesprice”: “”,

“discount”: “”,

“vendorno”: “”,

“specialbidorderID”: “”,

“costcenter”: “”,

“dropshipment”: “”,

“template”: “”,

"itemcategory": "",

"unitofmeasure": ""

}

Job queue entry functionality:

  • First, it checks if all items exist in BC (only the lines with Procurement = false) and the "BC Item Number" is filled in. If the item doesn't exist, it is scheduled for creation, along with the taxes coming from Salesbuildr.

  • Then, all lines that are marked as "Not Processed" and for which all necessary items have been created, are reviewed and converted into a BC sales document (depending on the field in the setup). These lines then become "Processed".

  • Finally, the Processed lines are reviewed to send the BC sales document number back to Salesbuildr.

The customer is identified based on the "CRM Account ID" that Salesbuildr sends along.

"Salesbuildr Quote Number" and "CRM Quote Number" are filled in on the sales document and are forwarded to the booked sales shipment and invoice.

Again, these actions can be manually executed using the buttons on the page.

Business Central Stock synchronisation to Salesbuildr

The stock inventory is sent from Business Central (BC) to Salesbuildr. Depending on the settings in the Salesbuildr setup, the stock is forwarded per:

  • Item

  • Branch

  • Storage location

If 'Branch' is chosen, you can set the "Calculate SalesBuildr Stock" tick box on the relevant branches to indicate which branches should be included in the calculation of an item's stock. If 'Storage locations' is chosen, you can apply the same tick box on the storage locations.

This is carried out via the following job queue entry:

This entry checks the last time the stock update was run and only updates the items on SalesBuildr that have had stock updates in BC in the meantime. There is also another job queue entry that can be scheduled: "Codeunit 90615 – SB Stock update per item BSF". This will send a stock update for all items that have a "Salesbuildr Item Number" filled in.

You can also use the "Update Stock Salesbuildr" button on the item card and list to send the stock of items directly to Salesbuildr. Once again, these actions can be manually executed using the buttons.

Did this answer your question?