In addition to the default fields available in tooltip, label, and table text, it is possible to equip custom fields with data to use them in tooltip, bar label, and table text.
By opening the VJS, the Dynamics 365 BC data tables (containing the necessary data for the visualization) are copied automatically into the extension one to one as so-called SIM (Simulation) data tables and from there are taken to be visualized in the VJS. This means that every scheduling action or modification you carry out in the VJS first impacts the simulation and only when you press the "Save" button the data will be written back to BC.
These Dynamics 365 BC data tables copied into SIM data tables are
- Jobs => "NETVJS SIMJob"
- Job Planning Lines => "NETVJS SIMJobPlanningLine"
- Job Tasks => "NETVJS SIMJobTask"
So if you want to have additional data fields showing in tooltip, label or table text, you have to create
- a table extension for adding the field to the BC table
- a table extension for adding the field to the SIM table
- if necessary: a page extension for populating the field with data
-
The BC table extension
The extension for the BC table adds the custom data field to the BC table:
tableextension 60001 JobBCExt extends Job
{
fields
{
field(60000; "CustomField"; Code[20])
{
DataClassification = CustomerContent;
}
}
}
-
The simulation table extension
With this extension, the custom field you have added to the BC table gets added to the SIM table accordingly .
Please note that the data fields numbers have to be identical.
tableextension 60000 JobExt extends "NETVJS SIMJob"
{
fields
{
field(60000; "CustomField"; Code[20])
{
DataClassification = CustomerContent;
}
}
}
-
Population of the BC data field by page extension
Once your field is created it needs to be filled with values. This can be done either by code or by a page extension like shown below:
pageextension 60002 "Job" extends "Job Card"
{
layout
{
addlast(General)
{
field("CustomField"; "CustomField")
{
ApplicationArea = All;
}
}
}
}
How to proceed
Step 1
- Open Visual Studio Code and add a new project with a new al. file.
- Create the extension(s) you need like described above. Please note that the two data fields must have the same id.
Step 2
The file app.json should contain the dependency for the VJS :
"dependencies": [
{
"appId": "9a08bc1f-7ac9-4671-b212-9076b2869e80",
"name": "Visual Jobs Scheduler",
"publisher": "NETRONIC Software GmbH",
"version": "x.x.x.x"
}
Step 3
Publish your extensions and the newly added data field will be listed in the configuration for tooltip, label or table text.
Result
