Hi,
I want to ask if anyone have any experience in creating a functionality that would allow user to:
keep history of dimension value changes on master data tables and allow to enter new dimension value that is valid for a given time range.
What I want to accomplish is to create a generic solution for all master tables that would allow storing default dimension values with time range. At the same time I would like to minimize the number of modifications in AX code.
Do you have any experience in building such framework?
What would you suggest as best entry points in the application code.
Best regards,
Sebastian
*This post is locked for comments
I have the same question (0)Hi Sebastian,
You can create a single table storing default dimension field with also a table and record reference. In addition it needs to have a start and end date. (Effective from and to)
The wish to prevent the number of objects involved is not possible. On every point where the default dimension is used, you need to check in this table if there is a date effective default dimension available. In several methods it is just doing a call like this:
salesTable.DefaultDimension = _custTable.DefaultDimension.
So in fact it is just copying an integer value.
Also you need to check how the current default dimensions are managed on forms. The forms does not have the controls. These are dynamically added when opening the form.
This will be not an easy customization...