Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
Customers are experiencing difficulties in creating Dynamics Finance and Operations (F&O) virtual entities in Dataverse. When attempting to search for 'Available Finance & Operations virtual entity' using advanced find, an error is encountered.
Reason:
The underlying cause of this is not explicitly detailed in the provided case information.
Resolution:
- Ensure that all steps outlined in the Microsoft documentation for configuring Dataverse virtual entities are followed correctly. The relevant documentation can be found at: Configure Dataverse virtual entities - Finance & Operations | Dynamics 365 | Microsoft.
- If errors persist, check the connection settings to SQL Server to ensure they are configured correctly. Note that SQL connections to Azure Synapse for creating virtual tables are not supported due to limitations with CRUD operations.
- Verify that the public network access setting for Azure SQL Database is set to "Yes." If it is, use the Private Endpoint from within the virtual network to connect to the server.
- For further assistance, gather specific details such as screenshots of the error, the Microsoft documentation being followed, and confirm whether this is the first implementation of the virtual entity in the environment.