Share via


View item availability in Field Service work orders

Enabled for Public preview General availability
Users by admins, makers, or analysts - Apr 1, 2025

Business value

When you integrate Field Service with Business Central, technicians and dispatchers can check item availability at a specific warehouse or technician's truck on a work order in Field Service. Having this information readily available helps businesses optimize work order scheduling, avoid unnecessary travel costs, and optimize their service and purchasing operations.

Feature details

Now you can integrate, configure, and customize Field Service warehouses with Business Central locations. To manage data synchronization, we added a unidirectional integration table mapping (from Business Central) between Business Central locations and Field Service warehouses. To use the new integration table mapping, turn on the Location Mandatory toggle on the Inventory Setup page in Business Central.

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

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

On the Locations and Location Card pages, use the Warehouse action to open a coupled location in Field Service. With this action, you can sync the location, set up and delete couplings, and view sync logs.

Shows locations list with Synchronize action group and Coupled to Field Service column

In Field Service, use Open in Business Central to open a location in Business Central. This location couples to a warehouse in Field Service.

Select Enable Inventory Availability by Location on the Dynamics 365 Field Service Integration Setup page or on the Set up integration to Dynamics 365 Field Service page.

Shows Enable Inventory Availability by Location in Field Service assisted setup guide.

When you turn on inventory availability by location, you get a new Inventory Availability by Location API as a Dataverse virtual table available. The API creates a synthetic relationship between this virtual table and the native Products table in Field Service.

In Field Service, on the Products page, technicians can see how much of a product is available at a warehouse they choose.

Shows Products page with Items Availability by Location information in Field Service

Geographic areas

Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.

Language availability

Visit the Explore Feature Language report for information on this feature's availability.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

Additional resources

Integrate with Microsoft Dynamics 365 Field Service (docs)