Skip to main content

Notifications

Small and medium business | Business Central, N...
Unanswered

Field Service integration and custom fields to Project Journal

Posted on by
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! 😊

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans