Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Add field to record link table in BC 14 on Prem

Posted on by
I have a client that has a customization to  the system table /Record Link/. They have added a few new  fields  . I am trying to convert that customization to an extension, They will be on BC 14 on Prem.
When I create a table extension for that table, I get an error as soon a I enter the table name that the table can not be extended. I did some research and it seems like we can not extend that table as it is a system table. Has anyone come up with a work around ? 
 
This client will add Links to the item and mark them as send to PO or sent to SO. If send to PO, when they print/email the Purchase order document, we are also printing/emailing the Record link PDF document for that item as it has some information related to the design of the item. Has anyone had  a similar request and how have you re-designed it or made it work ?
 
Thank you.
 
 
Categories:
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,611 User Group Leader on at
    Add field to record link table in BC 14 on Prem
    Hi,
     
    Yes, you cannot extend system tables.
     
    You have to refactor the customization like -
     
    1. Add a Subsidiary table connected to Record Link. (With primary key Link ID (From Record Link) and ID (type integer).
    2. Using Events, you can manage when a new Record link is added, record get created in New Table and sets custom field as needed.
    3. While trying to send email refer to custom table to review field values.
     
    Hope it helps.
     
     
    Regards,
    Saurav Dhyani

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans