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?
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.
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
Hi,
Yes by using of Visual Studio code with AL language development you can do that, please follow the links as Zhu mentioned.
Thanks.
Hi, You need to use tableextension and pageextension.
And just adding some BC development study material.
Get started with development in 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
Hi
Please see this article www.cloudfronts.com/.../
Or you can see Simple Object Designer www.hougaard.com/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148