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

what table field add to item card ? (not tableextension add)

(0) Share

Report

Posted on by SHI_IT

My project ID limit

I need reduce use

I need try table field add to item card(page),

But fail

I need help

Thanks!

Leo Liu

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

Can you please share the screen shot? where you are getting the errors?

Thanks.

Was this reply helpful? Yes No
SHI_IT 5 on at

Like (0)

Report

Not code error

Is Idea error

I need table field add to item card new field, (reduce ID use)

But I don`t have idea

Thanks!

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

Hello

your request is not very clear

can you be more precise?

do you want to add a new field of the Item table to the relative PAGE Item Card?

if so said, extend the page of the article card and insert the new field.

I don't know if you mean this, otherwise you should give us one more example

Daniele

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report
Hello SHI_IT.

I guess you want to add the table extension field in item card page..

To add the field in item table

tableextension 50101 itemTableExtension extends Item { fields { field(50100; YourField; Code[20]) { DataClassification = ToBeClassified; } } }

Then make the extension of the Item Card Page.

pageextension 50103 CustomerCardExtension extends "Item Card" { layout { addbefore(Item) { group(MyGroup) { Caption = 'My Group'; field(myField; Rec."myField") { ApplicationArea = All; Importance = Standard; Caption = 'My Field'; } } } } }

Thanks and Regards.

People

Was this reply helpful? Yes No
Suggested answer

Amit 2,559 on at

Like (0)

Report

Hi,

Refer the below link

https://erpconsultors.com/add-field-in-existing-table-using-extension/

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Suggested answer

SHI_IT 5 on at

Like (0)

Report
THANKS ALL

My question

I got the solution

------CODE------

pageextension 60071 testpageext extends "Item Card" //page add table to Item Card { layout { addlast(Item) //add ITEM category { field(LPK; Leo_P.Leo_PK1) //got Leo_P.Leo_PK1 { ApplicationArea = all; Caption = 'test1_PK'; } } } var //call value load Table:Leo_table_TEST Leo_P: Record Leo_table_TEST; } //-------------------------------------------------------------------------------- table 60072 "Leo_table_TEST" // Customize Table { Caption = 'Leo_table_TEST'; //DataClassification = CustomerContent; fields { field(1; Leo_PK1; Code[30]) { Caption = 'Leo_PK1'; DataClassification = ToBeClassified; } field(2; Leo_PK2; Code[30]) { Caption = 'Leo_PK2'; DataClassification = ToBeClassified; } field(3; leo_ITEM; Code[30]) { Caption = 'leo_ITEM'; DataClassification = ToBeClassified; } field(4; leo_head; text[30]) { Caption = 'leo_head'; DataClassification = ToBeClassified; } field(5; leo_line; text[30]) { Caption = 'leo_line'; DataClassification = ToBeClassified; } field(6; "leo_test_BOX"; Code[30]) { Caption = ''; DataClassification = ToBeClassified; } field(7; "leo_test_ITEM"; Code[30]) { Caption = ''; DataClassification = ToBeClassified; } } keys { key(PK; Leo_PK1, Leo_PK2) { Clustered = true; } } }

Was this reply helpful? Yes No