RE: Financial Dimension values the active from / active to field has default value and mandatory
Hi Simon,
It is logical to have default no dates. Of course, you can default values, but that is probably not compatible with the backing end dimension values such as departments, item groups, etc. You have to check that.
On the insert method of the table with dimension values, you can try to add logic to set the two dates. Note that you will have additional effort when you need to extend the validity of the values.
I would strongly advice against making this fields mandatory as the table holding the data is used for dimensions and main accounts; both for global level as well as company specific.