Dynamics Community Forum Thread Details

In Cloud Migration Management there is an action "Manage Custom Tables".

I created an extension and inside it a table that matches the definition of GP table GL00100.

table 50140 "GL00100"

{

DataClassification = SystemMetadata;

fields

{

field(1; "[ACTINDX]"; Integer) { DataClassification = SystemMetadata; }

field(2; "[ACTNUMBR_1]"; Text[50]) { DataClassification = SystemMetadata; }

field(3; "[ACTNUMBR_2]"; Text[50]) { DataClassification = SystemMetadata; }

field(4; "[ACTNUMBR_3]"; Text[50]) { DataClassification = SystemMetadata; }

field(5; "[ACTNUMBR_4]"; Text[50]) { DataClassification = SystemMetadata; }

field(6; "[ACTNUMBR_5]"; Text[50]) { DataClassification = SystemMetadata; }

field(7; "[ACTALIAS]"; Text[50]) { DataClassification = SystemMetadata; }

field(8; "[MNACSGMT]"; Text[100]) { DataClassification = SystemMetadata; }

field(9; "[ACCTTYPE]"; Integer) { DataClassification = SystemMetadata; }

field(10; "[ACTDESCR]"; Code[100]) { DataClassification = SystemMetadata; }

field(11; "[PSTNGTYP]"; Integer) { DataClassification = SystemMetadata; }

field(12; "[ACCATNUM]"; Integer) { DataClassification = SystemMetadata; }

field(13; "[ACTIVE]"; Integer) { DataClassification = SystemMetadata; }

field(14; "[TPCLBLNC]"; Integer) { DataClassification = SystemMetadata; }

field(15; "[DECPLACS]"; Integer) { DataClassification = SystemMetadata; }

field(16; "[FXDORVAR]"; Integer) { DataClassification = SystemMetadata; }

field(17; "[BALFRCLC]"; Integer) { DataClassification = SystemMetadata; }

field(18; "[DSPLKUPS]"; Decimal) { DataClassification = SystemMetadata; }

field(19; "[CNVRMTHD]"; Integer) { DataClassification = SystemMetadata; }

field(20; "[HSTRCLRT]"; Decimal) { DataClassification = SystemMetadata; }

field(21; "[NOTEINDX]"; Decimal) { DataClassification = SystemMetadata; }

field(22; "[CREATDDT]"; DateTime) { DataClassification = SystemMetadata; }

field(23; "[USERDEF1]"; Text[100]) { DataClassification = SystemMetadata; }

field(24; "[USERDEF2]"; Text[100]) { DataClassification = SystemMetadata; }

field(25; "[PostSlsIn]"; Integer) { DataClassification = SystemMetadata; }

field(26; "[PostIvIn]"; Integer) { DataClassification = SystemMetadata; }

field(27; "[PostPurchIn]"; Integer) { DataClassification = SystemMetadata; }

field(28; "[ADJINFL]"; Integer) { DataClassification = SystemMetadata; }

field(29; "[INFLAREV]"; Integer) { DataClassification = SystemMetadata; }

field(30; "[INFLAEQU]"; Integer) { DataClassification = SystemMetadata; }

field(31; "[ACCTENTR]"; Integer) { DataClassification = SystemMetadata; }

field(32; "[USRDEFS1]"; Integer) { DataClassification = SystemMetadata; }

field(33; "[USRDEFS2]"; Integer) { DataClassification = SystemMetadata; }

field(34; "[Clear_Balance]"; Integer) { DataClassification = SystemMetadata; }

field(35; "[Workflow_Status]"; Integer) { DataClassification = SystemMetadata; }

field(36; "[DEX_ROW_TS]"; DateTime) { DataClassification = SystemMetadata; }

field(37; "[DEX_ROW_ID]"; DateTime) { DataClassification = SystemMetadata; }

}

keys

{

key(Key1; "[ACTINDX]") { Clustered = true; }

}

The action "Manage Custom Tables" opens up Migration Table Mapping page.

I started the migration but the migration for this table failed:

When I click on Tables Failed cue I see this error:

Violation of PRIMARY KEY constraint 'TWO$GL00100$514b1439-9541-4c23-bcae-c24cd2db2231$Key1'. Cannot insert duplicate key in object 'dbo.TWO$GL00100$514b1439-9541-4c23-bcae-c24cd2db2231'. The duplicate key value is (0).

Am I missing any other steps in order to bring this GP table in?

Thank you!

Community site session details

Bring GL00100 table in BC from GP

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the January Top 10 Community Leaders

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

Featured topics

Product updates