Dynamics 365 Field Service Integration with Business Central
I've been testing the out-of-the-box integration between Dynamics 365 Field Service (D365 FS) and Business Central (BC). So far, the basic functionality works well — Work Orders and related products/services from Field Service are correctly integrated into Project Journals in Business Central.
However, I'm looking to extend this integration by adding custom fields, specifically to the Project Journals.
There is a custom field in Field Service that I want to map to a Project Journal in Business Central. To provide more context, the Integration Table Mapping is named "PJLINE-WORDERSERVICE," with the BC table name being "Project Journal Line" and the Integration Table name "FS Work Order Service".
I have extended integration tables (using altpgen.exe) and have successfully added custom/missing fields to other integrations.
However, when I tried to extend the "FS Work Order Service" integration table (tableextension 50103 "Work Order Service Ext" extends "FS Work Order Service"), the new field I added is not available for selection in the field mapping tool in Business Central.
Does anyone have suggestions on how to solve this? I’m also open to alternative methods for copying the field, such as using Power Automate.
Thanks in advance! 😊