How to create a tracking dimension in D365 F&O?
When we have a close look at the InventDim table, the fields can be split up in 3 groups. These 3 groups are already represented in the existing field groups.
The investigation
As you can see there are also Russian localization field in it, those can be turned off with the configuration key “Invent tracking dimensions – GTD, inventory profile, owner.”
So now how doe we add new tracking dimensions? There is a good documentation Add new inventory dimensions through extension – Finance & Operations | Dynamics 365 | Microsoft Docs
On the end there is an explanation how to add the predefined field to the product dimensions.
It is a good article with also an example code, but it will not work incase you want only a tracking dimension. To get that job don I investigated the tracking dimension Batch. The key trick for your new tracking dimension is to create a new extension of the InventTrackingDimension Class. Below picture shows the current extensions.
Lets do it
The next step is creating table extensions on the next 2 tables:
- InventDim
– Add the InventDimension1 to the field group Tracking Dimension.
– Create a new relation from the InventDimension1 to your new lookup table (below example the table name is XXTable) - InventDimParm (Display settings)
– Add the InventDimension1Flag to the field group Tracking Dimension. - Create and EDT extension for the correct labels on:
– InventDimension1
– InventDimension1Flag
So those where the easy steps. Now we start coding. The next step is creating an (COD)extension on the next 3 tables:
And finally, the new extended class from InventTrackingDimension
The whole solution would look like something like this:
The results
And of course, do not forget to turn on the configuration key for InventDimension1, testing would be impossible with out ???? The next screen dumps show the look and feel. As you also see the Owner field is still there, I guess MS has forgotten to add a configuration key to it…
