The following field must be included into the table's primary key: Field: Description Table: G/L Account Category ?

(0) Share

Report

Posted on by SABIH

339

Hello all ,

"The following field must be included into the table's primary key: Field: Description Table: G/L Account Category."When adding the description in the respective field got error please find below screenshot

please see below my vs code

table 50105 CutBackTable
{
DataClassification = ToBeClassified;

fields
{

field(1; "Account Category Code"; Text[250])
{
DataClassification = CustomerContent;
TableRelation = "G/L Account Category".Description;
//TableRelation = "G/L Account Category".Description;


}
field(2; "Bill code"; Code[20])
{
DataClassification = CustomerContent;
//TableRelation = "Dimension Value".Code where ("Dimension Code" = field ("Bill code"));
TableRelation = "Dimension Value".Code;
//where ("Dimension Code" = field ("Bill code"), Code = field ("Control Account"));

}
field(3; "Control Account"; Code[20])
{
DataClassification = CustomerContent;
TableRelation = "G/L Account";
}
//field(4; "Percentage"; Decimal)
//{


//DecimalPlaces = 2 : 2;
//DataClassification = CustomerContent;
//OptionMembers =default;
// MinValue = 0;
//MaxValue = 100;

//}
field(4; "Percentage"; Option)
{
//DataClassification = ToBeClassified;
Caption = 'Percentage';
OptionMembers = " ","Working Interest","Paying Interest","Revenue – Cost Oil","Revenue – Profit Oil";
}
//field(id; MyField; Option)
//{
// DataClassification = ToBeClassified;
// OptionMembers =

//}


}

keys
{
key(PK; "Bill code")
{
//Clustered = true;
}
}

}

have any solution for this

Categories:

Documentation

Other

Opportunity Management

Web and mobile experience

Reports and Business Intelligence

Data Migrations

Geographies and Localization

Inventory and warehouse management

Purchasing

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

NAV_BC_Developer 4 on at

Like (0)

Report
Copy link

Link copied!

it is more helpful...

I was facing with same problem.

through this my issue is resolved

very thanx

Was this reply helpful? Yes No
Nadeem Shah 10 on at

Like (0)

Report
Copy link

Link copied!

Hi SABIH

You will add Description field into Keys
click on Views select keys and add Description as a primary key .

Was this reply helpful? Yes No
jor1hp 80 on at

Like (2)

Report
Copy link

Link copied!

HI, you can try with on the field

ValidateTableRelation = false;

Was this reply helpful? Yes No
SABIH 339 on at

Like (0)

Report
Copy link

Link copied!

Hi Stefano Demiliani ,

Actually i dont know how to find table of "G/L Account Category table" from the respective form (G/L Account Category)

could you please tell me how to find table of respective forms ,for example i want to find G/L Account Category forms table

Was this reply helpful? Yes No
SABIH 339 on at

Like (0)

Report
Copy link

Link copied!

HI Stefano Demiliani ,

But our client need "description" what will do ,have any other solution for this

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

TableRelation cannot be set as TableRelation = "G/L Account Category".Description because Description is not a key field.

I don't know how your G/L Account Category table is defined but I suspect that you have a key field like No. or Code and so your tablerelation should be set as:

TableRelation = "G/L Account Category"."No.";

Was this reply helpful? Yes No