Date Effective Patterns (White paper)

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

This white paper describes how to use date effective tables, also known as valid time state tables, to store and track object history in Microsoft Dynamics AX 2012.

Topics include:

  • The difference between the two types of valid time state tables

  • How valid time state tables are integrated with the security framework

  • Various update modes

  • How to use the validtimestate keyword in queries

  • Runtime behaviors

  • Scenarios that are not supported by the framework

The paper also suggests design patterns for forms that use valid time state tables.

Download the paper.