Share
ReportHello all ,
how to write visual studio code for create new page in 365 bc ?i want to create new page like below screenshot file for 365 bc
You’re offline. This is a read only version of the page.
339
Hello all ,
how to write visual studio code for create new page in 365 bc ?i want to create new page like below screenshot file for 365 bc
Exactly like I've done in the first field of the table definition I've posted. I don't know what table you want to refer but the key is TableRelation = .....
Hello stefano ,
Thank you very much for this
but how to add table relation of below respective fields,i need table relation of this
field(2;"Bill Code"; Code[20])
{
DataClassification = CustomerContent;
}
field(3;"Control Account"; Code[20])
{
DataClassification = CustomerContent;
}
field(4;"Percentage"; Decimal)
{
DataClassification = CustomerContent;
}
Something like:
Table:
table 50100 MyTable
{
DataClassification = ToBeClassified;
fields
{
field(1;"Account Category Code"; Code[20])
{
DataClassification = CustomerContent;
TableRelation = "G/L Account Category";
}
field(2;"Bill Code"; Code[20])
{
DataClassification = CustomerContent;
}
field(3;"Control Account"; Code[20])
{
DataClassification = CustomerContent;
}
field(4;"Percentage"; Decimal)
{
DataClassification = CustomerContent;
}
}
keys
{
key(PK; "Account Category Code")
{
Clustered = true;
}
}
}
LIST PAGE:
page 50100 MyList
{
PageType = List;
ApplicationArea = All;
UsageCategory = Lists;
SourceTable = MyTable;
layout
{
area(Content)
{
repeater(Group)
{
field("Account Category Code"; "Account Category Code")
{
ApplicationArea = All;
}
field("Bill Code"; "Bill Code")
{
ApplicationArea = All;
}
field("Control Account"; "Control Account")
{
ApplicationArea = All;
}
field(Percentage; Percentage)
{
ApplicationArea = All;
}
}
}
}
}
A list pag has automatically the features to edit record and to export it in an Excel file.
Install the AL language extension, then start a new AL project by typing AL:Go! from command palette.
You need to create a table object (snippet ttable), then a list page object (snippiet tpage) and then add the fields you want to that page.
Start from here:
All responses (
Answers (
