ax_gfm_framework_team: Ledger account combinations - Part 4 (Advanced rules)
Continuing this series of blog posts, we will cover the Advanced Rules region highlighted in pale yellow in the model below in figure 1.
While account structures and constraints allow the user to build very simple to very complex trees of valid combinations, sometimes the business requirements are to only show a dimension as a segment in an ledger account combination only at certain times rather than just constrain the valid values allowed showing it all the time. The use of advanced rules supports this requirement.
Advanced rules can be added to an account structure and its constraints. While versatile, there are guidelines when they should and should not be used for best usability, performance and understanding:
Assuming the following account structure is set up:
Let’s assume that a new advanced rule is needed to optionally add a segment (or segments) only if the user has entered main account 145 and customers G thru Q:
Once the rule is configured, a structure and constraint definition needs to be created to define what segments to add to the ledger account combination. This is done by creating a new rule structure, similar to how an account structure is created. These structures are not immediately bound to the rule, and as such can be shared across multiple rules if necessary.
After the structure is created, it is added onto the dimension rule, and the account structure along with the rule is then activated:
The storage of this data uses some of the same tables as the storage of the account structures discussed in the previous post. The DimensionRule, DimensionRuleAppliedHierarchy and DimensionRuleCriteria tables hold the data specific to the definition of the rule and the link to the definition of the rule structures. The rest of the tables are shared with the account structure definition:
Examples of the effects of these rules, rule structures, segments and constraints on the entry of a ledger dimension account will be explained in the next blog post when we begin discussing entry of ledger account combinations and their storage.
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
|ax_gfm_framework_team: Ledger account combinations - Part 6 (Ledger dimensions (B))||Blog bot||DAX Blogs||0||16.02.2013 08:08|
|ax_gfm_framework_team: Ledger account combinations - Part 7 (Advanced topics)||Blog bot||DAX Blogs||0||16.02.2013 08:08|
|ax_gfm_framework_team: Ledger account combinations - Part 5 (Ledger dimensions (A))||Blog bot||DAX Blogs||0||16.02.2013 08:08|
|dynamicsaxtraining: Purchase||Blog bot||DAX Blogs||0||11.03.2012 05:25|
|emeadaxsupport: New Content for Microsoft Dynamics AX 2012 : October 2011||Blog bot||DAX Blogs||0||27.10.2011 17:11|
|Опции темы||Поиск в этой теме|