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

I have the same question (0)

All responses (7)

Answers (0)

Bilal Haider 414 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Hafiz@d365 13 on at

Like (0)

Report

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."));

}

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (0)

Report

Hi,

Please try this

Was this reply helpful? Yes No
Hafiz@d365 13 on at

Like (0)

Report

custom table data is not coming into the cloud

Was this reply helpful? Yes No
Hafiz@d365 13 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (0)

Report

Are you sure you are putting correct consumerId that is right for the Customer on this Ledger Entry

Was this reply helpful? Yes No
Hafiz@d365 13 on at

Like (0)

Report

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

Was this reply helpful? Yes No