We are trying to integrate Business Central with Field Service. We followed Microsoft Doc and are almost done. But when we are trying to create work order table of field service/dataverse with Job table of BC via integration table mapping, the field service account which is mandatory or work order table is not coming in field options for integration table mapping.
If i clear the filter and then choose service account this error is coming that service account has relationship with some other table.
If we are running sync without service account job queues are failing.
Am I missing something? If it was case for field missing in BC , I will just create custom field mapping but what about a standard field of data verse missing in dropdown which is mandatory to create a record in dataverse.
Also, i didn't get that the app source based extension provided by Microsoft for field service integration with BC, why it is not providing standard linkage between Job and work order table at the first place?