Share This Post

Business Central

Using Business Central for Dynamics 365 for Sales

If you utilize Dynamics 365 for Sales for customer engagement, you can experience seamless unification in the lead to cash process by Using Business Central for Dynamics 365 for Sales for backend activities like processing orders, managing inventory and doing your finances.

Before you can use the integration capabilities, you must set up the connection and define users in Dynamics 365 for Sales. You can work with and synchronize data that both services have in common, such as contacts, customers and sales information and keep the data up to date in both applications.

For example, a sales person in Sales can utilize the price lists from D365 Business Central when they create a sales order. When they add the item to the sales order line in Sales, they can see the inventory level of the item from Business Central.

Contrarily, order processors in MS D365 Business Central can handle sales orders that are automatically or manually shifted from sales. For example, they can create and post sales order lines for items or resources that were entered in Sales as write-in products.

Using Business Central for Dynamics 365 for Sales Overview

1. Coupling Records

The assisted setup guide lets you choose the data to synchronize. Later, you can also set up synchronization for specific records. This is referred to as coupling. For example, you can couple a specific account in Sales with a specific customer in MS D365 Business Central. This section describes what to take into consideration when you couple records.

For example, if you want to see accounts in Sales as customers in Business Central, you must couple the two types of records. To do that, on the Customers list page in D365 Business Central, utilize the Setup Coupling action.

When you set up coupling between two records, you can also manually request current record, for example a customer, to be overwritten immediately by account data from Sales using Synchronize Now action. Synchronize Now action which will ask whether to overwrite Sales or Business Central record data.

In Sales, sales orders depend on information such as customers, units of measure, currencies, customer price groups, and items and/or resources. For the integration with sales orders to work you must couple customers, units of measure, currencies, customer price groups, and items and/or resources.

2. Fully Synchronizing Records

At the end of the assisted setup guide you can choose the Run Full Synchronization action to start synchronizing all Business Central records with all related records in Sales.

On the D365 for Sales Full Synch Review page, you select the Start action. Fill synchronization can take some time to complete, but you can continue to work in Business Central while it runs in the background.

To check the progress of individual jobs in a full synchronization, on the D365 for Sales Full Synch Review page choose an record to view details. To update the status amid synchronization, refresh the page.

From the Microsoft D365 Connection Setup page, you can get details about full synchronization at any time. From here, you can also open the Integration Table Mappings page to check the details about the tables in MS Business Central and Sales that must be synchronized.

3. Handling Sales Order Data

Sales orders that people submit in Dynamics 365 for Sales will be transferred to Business Central if you select the Automatically Create Sales Orders check box on the MS D365 Connection Setup page.

Alternatively, you can manually convert submitted sales orders from Dynamics 365 for Sales by using the Create in Business Central action available on Sales Orders – Dynamics 365 for Sales page. On such sales orders, the Name field present on the original order is shifted and mapped to the External Document Number field on the sales order in MS Business Central.

This can also work if the original sales order consists of write-in products, meaning items or resources that are not registered in either app. In that case, you must fill in the Write-in Product Type and Write-in Product No. fields on the Sales and Receivables Setup page so that such non-registered product sales are mapped to a specified item or resource number for financial analysis.

If the description of the item on the original sales order is long, an additional sales order line of the type Comment is created to hold the full text on the sales order in Business Central.

Updates to the sales order header fields, like Last Shipment Date or Requested Delivery Date, that are mapped in SALESORDER-ORDER Integration table mapping are periodically synchronized to Dynamics 365 for Sales. Processes such as releasing a sales order and shipping or invoicing a sales order are posted to the sales order timeline in Dynamics 365 for Sales.

4. Handling Sales Quotes Data

Sales quotes that are activated in Dynamics 365 for Sales will be transferred to Business Central if you select the Automatically Process Quotes check box on the Microsoft D365 Connection Setup page.

Alternatively, you can manually convert activated sales quotes from Dynamics 365 for Sales by using the Process in Business Central action on the Sales Quotes – D365 for Sales page.

On such sales quotes, the Name field present on the original quote is shifted and mapped to the External Document Number field on the sales order in Business Central. Also Effective To field on quote is transferred and mapped to the Quote Valid Until field on sales quote in Business Central.

Sales quotes go through many revisions while they are being finalized. Both manual and automatic processing of sales quotes in Business Central ensures that previous versions of sales quotes are archived before processing new revisions of sales quotes from Dynamics 365 for Sales.

5. Handling Posted Sales Invoices, Customer Payments and Statistics

After fulfilling a sales order, invoices will be created for it. When you invoice a sales order, you can shift the posted sales invoice to D365 for Sales if you select the Create Invoice in D365 for Sales check box on the Posted Sales Invoice page. Posted invoices are transferred to Dynamics 365 for Sales with the status, Billed.

When the customer payment is received for the sales invoice in Microsoft Dynamics 365 Business Central, the sales invoice status will be changed to Paid with the Status Reason field set to Partial, if partially paid, or Complete if completely paid, when you select the Update Account Statistics action on the customer page in MS D365 Business Central.

The Update Account Statistics function will also refresh values, such as the Balance and Total Sales fields in the Business Central Account Statistics FactBox in Dynamics 365 for Sales.

Alternatively, you can have the scheduled jobs, Customer Statistics and POSTEDSALESINV-INV automatically run both of these processes in the background. For more details on Using Business Central for Dynamics 365 for Sales, please contact us.

Share This Post

Leave a Reply

avatar
  Subscribe  
Notify of
Skip to toolbar