Edit

Share via


Integrate with Microsoft Dynamics 365 Field Service

Service organizations require a front-to-back application in which finance, inventory, and procurement are tightly coupled with service delivery. Every work order represents cost or revenue, and every resource generates profit or loss in the general ledger. The integration between Business Central and Field Service streamlines the end-to-end process of managing service operations and ensures a smooth flow of information between the two applications.

You can easily create and manage work orders in Field Service, track the progress of service tasks, assign resources, and capture consumption details. When you complete a work order in Field Service, the integration enables the smooth transfer of data to Business Central for further processing.

The integration also lets you invoice and fulfill work orders in Business Central. You can generate accurate invoices based on the service activities and the consumption recorded in Field Service.

By integrating Business Central with Field Service, you don't have to enter data manually or duplicate efforts. Integration also provides a comprehensive view of service operations and finances, enabling better decision-making and operational efficiency.

Types of integrations

Depending on the business processes you need, you can integrate Field Service with project management features only, or project management and service management features in Business Central.

Note

The Project and Service integration requires that you're using the Premium experience. Service management features aren't available in the Essential experience.

The option to integrate with project management and service management is a package deal. That is, you can't integrate with service management features only. The option always integrates both sets of features.

For example, integrating Field Service with project management lets you sync work orders in Field Service with project journals in Business Central. You can then use the project journal to post, for example, resource usage from the work order to the general ledger.

In addition to that, integrating Field Service with both project and service management also gives you:

  • Better scheduling and dispatching of service technicians based on their skills and ability.
  • Improved tracking of repair parts and supplies for services.
  • Accurate service estimates and invoices.

Prerequisites

Note

Most of these prerequisites apply to both types of integrations. However, there are some extra settings to integrate with service management features. To learn more about the settings, go to Set up the integration with service management features.

Integrate with Dataverse and Dynamics 365 Sales

To integrate with Field Service, you must:

Screenshot showing the hierarchy of apps in the integration.

Install required apps

You must download the following apps from AppSource, and install them in your Business Central environment:

Note

The Business Central Virtual Table app is optional. You only need it if you want to view information about item availability from Business Central in Field Service. To learn more, go to Optional: Make item availability information in Business Central available in Field Service.

Assign permissions and security roles to user accounts

When you install the Integration Solution, permissions for the integration user account are configured. The following sections list the permissions and security roles that the solution deploys for each app.

Tip

If those permissions change, you might need to reset them. To do that, reinstall the Integration Solution from the Dynamics 365 Connection Setup page by choosing Redeploy Integration Solution.

Sales

  • Dynamics 365 Business Central Integration Administrator
  • Dynamics 365 Business Central Integration User
  • Dynamics 365 Business Central Product Availability User

Business Central

Users who post project journals must have the following permission set:

  • Dynamics 365 Sales Integration

Note

To integrate with project and service management, you must be using the Premium experience, which requires a license. To learn more about the license, go to the Dynamics 365 licensing guide. When you have the license, on the Company Information page in Business Central, set the User Experience field to Premium.

Field Service

To use the integrated data, users must have the following security role:

  • Business Central Field Service Integration

For example, users must have this role to connect work orders to Business Central for processing.

Note

Ensure that users are assigned to the standard security roles and profiles in Field Service.

To learn more about column security profiles in Field Service, go to Field Service security roles.

Administrators must add one of the appropriate column security profiles to users in Power Platform. To learn more, go to Add teams or users to a column security profile to control access.

Note

To use the Open in Business Central action in Sales, you must have the following permissions for the following tables:

  • You must have Read permissions for the Dynamics 365 Business Central Connection (nav_connection) table.
  • You must have Read, Write, and Delete permissions for the Default Dynamics 365 Business Central Connection (nav_defaultconnection) table.

Set up the integration in Business Central

After you have a connection to Dataverse and Sales, you can set up your integration to Field Service.

Install the integration app, and run an assisted setup guide

  1. Download and install the Field Service Integration app from AppSource. Afterward, on the Extension Management page, find the Field Service Integration app, and choose the Set up action to run the assisted setup guide.
  2. On the Assisted Setup page in Business Central, choose Set up integration to Dynamics 365 Field Service to run the assisted setup guide.

The following list points out the key settings in the guide.

  • To let people post consumption of items and services in Field Service work orders, specify the Project Journal Template and Project Journal Batch to use to post consumption of products and services.

  • Because services are expressed in duration in Field Service, specify the Hours Unit of Measure to use to convert durations to quantities in Business Central.

  • You can also specify when work order products and service lines synchronize to Business Central. For example, they might synchronize when work order lines are used, or when someone completes a work order. Choose the appropriate option in the Synchronize work order products/services field.

  • After work order products and services synchronize to project journals in Business Central, you can choose whether to post the project journals manually. Choose the appropriate option in the Automatically post project journals lines field:

    • When a work order is complete
    • When work order products or services are used
  • Specify the Integration Type to integrate with project features only, or both project management and service management. The latter requires that you're using the Premium experience. To learn more, go to Types of integrations.

  • Optionally, if you want to enable technicians to view information about item availability from work orders, choose the Install Business Central Virtual Table app link.

Run a full synchronization

After you finish the setup, run a full synchronization from the Dynamics 365 Field Service Integration Setup page. This action synchronizes table mappings for things like:

  • Project tasks for projects with the Apply Usage Link set. This synchronization makes Business Central projects available for selection in Field Service.
  • Resources that aren't blocked, don't have Use Time Sheet selected, and do have Hours specified as the unit of measure on the Dynamics 365 Field Service Integration Setup page.
  • Service-related documents, items, and entries (requires that you're using the Premium experience in Business Central).

Integration table mappings for synchronization

The basis of synchronizing data is mapping the tables and fields in Business Central with tables and columns in Dataverse so they can exchange the data. Mapping happens through integration tables. To learn more about table mappings, go to Mapping the Tables and Fields to Synchronize.

When you finish the assisted setup guide, integration mappings are created. The following integration table mappings install if you choose the Project (default) integration type.

Integration table mapping Data the mapping synchronizes
PJLINE-WORDERPRODUCT Maps work order products in Field Service to project journal lines in Business Central.
PJLINE-WORDERSERVICE Maps work order services in Field Service to project journal lines in Business Central.
PROJECTTASK Maps projects and project tasks in Business Central to products in external projects in Field Service.
RESOURCE-BOOKABLERSC Maps resources in Business Central to bookable resources in Field Service. This mapping can also include resources that are users, which requires a few settings. To learn more, go to Synchronize resources that are people with bookable resources.
LOCATIONS Maps locations in Business Central to warehouses in Field Service.

Note: The LOCATIONS integration table mapping is available only if you turn on the Location Mandatory toggle on the Inventory Setup page.

The following integration table mappings install if you choose the Project and Service integration type.

Integration table mapping Data the mapping synchronizes
SRVORDER Maps service orders in Business Central to work orders in Field Service, including the status of the orders.
SRVORDERITEMLINE Maps service item lines in Business Central to work order incidents in Field Service.
SRVORDERLINE-ITEM Maps items on service order lines in Business Central with work order products in Field Service.
SRVORDERLINE-RESOURCE Maps resources on service order lines in Business Central with bookable resource booking in Field Service.
SRVORDERLINE-SERVICE Maps service lines in Business Central with work order services in Field Service.
SRVORDERTYPE Maps service order types in Business Central to work order types in Field Service.
SVCITEM-CUSTASSET Maps service items in Business Central with customer assets in Field Service.

Note

The integration also maps fields that show item availability information in Business Central on work orders and products in Field Service. However, the mapping happens through a virtual table, and not an integration table. Some setup is required. To learn more about virtual tables and viewing item availability, go to Optional: Make item availability information in Business Central available in Field Service.

Tip

To enable technicians who work with the data on mobile devices, you must synchronize resources of the type Person in Business Central with a User resource type in Field Service. To learn more, go to Synchronize resources that are people with bookable resources.

Set up the integration in Field Service

On the Field Service Setting page, make the following changes:

  • On the Purchase tab, clear the Use of Products Out of Stock field. Otherwise, you might get an "out of stock" warning when you choose a product that's out of stock in Field Service, but is in stock in Business Central.
  • On the Work Order / Booking tab, turn off the Calculate Price and Calculate Cost toggles. In the Work Order Invoice Creation field, choose Never.

Synchronize resources that are people with bookable resources

You can synchronize resources of the type Person in Business Central with bookable resources in Field Service that are the User type. The synchronization is bi-directional.

Note

On the Integration Table Mapping page, by default, for the RESOURCE-BOOKABLESC mapping the Resource Type field contains Generic|Account|Equipment|User. If you're upgrading your existing integration, you might have to add that value.

  1. On the User Setup page, add an email address for the user that you want to link with the bookable resource. The address must match the address from the user on the tenant where your Dataverse environment is located.
  2. On the Resource Card page, in the Time Sheet Owner User ID field, choose the user.
  3. Synchronize the resource manually, or wait until the job queue synchronizes resources with bookable resources.
  4. To verify the synchronization, in Field Service, open the Bookable Resource page and find the resource.

Integrate project and service management features

Integrating Business Central with Field Service lets you manage service tasks, consumption, and financial transactions to benefit service technicians, service managers, and finance teams. It's a powerful solution for managing work orders and consumption in Field Service and efficiently invoicing and fulfilling them in Business Central. The integration is bi-directional, meaning that when you enter or change data in either app, the data updates in the other.

Note

When you enable the integration with service management features, you also enable the integration with projects. You can't enable only the service management integration.

Set up the integration with service management features

You can enable the integration in the Integration Type field by selecting Project and Service in the following places:

  • In the Set up integration to Dynamics 365 Field Service assisted setup guide.
  • On the Dynamics 365 Field Service Integration Setup page.

When the Integration Type field is set to Project and Service, the following things happen when you enable the integration:

  • Creates a solution in Power Apps named Microsoft Dynamics 365 Business Central Field Service Integration (service).
  • Adds integration table mappings for service order types, service documents, service lines, and service item lines. To learn more about the table mappings, go to Integration table mappings for synchronization.
  • Fields in the headers on service orders and work orders transfer information, such as the Service Account, Billing Account, and Work Order Type.
  • Service Item Lines and Work Order Incidents in Field Service transfer information about the customer assets being repaired.
  • Service Line fields and Work Order Products and Work Order Services fields, such as Qty. to Ship, Qty. to Invoice, and Qty. to Consume.

In Business Central, make the following settings on the Service Management Setup page:

  • Turn on the Service Order Type Mandatory toggle. This setting is required because Field Service requires a work order type.
  • Make sure that the number series you use for service orders is set up to allow manual numbering. On the No. Series page, select the Manual Nos. checkbox for the number series. Manual numbering lets you create work orders in Field Service and synchronize them with service orders. Business Central uses the order number from Field Service.
  • Turn off the One Service Item Line/Order toggle. This setting lets you have more than one work item line.
  • Turn on the Archive Orders toggle.
  • Make the Service Order Type field on service orders mandatory because the Work Order Type is mandatory on Field Service work orders.

If you choose Enable Inventory Availability by Location when you set up the integration, you can view the allocated product quantity from work orders in Field Service as part of the gross requirements in Business Central's inventory availability calculation. Demand generated by orders in Field Service automatically becomes input for planning through synchronized service orders.

The status of service and work orders changes as they progress toward completion. The following table shows how the statues align in both apps.

Business Central status Field Service status Alignment
Pending Unscheduled Bidirectional per mapping to account for item demand.
Pending Scheduled Field Service to Business Central. Synchronizes the quantity to ship and the quantity to invoice.
In process In progress Field Service to Business Central. Synchronizes the quantity to ship and the quantity to invoice.
Finished Completed Field Service to Business Central. Ready for posting in Business Central.
Finished Posted Field Service to Business Central. When fully invoiced or deleted after partial invoicing in Business Central.
N/A Canceled Not synchronized. Manual alignment is needed for canceled work orders.

Upgrade your integration to include service management features

If you set up the integration to only include projects, but decide to add service management features later, that's easy to do in just a few steps. Remember that you must be using the Premium experience.

  1. On the Dynamics 365 Field Service Integration Setup page, turn off the Enabled toggle.
  2. In the Integration Type field, choose Project and Service.
  3. Turn on the Enabled toggle.

Optional: Make item availability information in Business Central available in Field Service

When technicians prepare work orders, it's helpful that they're sure that the items they need to do the work are available. This section describes how to set up things so people can view item availability information from Business Central in Field Service.

Synchronize ___location and warehouse data

You can integrate Field Service warehouses with locations in Business Central. The integration gives technicians information about the availability of a product or item at a specific ___location.

The data synchronizes from Business Central through a unidirectional integration table mapping between locations in Business Central and warehouses in Field Service. To use the integration table mapping, you must turn on the Location Mandatory toggle on the Inventory Setup page in Business Central.

Business Central synchronizes locations with the following settings on the Location Card page:

  • The Use as In-Transit toggle is turned off.
  • Project Consump. Whse. Handling is different from Warehouse Pick (mandatory).
  • Assm. Consump. Whse. Handling is different from Warehouse Pick (mandatory).

In Business Central, on the Locations and Location Card page, you can use the Warehouse action to open a coupled ___location in Field Service, synchronize it, set up and delete couplings, and view synchronization logs.

Set up virtual tables

A virtual table is a custom table that has columns and rows that contain data from an external data source, such as Business Central. The columns and rows in a virtual table look like a regular table, however, the data isn't stored in a physical table in the Dataverse database. Instead, the data is retrieved at runtime. To learn more about virtual tables, go to Use virtual tables to get more data.

To use virtual tables in your integration, the first thing to do is to install the Business Central Virtual Table app from AppSource.

Note

Your Field Service and Business Central must be in the same tenant. That's a requirement for using virtual tables.

Afterward, on the Dynamics 365 Field Service Integration Setup or Set up integration to Dynamics 365 Field Service pages in Business Central, turn on the Enable Inventory Availability by Location toggle. When you enable inventory availability by ___location, a dyn365bc_availabilitybylocation_v2_0 virtual table becomes available. You must create a synthetic relation between the following tables:

  • The native Product and Work Order Product tables in Field Service and the Item Availability virtual table that shows item availability.

There's an assisted setup guide to help you create the synthetic relation. To create the synthetic relation, follow these steps:

  1. In Business Central, on the Dataverse Connection Setup page, use the Synthetic Relations action.
  2. On the Synthetic Relations page, choose the New action to start the New Synthetic Relation assisted setup guide.
  3. In the Native Dataverse Table field, choose the The AssistEdit icon. button, and then choose CRM Product.
  4. In the Virtual Dataverse Table field, choose the The AssistEdit icon. button, and then choose Inventory Availability by Location.
  5. On the Synthetic Relations page, choose the New action to start the New Synthetic Relation assisted setup guide again.
  6. In the Native Dataverse Table field, choose the The AssistEdit icon. button, and then choose FS Work Order Product.
  7. In the Virtual Dataverse Table field, choose the The AssistEdit icon. button, and then choose Inventory Availability by Location.
  8. Choose Next.
  9. In the Field in the FS Work Order Product table field, choose Product Id.
  10. In the Field in the Item Availability by Location table field, choose itemNo.
  11. Choose Finish to complete the guide.
  12. To make your setup available in Field Service, in the Power Apps admin center, choose the view, and then choose the Save and Publish action.

Note

It can take a few moments to create the synthetic relations.

Set up the view in Field Service

The next thing to do is to create and customize the view that people use in Field Service to check the inventory of products.

To create the view in Field Service, follow these steps:

  1. In Power Apps admin center, on the navigation pane, choose Tables.

  2. Choose the Item Availability by Location table.

  3. In the Data experiences part, choose Views.

  4. Choose the View column action, and then choose the columns you want the view to include. The following columns are typical choices:

    • Location Code shows where the product is available.
    • Item No. confirms you're looking at the correct product.
    • Item Description provides information about the product.
    • Unit of Measure Code gives you an idea of the space you need.
    • Remaining Quantity shows how much of the product is available at each ___location.

Integrate with Microsoft Dataverse via data sync
Mapping the Tables and Fields to Synchronize