Hi,
I am working through “Work with tables in Dynamics 365 Business Central” and at this point (docs.microsoft.com/.../11-exercise).
I am working in a SANDBOX environment and using VSC. Symbols have downloaded and there are no Problem shown in VSC.
I am receiving at error:
Something went wrong.
Cannot find table 50100. The metadata object Table 50100 was not found.
It seems that there is also the need to create a page to display the table (community.dynamics.com/.../metadata-object-table-xxxx-not-found-bc-saas) , but this is not listed in the learning module and before I get too far on a wrong track would appreciate any feedback toward solution. See files below.
Thanks.
Course.Table.al
table 50100 CompanyCourse
{
DataClassification = CustomerContent;
Caption = 'Course';
fields
{
field(10; "Code"; Code[20])
{
DataClassification = CustomerContent;
Caption = 'Code';
}
field(20; "Name"; Text[30])
{
DataClassification = CustomerContent;
Caption = 'Name';
}
field(30; "Description"; Text[50])
{
DataClassification = CustomerContent;
Caption = 'Description';
}
field(40; "Type"; Option)
{
OptionMembers = "Instructor Led","e-Learning","Remote Training";
OptionCaption = 'Instructor Led, e-Learning, Remote Training';
DataClassification = CustomerContent;
}
field(50; "Duration"; Decimal)
{
DataClassification = CustomerContent;
Caption = 'Duration';
}
field(60; "Price"; Decimal)
{
DataClassification = CustomerContent;
Caption = 'Price';
}
field(70; "Active"; Boolean)
{
DataClassification = CustomerContent;
Caption = 'Active';
}
field(80; "Difficulty"; Integer)
{
DataClassification = CustomerContent;
Caption = 'Difficulty';
}
field(90; "Passing Rate"; Integer)
{
DataClassification = CustomerContent;
Caption = 'Passing Rate';
}
field(100; "Instructor Code"; Code[20])
{
DataClassification = CustomerContent;
Caption = 'Instructor Code';
TableRelation = Resource where(Type = const(Person));
}
}
keys
{
key(PK; "Code")
{
Clustered = true;
}
key(key1; "Instructor Code")
{
Clustered = false;
}
key(key2; "Type")
{
Clustered = false;
}
}
}
app.json
{
"id": "XYZ",
"name": "CourseMgmt1",
"publisher": "Company Inc",
"version": "1.0.0.0",
"brief": "",
"description": "",
"privacyStatement": "",
"EULA": "",
"help": "",
"url": "",
"logo": "",
"dependencies": [],
"screenshots": [],
"platform": "17.0.0.0",
"application": "17.0.16993.0",
"idRanges": [
{
"from": 50100,
"to": 50149
}
],
"showMyCode": true,
"runtime": "6.0"
}
launch.json
{
"version": "0.2.0",
"configurations": [
{
"name": "Microsoft cloud sandbox",
"request": "launch",
"type": "al",
"environmentType": "Sandbox",
"environmentName": "TEST-SANDBOX",
"startupObjectId": 50100,
"startupObjectType": "Table",
"breakOnError": true,
"launchBrowser": true,
"enableLongRunningSqlStatements": true,
"enableSqlInformationDebugger": true
}
]
}
