Extending Microsoft Dynamics 365 Finance and Supply Chain Management Cookbook - Second Edition

How to do it...

First, we will create a simple view of service orders, which we will start as a query. To do this, follow these steps:

1. Create a new query named ConVMSVehicleServiceDetailView.

This query will be used to create a view. Since this query will control the structure of our view, we want it to be obvious that this query is written as the basis for a view. If another developer made a change to the query and used it for their own purpose, it would affect the view or views that use it.

2. Drag the ConVMSVehicleTable table onto the Data Sources node of the new query.
3. On the property sheet for the new ConVMSVehicleTable data source, change the Dynamics Fields property to Yes and then set it to No.

Choosing yes will populate the field ...