The Infolog

A blog of Dynamics AX development tips and tricks

Skip to: Content | Sidebar | Footer

Using date effective tables in a view

7 May, 2014 (14:13) | Dynamics AX | By: Howard Webb

When writing a select statement or using a query you do not have to worry about if the table is a date effective table or not, the frame work handles this for you and will as default return the record that is current. If you are using a view however you need to do a bit more work to get your view to get a single record out.


Firstly you need to locate the date effective table in your view and then move the ValidTo and ValidFrom fields in to the fields list:



With that done. Bring up the properties of the view and at the bottom you will see the following which you need to set to yes:



This will make your view respect the date effective settings on the table.



Please note: you will only see the effects of this within the form, not within table browser.

Print Friendly, PDF & Email