add new fields or columns

(0) Share

Report

Posted on by developerCc

Good afternoon community, I would like to ask: if I wanted to add a new column to the products table, could I do it? One in which I define its use.
Yes, it is so, how?

All responses (6)

Answers (1)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: add new fields or columns

Hi, Hope the link below can give you some hints/

https://yzhums.com/21735/

Thanks.

ZHU
developerCc 15 on at

Like (0)

Report

RE: add new fields or columns

Hello, good afternoon, as recommended, I started to get into development with AL, but when I wanted to execute a very simple code (docs.microsoft.com/.../introduction-development-process /5-exercise)

I get this error: "Could not download symbols. Please see the Visual Studio Code output log for more details."

I was also reading that the changes you make will be done in the sandbox not in the production environment.

Could you explain to me how to start developing with AL and that these changes are seen in the production environment, please.

First of all, Thanks.
Janarthananv 87 on at

Like (1)

Report

RE: add new fields or columns

Dear @DeveloperCc,

Please try with the following code for adding a new field in Business Central.

tableextension 50100 "My new item feild" extends Item

{

fields

{

field(50101; "dropboxtest"; Decimal)

{

Caption = 'Drop Box Value';

DataClassification = ToBeClassified;

}

field(50102; Newfield; Integer)

{

Caption = 'Input';

DataClassification = CustomerContent;

}

field(50103; "Test"; Option)

{

Caption = 'Value Option';

DataClassification = ToBeClassified;

OptionMembers = "Value1","Value2";

}

field(50104; Instructorcode; Code[25])

{

Caption = 'Instructor File';

DataClassification = ToBeClassified;

TableRelation = Resource where(Type = const(Person));

}

field(50105; DateOfBirth; Date)

{

Caption = 'Date Of Birth';

DataClassification = ToBeClassified;

}

}

}

pageextension 50100 "Field on item card" extends "Item Card"

{

layout

{

addfirst(InventoryGrp)

{

field(dropboxtest; Rec."dropboxtest")

{

ApplicationArea = all;

}

}

addfirst(InventoryGrp)

{

field(Newfield; Rec.Newfield)

{

ApplicationArea = all;

Importance = Additional;

}

}

addfirst(InventoryGrp)

{

field(Test; Rec.Test)

{

ApplicationArea = all;

ShowMandatory = true;

}

}

addfirst(InventoryGrp)

{

field(Instructorcode; Rec.InstructorCode)

{

ApplicationArea = all;

}

}

addlast(InventoryGrp)

{

field(DateOfBirth; Rec.DateOfBirth)

{

ApplicationArea = all;

}

}

}

actions

{

}

}

Thanks,

Janarthanan.v
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (1)

Report

RE: add new fields or columns

Hi,

Yes by using of Visual Studio code with AL language development you can do that, please follow the links as Zhu mentioned.

Thanks.
Verified answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

RE: add new fields or columns

Hi, You need to use tableextension and pageextension.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-table-ext-object

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-page-ext-object

And just adding some BC development study material.

Get started with development in Microsoft Dynamics 365 Business Central

Learn the application foundation with the AL programming language for Microsoft Dynamics 365 Business Central

Discover the foundation of customizing Microsoft Dynamics 365 Business Central

Build reports for Microsoft Dynamics 365 Business Central (Report)

Learn about the data management foundation in Microsoft Dynamics 365 Business Central (XMLports & Query)

Tailor roles and design the UI for Microsoft Dynamics 365 Business Central (Role, Assisted Setup, Notification, UI)

Work with essential development standards for Microsoft Dynamics 365 Business Central

Hope this helps.

Thanks.

ZHU
Suggested answer

MahGah 15,428 on at

Like (1)

Report

RE: add new fields or columns

Hi

Please see this article www.cloudfronts.com/.../

Or you can see Simple Object Designer www.hougaard.com/.../