web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Field Service integrat...
Small and medium business | Business Central, N...
Suggested answer

Field Service integration and custom fields to Project Journal

(3) ShareShare
ReportReport
Posted on by Whatahazakata 6
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! 😊
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,374 on at
    Field Service integration and custom fields to Project Journal
     

    Hi there,

    Great work on setting up the integration between Dynamics 365 Field Service and Business Central! You're on the right track with using altpgen.exe and extending the integration tables.

    Regarding your issue:

    Why the Custom Field Isn’t Appearing in the Mapping Tool

    The Field Mapping Tool in Business Central only recognizes fields that are:

    Suggested Steps to Resolve

      • Properly added to the integration table extension.
      • Included in the integration metadata generated by altpgen.exe.

      1. Verify Field Extension:

        • Ensure your tableextension includes the correct field type and attributes.
    • tableextension 50103 "Work Order Service Ext" extends "FS Work Order Service"
      {
          fields
          {
              field(70000; "Custom Field"; Text[100])
              {
                  DataClassification = ToBeClassified;
              }
          }
      }

    • Regenerate Metadata:

      • After adding the field, rerun altpgen.exe to regenerate the integration metadata.
      • Make sure the new field is included in the generated XML or JSON metadata files.

    • Deploy and Sync:

      • Deploy the extension and ensure the integration table is synced.
      • Restart the BC service tier if needed to refresh metadata.

    • Alternative via Power Automate:

      • If the field still doesn’t appear, you can use Power Automate to copy the custom field from Field Service to Business Central.
      • Use the Dataverse connector to read the Work Order Service record and the Business Central connector to update the Project Journal Line.

    • Let me know if you'd like help with the Power Automate flow or reviewing your AL code!

      Please verify if this response was helpful.

      Best regards!

  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,086 Super User 2025 Season 2 on at
    Field Service integration and custom fields to Project Journal
    To have your custom field appear in the Business Central field mapping tool for the FS Work Order Service integration table, you need to:
     
    1. Extend the FS Work Order Service table with your custom field and ensure it has the [IntegrationField] attribute in your AL code. This attribute is required for the field to be exposed in the integration framework.
     
     
    2. Publish and synchronize your extension so Business Central recognizes the new field.
     
     
    3. After publishing, the field should become available in the Integration Table Mapping setup and the field mapping tool.
     
     
    4. If it still doesn’t appear, clear the client cache or restart the BC client to refresh metadata.
     
     
    5. Alternatively, if extending the integration table is complex, use Power Automate to transfer the custom field data from Field Service to Business Central by updating the Project Journal Lines directly.
     
     
     
    Mark the checkbox below if this answers your question.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,119

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,902

#3
Sumit Singh Profile Picture

Sumit Singh 3,021

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans