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

Write a comment