You’re offline. This is a read only version of the page.
83
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
Thank you all,
Bye Bye
then you have to use table mapping as mentioned in the below link
/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
Is appID same in both OnPrem and Cloud?
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;
}
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
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
You didnt answer to my question :)
Have you done customizations as extensions/app?
Did you install the same app/extensions in Cloud environment also?
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
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,993
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (