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)

Sort by

Bilal Haider 483 on at

Like (1)

Report
Copy link

Link copied!

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 23 on at

Like (0)

Report
Copy link

Link copied!

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 483 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please try this

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

Like (0)

Report
Copy link

Link copied!

custom table data is not coming into the cloud

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

Like (0)

Report
Copy link

Link copied!

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 483 on at

Like (0)

Report
Copy link

Link copied!

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 23 on at

Like (0)

Report
Copy link

Link copied!

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