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

Issues in Cloud Migration Setup, particular Fields value (custom field) is not copied into target

(0) Share

Report

Posted on by Hafiz@d365

Hi,

When using the cloud migration setup tool to Migrate my On-Promise data to cloud, I am missing a value in one important custom field value. it is empty. The reference table is which is also a custom one is already loaded.

Anyone, please help

Regards

Chowdary

All responses (7)

Answers (0)

Hafiz@d365 13 on at

Like (0)

Report

RE: Issues in Cloud Migration Setup, particular Fields value (custom field) is not copied into target

It is working locally and I can see the values in the SQL database.

do I need an extension for the custom object for the permission set
Suggested answer

Bilal Haider 248 on at

Like (0)

Report

RE: Issues in Cloud Migration Setup, particular Fields value (custom field) is not copied into target

Are you sure you are putting correct consumerId that is right for the Customer on this Ledger Entry
Hafiz@d365 13 on at

Like (0)

Report

RE: Issues in Cloud Migration Setup, particular Fields value (custom field) is not copied into target

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

{

DataClassification = ToBeClassified;

TableRelation = "BGS_Consumer Master2"."Consumer Id" WHERE("Customer no" = FIELD("Customer No."));

}

this is my code in table 21

fields

{

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

{

DataClassification = ToBeClassified;

}

Customer new table 'BGS_Consumer Master2'

This particular field is defined in Customer Ledger entry, Detailed Customer ledger,tables 36,37,112,113,32, and many places related to customer.. it

Checklist

The database is in SQL with custom objects and modified objects (tables)

Cloud Migrationsetup

Custom table mapped

Run Data Migration Now

Run data upgrade now

I noticed when I entered the consumer id manually, it is allowing to enter but not get saved

Please advice mistake
Hafiz@d365 13 on at

Like (0)

Report

RE: Issues in Cloud Migration Setup, particular Fields value (custom field) is not copied into target

custom table data is not coming into the cloud
Suggested answer

Bilal Haider 248 on at

Like (0)

Report

RE: Issues in Cloud Migration Setup, particular Fields value (custom field) is not copied into target

Hi,

Please try this
Hafiz@d365 13 on at

Like (0)

Report

RE: Issues in Cloud Migration Setup, particular Fields value (custom field) is not copied into target

Reference master

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

fields

{

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

{

DataClassification = ToBeClassified;

}

Extended table (21)

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

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

{

DataClassification = ToBeClassified;

TableRelation = "BGS_Consumer Master2"."Consumer Id" WHERE("Customer no" = FIELD("Customer No."));

}
Bilal Haider 248 on at

Like (1)

Report

RE: Issues in Cloud Migration Setup, particular Fields value (custom field) is not copied into target

Hi,

Have you got any migration errors related to that table ? And if the field type and size same in cloud and on prem table?