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... / extension on standard ...
Small and medium business | Business Central, N...
Answered

extension on standard table is not working for the custom fields in Business Central

(0) ShareShare
ReportReport
Posted on by Hafiz@d365 13

Hi,

Important Note: If any abusive statement or matter in this forum, by myself, please let me know, and I will correct it immediately. Please please note I am only focused on my Solution delivery. Which may help others to understand BC central better. I am a fan of BC. for the last 12 years. I am proud to be Microsoft family. Dear Admin, sometimes my question may repetitive because U wanted to reach to the right knowledge  resource

I have an issue or maybe I don't follow the help text. Maybe I am missing some actions. The extension on the standard table is not working for the custom fields in Business Central. All other custom tables and reference fields within Custom tables are working

But custom fields in the Standard table when needing a reference from Custom tables are not accepted. Suppose I add a Consumer code from the consumer master (custom table) and add in Cust ledger entry, the field is created with the same  size and it was working in On-promise, also we can see values in the SQL server

when we migrate using Cloud Migration tool it is not inserted in Standard table 

I have the same question (0)
  • Hafiz@d365 Profile Picture
    Hafiz@d365 13 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    Thank you all,

    Bye Bye

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,843 Super User 2025 Season 2 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    then you have to use table mapping as mentioned in the below link

    learn.microsoft.com/.../migration-table-mapping

  • Hafiz@d365 Profile Picture
    Hafiz@d365 13 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    /On-premise is on Dynamics 365  Business Central version 14.0.29530.   Do you want me to convert On-premise also to migrate to BC with AL??

    even if we make an extension on the on-premise with an app id will be different when I make an extension for the cloud

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,843 Super User 2025 Season 2 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    Is appID same in both OnPrem and Cloud?

  • Hafiz@d365 Profile Picture
    Hafiz@d365 13 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    Yes, Mohan,

    BC 2019 Spring

    This is an example

    tableextension 50100 BGS_CustoLedgerEntrytab extends "Cust. Ledger Entry"

    {

       fields

       {

           modify("Customer No.")

           {

               Width = 20;

           }

             modify(Description)

           {

               Width = 250;

           }

    // THIS IS AN AREA  I HAVE AN ISSUE

    --------------------------------

           field(50000; "Consumer Id"; Code[20])

           {

               DataClassification = ToBeClassified;

               TableRelation = "BGS_Consumer Master2"."Consumer Id"

     WHERE("Customer no" = FIELD("Customer No."));

           }

       }

       keys

       {

       }

       var

           consmas: Record "BGS_Consumer Master2";

    }

    the following is a custom table with key

    -----------------------------------------

    table 50158 "BGS_Consumer Master2"

    {

       DrillDownPageID = "BGS_Consumer List";

       LookupPageID = "BGS_Consumer List";

       fields

       {

           field(1; "Consumer Id"; Code[20])

           {

               DataClassification = ToBeClassified;

           }

           field(2; "Consumer Name"; Text[50])

           {

               DataClassification = ToBeClassified;

           }

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,843 Super User 2025 Season 2 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    You upgraded from which version to which version?

    If it is CAL to AL upgrade then there will be change in the schema of fields.

    In CAL, it will be in single table

    In AL/Extensions, It will be created as a separate table  with AppID with PK and custom fields.

    You have to define table mapping as described in the below link while migrating

    learn.microsoft.com/.../migration-table-mapping

  • Hafiz@d365 Profile Picture
    Hafiz@d365 13 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    Yes Customized, the solution and migrated with txt2tool to AL. In VSC, I have corrected a few codes as per cloud requirements. The app is created and uploaded in Cloud Sandbox. All custom tables are loaded. Standard data is loaded. Finally standard data with custom fields only empty

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,843 Super User 2025 Season 2 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    You didnt answer to my question :)

    Have you done customizations as extensions/app?

    Did you install the same app/extensions in Cloud environment also?

  • Hafiz@d365 Profile Picture
    Hafiz@d365 13 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    I have created a new field in the Cust Ledger Entry table with the name 'Consumer code'. This code key value is from a custom table name called 'Consumers'.  This arrangement was working fine when I was on a promise. We also can see the correct update value table in SQL too. when I migrate using the Cloud Migration tool, all values in 'Consumer id' are missing in standard tables where I have added this new field

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,843 Super User 2025 Season 2 on at
    RE: extension on standard table is not working for the custom fields in Business Central

    What do you mean by "not inserted in Standard table"?

    You cant find data in the custom fields?

    Did you install same extension of OnPrem in SaaS also?

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
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,406

#2
Sumit Singh Profile Picture

Sumit Singh 2,852

#3
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,217

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans