tag:blogger.com,1999:blog-20330618589014627812024-03-16T12:09:13.175+05:00Dynamics AX - Development Blogname is Arsalan Gulzar and the intent to create this blog is to discuss the problems and issues that developer face in the dynamics AX development and to share the new things that come up with the new version of AX.Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.comBlogger52125tag:blogger.com,1999:blog-2033061858901462781.post-40363217570263597122013-03-20T06:06:00.003+05:002013-03-20T06:06:31.329+05:00How to install Adventure Works SQL DW database and Analysis Services 2005/2008 Sample database<div dir="ltr" style="text-align: left;" trbidi="on">
I have found a very useful link to install the Adventure works database for SQL Server 2005/2008, please check the following link to install it.<br />
<br />
<a href="http://www.ssas-info.com/analysis-services-faq/29-mgmt/242-how-install-adventure-works-dw-database-analysis-services-2005-sample-database">http://www.ssas-info.com/analysis-services-faq/29-mgmt/242-how-install-adventure-works-dw-database-analysis-services-2005-sample-database</a></div>
Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-18026598043548545282012-04-04T20:56:00.000+05:002012-04-04T20:56:13.502+05:00searching tools fileseek<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">I would like
to share a very good searching tool (fileseek) that I am using for search the
data in my Dynamics AX enlistment, you can find more detail using the link <a href="http://www.fileseek.ca/"><span style="color: blue;">http://www.fileseek.ca/</span></a>. This tool can be
used a replacement of the cross reference functionality in AX, but you should
have the enlistment for that particular branch<o:p></o:p></span><br />
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-50712391931059268122012-04-04T15:55:00.000+05:002012-04-04T15:55:07.849+05:00some Dynamics Axapta FAQs<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: x-small;"><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<strong><span style="font-family: Calibri;">1 . Breakpoint in
clicked method </span></strong><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><br /><span style="font-family: Calibri;">
</span></span><span style="font-family: Calibri;"><span style="font-size: 10pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";">There is quite
well known bug in AX that breakpoint placed in the clicked() method of a button
will not be triggered. It is quite unpleasant one since when one faces it first
time he gets totally confused. However, there are easy workarounds for this
bug. First one – put breakpoint into the method that is called from clicked (in
most cases it is possible). But if not, keyword breakpoint can be used – it
will be triggered in clicked() method. </span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></span></div>
<span style="font-family: Times New Roman; font-size: small;">
</span>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<br />
<span style="font-family: Calibri;">
<strong>2. Global::isType
</strong></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><span style="font-family: Calibri;">
</span></span><span style="font-size: 10pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><span style="font-family: Calibri;">The easiest way
to determine if an EDT extends another EDT (not necessarily directly) is to use
Global::isType() method.<br />
<br />
For example:<br />
</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-size: 10pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><span style="font-family: Calibri;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">isType(extendedtypenum(PurchUnit),
extendedtypenum(UnitIDBase));</span><br />
give true, since PurchUnit extends UnitID, which extends UnitIDBase.<br />
</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-size: 10pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><span style="font-family: Calibri;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">isType(extendedtypenum(ABCModelType),
extendedtypenum(NoYesId));</span></span></span><br />
<span style="font-size: 10pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><span style="font-family: Calibri;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"></span>gives false, since ABCModelType and NoYesId are in different hierarchies. <o:p></o:p></span></span></div>
<span style="font-family: Times New Roman; font-size: small;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<strong><span style="font-family: Calibri;">3. Delete actions
and multiple relations <o:p></o:p></span></strong></div>
<span style="font-family: Times New Roman; font-size: small;">
</span>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 6pt;">
<span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><span style="font-family: Calibri;">
</span></span><span style="font-family: Calibri;"><span style="font-size: 10pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";">If one table has
several relations to another table delete action will not work properly. In
such case delete action will be triggered for only one of the relations. So, in
the case of multiple relations one should write his own cascading or
restricting logic in the delete method. An example can be found in Unit and
UnitConvert tables. UnitConvert table has two relations to the Unit table –
from unit and to unit. Table Unit has cascading delete action for the
UnitConvert table. However, if a unit will be deleted, only unit conversions
with from unit equal to the deleted one will be deleted. Conversions with to
unit equal to the deleted one will survive. Example of correct implementation
can be found in InventTestEmplResponsible and EmplTable. EmplTable has delete
method overridden to perform manual delete in the InventTestEmplResponsible
table.</span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></span></div>
<span style="font-family: Times New Roman; font-size: small;">
</span></span></div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-60851436664512440662012-04-04T15:47:00.000+05:002012-04-04T15:48:03.662+05:00SSAS – OLAP – SSRS Report using OLAP<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial, Helvetica, sans-serif;">I have created a </span><a href="https://docs.google.com/presentation/d/1K9-fXFQdBhkvx5nBeYFs0mAyyhn8Ibf0e7MQO8TgXMU/edit?pli=1#slide=id.p16"><span style="font-family: Arial, Helvetica, sans-serif;">presentation</span></a><span style="font-family: Arial, Helvetica, sans-serif;"> regarding the SSAS and OLAP in Dynamics AX</span><br />
<br />
<div style="margin-left: 0.25in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>SSAS </span></div>
<div style="margin-left: 0.75in; mso-list: l0 level2 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: "Courier New"; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>OLAP</span></div>
<div style="margin-left: 1.25in; mso-list: l0 level3 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;"><span style="mso-list: Ignore;">§<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>Cube</span></div>
<div style="margin-left: 1.75in; mso-list: l0 level4 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>Measure</span></div>
<div style="margin-left: 1.75in; mso-list: l0 level4 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>Dimensions</span></div>
<div style="margin-left: 1.25in; mso-list: l0 level3 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;"><span style="mso-list: Ignore;">§<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>Perspective </span></div>
<div style="margin-left: 0.75in; mso-list: l0 level2 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: "Courier New"; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>BIDS</span></div>
<div style="margin-left: 0.75in; mso-list: l0 level2 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: "Courier New"; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>MDX Queries</span></div>
<div style="margin-left: 0.75in; mso-list: l0 level2 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: "Courier New"; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>Reports </span></div>
<div style="margin-left: 1.25in; mso-list: l0 level3 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;"><span style="mso-list: Ignore;">§<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>KPI</span></div>
<div style="margin-left: 1.25in; mso-list: l0 level3 lfo1; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;"><span style="mso-list: Ignore;">§<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span>Miscellaneous<o:p></o:p></span></div>
<span style="font-family: Arial, Helvetica, sans-serif;">
</span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Feel free to contact me for any questions.</span></div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com9tag:blogger.com,1999:blog-2033061858901462781.post-5384499285367627072012-02-07T17:03:00.002+05:002012-02-07T17:03:28.598+05:00default index for a table in AX / X++<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="margin-left: 0.25in;">
<span style="color: #333333; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Question: What is the default index for a table ?</span><br />
<br />
<span style="color: #333333; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Microsoft Dynamics AX requires a unique index on each table. If there are no indexes on a table or all the indexes are disabled, a system index is automatically created. The system index is created on the RecId and DataAreaId fields if the DataAreaId field exists. Otherwise, the system index is created on the RecId field. You can see system indexes in the database, but they aren't visible in the AOT. <o:p></o:p></span></div>
<span style="color: #333333; font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-22377684730726055852012-02-07T04:37:00.005+05:002012-02-07T04:37:52.698+05:00get values of base enums using code in x++<div dir="ltr" style="text-align: left;" trbidi="on">
<span lang="EN-GB" style="font-family: "Calibri","sans-serif"; font-size: 11pt;">Question: How
to get<span style="mso-spacerun: yes;"> </span>values of base enums using code
in x++<o:p></o:p></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<b><span lang="EN-GB" style="color: darkblue; font-family: Consolas; font-size: 8pt;">static</span></b><span lang="EN-GB" style="color: black; font-family: Consolas; font-size: 8pt;"> </span><b><span lang="EN-GB" style="color: darkblue; font-family: Consolas; font-size: 8pt;">void</span></b><span lang="EN-GB" style="color: black; font-family: Consolas; font-size: 8pt;">
getEnumValues(Args _args)</span><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; font-size: 11pt;"><o:p></o:p></span></div>
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;">{</span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span>EnumId <span style="mso-spacerun: yes;"> </span>enumId <span style="mso-spacerun: yes;"> </span>= <b><span style="color: darkblue;">enumNum</span></b>(LedgerDimensionType);</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span>DictEnum dictEnum = <b><span style="color: darkblue;">new</span></b> DictEnum(enumId);</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">int</span></b>
<span style="mso-spacerun: yes;"> </span>count <span style="mso-spacerun: yes;"> </span>= dictEnum.values();</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">int</span></b>
<span style="mso-spacerun: yes;"> </span>counter</span><span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">for</span></b>(counter
= <b><span style="color: red;">0</span></b>; counter < count; counter ++)</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span>{</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span>// You can use the number of method
exposed by <a href="http://msdn.microsoft.com/en-us/library/aa864605(v=ax.50).aspx"><span style="color: blue;">DictEnum</span></a>
class</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;">// dictEnum.name(counter)</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;">// dictEnum.index2Value(counter) </span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;">// dictEnum.index2Symbol(counter)<span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;">// dictEnum.index2Label(counter)</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span>}</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 8pt;">}</span><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; font-size: 11pt;"><o:p></o:p></span></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com14tag:blogger.com,1999:blog-2033061858901462781.post-24048731130217759572012-02-07T03:56:00.000+05:002012-02-07T03:56:19.326+05:00List in X++ / Dynamics AX<div dir="ltr" style="text-align: left;" trbidi="on">
<b style="mso-bidi-font-weight: normal;"><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;">List</span></b><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;"> is a
type of data structure and collections, it can contain unlimited items, in x++,
list can be created of several Types(specified in the Types base enum), the
type must be specified on the declaration and it cannot be changed after the
initialization. <o:p></o:p></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt; text-align: justify;">
<span lang="EN-GB" style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;">There are some classes exists to enumerated and iterate the list object.</span><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;"> </span><b style="mso-bidi-font-weight: normal;"><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;">ListIterator</span></b><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;"> object has methods that can insert and
deleted items from list, </span><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;"><span style="mso-spacerun: yes;"> </span></span><b style="mso-bidi-font-weight: normal;"><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;">ListEnumeration</span></b><span lang="EN-GB" style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;"> cannot modify the list content</span><span style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;"><o:p></o:p></span></div>
<br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: "Lucida Sans","sans-serif"; mso-bidi-font-family: "Lucida Sans";">Example:<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: "Lucida Sans","sans-serif"; mso-bidi-font-family: "Lucida Sans";"><o:p></o:p></span></div>
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>List<span style="mso-spacerun: yes;"> </span>myList<span style="mso-spacerun: yes;"> </span>= new List(Types::Integer);</span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>List<span style="mso-spacerun: yes;"> </span>myListString = new
List(Types::String);</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>ListIterator<span style="mso-spacerun: yes;"> </span>literator </span><span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>// add the element at the end of the list</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>myList.addEnd(2);</span><span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>// add the element at the start of the list</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>myList.addStart(3);</span><span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>myList.addEnd(7);</span><span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>myListString.addEnd ("Second");<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>myListString.addStart ("First");</span><span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>// If you want to insert the data at some
specific index, then you need to make use of the listIterator class</span><span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>// Iterator performs a midpoint</span><span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>// insert at current position. </span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<br /></div>
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>literator = new ListIterator(myListString);</span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>while (literator.more())</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>{</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>// can provide some condition, i.e. if
check etc</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>if (literator.value() ==
"First")</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>{</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>listIterator.insert ("Between
first and second");</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>}</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: "Lucida Sans","sans-serif"; mso-bidi-font-family: "Lucida Sans";"><span style="mso-spacerun: yes;"> </span>}</span><span lang="EN-GB" style="font-family: "Lucida Sans","sans-serif"; mso-bidi-font-family: "Lucida Sans";"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span lang="EN-GB" style="font-family: "Lucida Sans","sans-serif"; mso-bidi-font-family: "Lucida Sans";"><a href="http://msdn.microsoft.com/en-us/library/cc967436.aspx"><span style="color: blue;">Comparison between
X++ and C# List</span></a><o:p></o:p></span></div>
<br />
<div class="FieldText" style="margin: 0in -15.1pt 0pt 0in;">
<br /></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com21tag:blogger.com,1999:blog-2033061858901462781.post-4854247630546614282012-02-05T02:17:00.001+05:002012-02-05T02:17:30.720+05:00How to implement Number sequence in AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Calibri;">I have read an article for creating <em>number sequence </em>in
existing and new module of AX 2012, </span><span style="font-family: Calibri;">written by a friend Amir nazim also lso there is a white paper published by microsoft for the developers.</span><br />
<br />
<span style="color: black; font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;"></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><o:p>
<span class="MsoHyperlink"><span style="font-family: "Calibri","sans-serif"; font-size: 11pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><a href="http://msdax.wordpress.com/2011/09/18/new-number-sequence-implementation-in-dynamics-ax-2012/"><span style="color: blue;">Amir's
article link</span></a><o:p></o:p></span></span></o:p></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><a href="http://go.microsoft.com/fwlink/?LinkID=213124"><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="color: blue; font-family: Calibri;">Download the paper</span></span></a></span><span style="font-family: Calibri;"><span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;">.</span><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><o:p></o:p></span></span></div>
<br />
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-79800556078914000152012-02-05T01:58:00.001+05:002012-02-05T01:58:20.803+05:00Edit Methods versus Display Methods<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-size: 16pt;"><span style="font-family: Calibri;">Display Methods:<o:p></o:p></span></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">In
some scenarios, we need to display some values derived from other columns and
those are not associated directly with the database, like Amount fields
(Unit*Price). In that case there are display methods that perform that functionality.<o:p></o:p></span></span></div>
<span style="font-size: x-small;"><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">display</span></b><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"> Amount amount()</span></span><br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;">{</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-size: x-small;"><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>AmountMST <span style="mso-spacerun: yes;"> </span>amount;</span><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></span></div>
<span style="font-size: x-small;">
</span><br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-size: x-small;"><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>amount = </span><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">this.</span></b><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">unitprice * </span><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">this</span></b><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">.quantity;</span><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></span></div>
<span style="font-size: x-small;">
</span><br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-size: x-small;"><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">return</span></b><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"> amount;</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;">}</span></span><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<span style="font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/aa595058.aspx"><span style="color: blue; font-family: Calibri;">For Further
reading</span></a></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<span style="font-size: 16pt;"><span style="font-family: Calibri;">Edit Methods:</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">In AX 2009, when reference
controls were not available, in table if there is a relation created on the
basis of recId i.e. there is a child table and it contains the record Id of the
parent Table. When that child table binds to form, (to display and select the
user friendly information from the parent table</span><a href="http://arsalanax.blogspot.com/2012/01/lookup-in-ax.html"><span style="color: blue; font-family: Calibri;">, lookup
controls</span></a><span style="font-family: Calibri;"> were used). The record Id of the user friendly value is saved on
the table with the help of the edit methods.</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">To
give an example of an edit method, we will create a new field in the CarTable
to hold the mileage of the car and have an edit method in RentalTable that
enables the users to be in the RentalTable form and still edit the field in
CarTable.<o:p></o:p></span></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">We'll
create an extended data type of type integer for the new field and call it Mileage.
Then we'll dd the field to the CarTable.<o:p></o:p></span></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">The edit method in
RentalTable will then look like this:</span></span><span style="font-size: 12pt;"><o:p><span style="font-family: Calibri;"> </span></o:p></span></div>
<br />
<span style="font-size: x-small;">//This material is copyright and is licensed for the sole use by ALESSANDRO
CAROLLO on 18th December, Chapter 4 [ 105 ]</span><br />
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-size: x-small;"><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">edit </span></b><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">Mileage mileage(</span><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">boolean</span></b><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"> _set, Mileage value)<o:p></o:p></span></span></div>
<span style="font-size: x-small;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">{<o:p></o:p></span></span><br />
<span style="font-size: x-small;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>CarTable carTable;</span></span><br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;"><span style="mso-spacerun: yes;"> </span>Mileage <span style="mso-spacerun: yes;"> </span>ret;</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
<span style="font-size: x-small;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span><i><span style="color: green; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">//
find the car records from the car table with update = true</span></i></span><br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-size: x-small;"><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>carTable = CarTable::find(</span><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">this</span></b><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">.CarId, _set);</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-size: x-small;"><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">if
</span></b><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">(_set)<o:p></o:p></span></span></div>
<span style="font-size: x-small;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></span><br />
<span style="font-size: x-small;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span></span><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">ttsbegin;</span></b><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></b></span><br />
<span style="font-size: x-small;">
</span><br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>carTable.Mileage
= value;</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>carTable.update();</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>ttscommit;<o:p></o:p></span></span></b></div>
<span style="font-size: x-small;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>}</span></span><br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;"><span style="mso-spacerun: yes;"> </span>else</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;"><span style="mso-spacerun: yes;"> </span>{</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>ret
= carTable.Mileage;</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="font-size: x-small;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></span></div>
<span style="font-size: x-small;">
</span><br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-size: x-small;"><b><span style="color: darkblue; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>return</span></b><span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";"> ret;<o:p></o:p></span></span></div>
<span style="font-size: x-small;">
<span style="color: #454545; font-family: Consolas; mso-fareast-font-family: "Times New Roman";">}</span><span class="code"><span><o:p><span style="color: #000066; font-family: Courier New;"> </span></o:p></span></span></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<span class="MsoHyperlink"><span style="font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/aa637541.aspx"><span style="color: blue; font-family: Calibri;">For Further
reading</span></a></span></span><span class="code"><span style="font-size: 12pt;"><o:p><span style="color: #000066; font-family: Courier New;"> </span></o:p></span></span></div>
<br />
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt;">
<br /></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com0tag:blogger.com,1999:blog-2033061858901462781.post-21972310570858899182012-02-04T20:12:00.002+05:002012-02-04T21:25:18.127+05:00How to use the regular expression to validate the name in X++ AX<div dir="ltr" style="text-align: left;" trbidi="on">
How to use the regular expression to validate the name<br />
<br />
<b><span style="color: darkblue; font-family: Consolas; font-size: 8pt;">public</span></b><span style="color: #454545; font-family: Consolas; font-size: 8pt;"> </span><b><span style="color: darkblue; font-family: Consolas; font-size: 8pt;">bool</span></b><span style="color: #454545; font-family: Consolas; font-size: 8pt;"> validateName(</span><b><span style="color: darkblue; font-family: Consolas; font-size: 8pt;">str</span></b><span style="color: #454545; font-family: Consolas; font-size: 8pt;"> _name)</span><br />
<span style="color: #454545; font-family: Consolas; font-size: 8pt;">{<o:p></o:p></span><br />
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="color: #454545; font-family: Consolas; font-size: 8pt;"> System.Text.RegularExpressions.Match
regExMatch;</span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<b><span style="color: darkblue; font-family: Consolas; font-size: 8pt;"> bool </span></b><span style="color: #454545; font-family: Consolas; font-size: 8pt;"> isValid;</span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
<i><span style="color: green; font-family: Consolas; font-size: 8pt;"> // verify that Name doesn’t contain bad
special character like <>:”/\|?*</span></i><br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;"> // other characters used in the regular
expression are part of regex syntax.</span></i><span style="color: #454545; font-family: Consolas; font-size: 8pt;"><o:p><span style="font-family: 'Times New Roman'; font-size: small;"> </span></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;"> </span></i><span style="color: #454545; font-family: Consolas; font-size: 8pt;">regExMatch
= System.Text.RegularExpressions.Regex::Match(_name,
@</span><span style="color: #990000;"><span style="font-family: Consolas; font-size: 8pt;">’^[^<>:"/\\|?*]*$</span><span style="font-family: Consolas; font-size: 8pt;">’</span></span><span style="color: #454545; font-family: Consolas; font-size: 8pt;">);</span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;"> </span></i></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;"> // return true if name matches the criteria
otherwise return false</span></i></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;"> </span></i><span style="color: #454545; font-family: Consolas; font-size: 8pt;">isValid
= regExMatch.get_Success();</span><i><span style="color: green; font-family: Consolas; font-size: 8pt;"> </span></i><span style="color: #454545; font-family: Consolas; font-size: 8pt;"><o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;"> </span></i><b><span style="color: darkblue; font-family: Consolas; font-size: 8pt;">return
</span></b><span style="color: #454545; font-family: Consolas; font-size: 8pt;">isValid;</span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<span style="font-family: Calibri;">}</span></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-53120499858938335472012-02-04T17:07:00.003+05:002012-02-04T17:07:51.742+05:00Data model of the dimension in AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">In
this post I will describes the data model of the ledger dimensions and we will
a scenarios that how the data is stored on the these tables</span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><span style="font-family: Times New Roman; font-size: small;">
</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"></span><a href="" name="_Toc315708945"><span style="color: #365f91;"><span style="font-family: Cambria; font-size: large;">Data
Model</span></span></a></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Times New Roman;">
</span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-1_9Py2GEzi4/Ty0dcSUqVgI/AAAAAAAAAIU/-hJJb8YuWfY/s1600/Dimensions+Data+model.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="521" src="http://3.bp.blogspot.com/-1_9Py2GEzi4/Ty0dcSUqVgI/AAAAAAAAAIU/-hJJb8YuWfY/s640/Dimensions+Data+model.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<h2 style="margin: 12pt 0in 6pt;">
<span style="font-family: Verdana; font-size: small;">Scenario: How an offset account (10110-D10-CC2) in the Lines Journal saved
in the dimension.</span></h2>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 112%; margin: 0in 0in 0pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Segmented control works with the DimensionStorage
class to create the combination<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">So; we break apart the combination into each
structure[10110 - D1] [CC2}. We first save the Account Structure portion of the
combination. Then we save the Account/Advanced Rule structure portion (as
there could be multiples added thru multiple rules). In the end, this is what
that combination will look like across all 4 tables shown in the combination
storage block in the Data model bound to the LedgerDimension.<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 112%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><o:p> </o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><a href="http://arsalanax.blogspot.com/2012/02/configure-account-structure-and.html">Configure an account structure that looks likethis:Main Account + Department</a></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><a href="http://arsalanax.blogspot.com/2012/02/configure-account-structure-and.html">Create an advanced rule attached to account structureto say that when you enter 10110 - D1 you also need to specify a CostCenter.</a></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoListParagraphCxSpFirst" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-indent: -0.25in;">
<a href="http://3.bp.blogspot.com/-h9EQqbHB09Q/Ty0fAg2wzCI/AAAAAAAAAIc/yjujkSlTyF0/s1600/segmented+entry.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="http://3.bp.blogspot.com/-h9EQqbHB09Q/Ty0fAg2wzCI/AAAAAAAAAIc/yjujkSlTyF0/s1600/segmented+entry.png" /></a><span style="color: black; font-family: "Segoe UI","sans-serif"; font-size: 9pt; line-height: 150%; mso-fareast-font-family: "Segoe UI";"><span style="mso-list: Ignore;">1.<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;"><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">An
Segmented </span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";">entry
control </span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">will look like this</span></span><span style="mso-no-proof: yes;"><v:shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f"><span style="font-family: Calibri;">
<v:stroke joinstyle="miter">
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0">
<v:f eqn="sum @0 1 0">
<v:f eqn="sum 0 0 @1">
<v:f eqn="prod @2 1 2">
<v:f eqn="prod @3 21600 pixelWidth">
<v:f eqn="prod @3 21600 pixelHeight">
<v:f eqn="sum @0 0 1">
<v:f eqn="prod @6 1 2">
<v:f eqn="prod @7 21600 pixelWidth">
<v:f eqn="sum @8 21600 0">
<v:f eqn="prod @7 21600 pixelHeight">
<v:f eqn="sum @10 21600 0">
</v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
<v:path gradientshapeok="t" o:connecttype="rect" o:extrusionok="f">
<o:lock aspectratio="t" v:ext="edit">
</o:lock></v:path></v:stroke></span></v:shapetype></span><span style="color: black; font-family: "Segoe UI","sans-serif"; font-size: 9pt; line-height: 150%;"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">2.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;"><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">As account structure configure</span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman";"> there are</span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">
2 segments that must be filled.</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">3.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Type 10110 and tabit looks like
this:10110 -</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">4.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Type D1 in the second segment and tab</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">5.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">As tab press we pick up the fact
that a rule is attached and a 3rd dimension must be added to the combinationso
it looks like this:10110 - D1 -</span></span></div>
<div class="MsoListParagraphCxSpLast" style="background: white; line-height: 150%; margin: 0in 0in 10pt 0.5in; mso-list: l1 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">6.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Now the user enters CC2and tabs
from the control 10110 - D1 - CC2</span></span><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><o:p> </o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><u><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">DimensionAttributeValueCombination:</span></u></b><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in;">
<span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"> DisplayValue: "10110 - D1 – CC2"<br />
RecId: 400</span><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><o:p> </o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><u><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">DimensionAttributeValueGroupCombination:<o:p></o:p></span></u></b></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoListParagraph" style="background: white; line-height: 150%; margin: 0in 0in 10pt 0.5in;">
<span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;"> DimensionAttributeValueCombination:
400<br />
DimensionAttributeValueGroup: 500<br />
RecID: 201</span></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><u><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-size: x-small;"><span style="font-family: Verdana;">DimensionAttributeValueGroupCombination:</span></span></span></u></b></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in;">
<span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><br /><span style="font-size: x-small;"><span style="font-family: Verdana;">
DimensionAttributeValueCombination: 400<br />
DimensionAttributeValueGroup: 501<br />
RecID: 202</span></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><u><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">DimensionAttributeValueGroup:</span></u></b><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in;">
<span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"> DimensionHierarchy: AccountStructure(MA+DEPT)<br />
RecID: 500</span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><u><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">DimensionAttributeValueGroup:<o:p></o:p></span></u></b></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in;">
<span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"> DimensionHierarchy: AdavancedRule (CC)<br />
RecID: 501<br />
</span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><u><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">DimensionAttributeLevelValue:</span></u></b><span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br />
<span style="mso-tab-count: 1;"> </span>DimensionAttributeValueGroup:
500<br />
<span style="mso-tab-count: 1;"> </span>Ordinal: 1<br />
<span style="mso-tab-count: 1;"> </span>DimensionAttributeValue->10110<br />
<span style="mso-tab-count: 1;"> </span>RecId: 601<br />
<br />
<b style="mso-bidi-font-weight: normal;"><u>DimensionAttributeLevelValue:</u></b><br />
<span style="mso-tab-count: 1;"> </span>DimensionAttributeValueGroup:
500<br />
<span style="mso-tab-count: 1;"> </span>Ordinal: 2<br />
<span style="mso-tab-count: 1;"> </span>DimensionAttributeValue->D1<br />
<span style="mso-tab-count: 1;"> </span>RecId: 602<br />
<br />
<b style="mso-bidi-font-weight: normal;"><u>DimensionAttributeLevelValue:</u></b><br />
<span style="mso-tab-count: 1;"> </span>DimensionAttributeValueGroup:
501<br />
<span style="mso-tab-count: 1;"> </span>Ordinal: 1<br />
<span style="mso-tab-count: 1;"> </span>DimensionAttributeValue->CC2<br />
<span style="mso-tab-count: 1;"> </span>RecId: 602<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin: 0in 0in 0pt;">
<span style="color: black; font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 150%; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">To insert: [10110 - D1] [CC2] we need to insert above
all records as summarized below.<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoListParagraphCxSpFirst" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo2; text-indent: -0.25in;">
<span style="color: black; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">1 record in DAVC<br />
2 Records in DAVGC (to link the full combination to each sub-group)<o:p></o:p></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo2; text-indent: -0.25in;">
<span style="color: black; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">2 records in DAVG (one for each
grouping)<o:p></o:p></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoListParagraphCxSpLast" style="background: white; line-height: 150%; margin: 0in 0in 10pt 0.5in; mso-list: l0 level1 lfo2; text-indent: -0.25in;">
<span style="color: black; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">3 records in DALV (one for each
segment)<o:p></o:p></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com0tag:blogger.com,1999:blog-2033061858901462781.post-25624147933984945622012-02-04T16:50:00.001+05:002012-02-04T17:08:40.641+05:00configure Account structure and advanced rules in ax 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Calibri;">This post is covering the following topics</span><br />
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span><span style="font-family: Calibri;">Account Structure Configuration</span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span><span style="font-family: Calibri;">Account Structure Configuration effect on GL</span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span><span style="font-family: Calibri;">Advanced Rule application on Account Structure</span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span><span style="font-family: Calibri;">Advanced rule effect on GL</span><b style="mso-bidi-font-weight: normal;"><o:p><span style="font-family: Calibri;"> </span></o:p></b></div>
<br />
<span style="font-family: Calibri;">and the target audience includes AX Administrator, functional consultant and developers/testers.</span><br />
<br />
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt; mso-add-space: auto;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-family: "Garamond","serif"; font-size: 14pt;">Configure Account Structure<o:p></o:p></span></u></b></div>
<br />
<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">GL > Setup > chart of accounts > chart
of accounts<span style="mso-tab-count: 1;"> </span></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-K6pOtmbz3yM/Ty0Y61b4b7I/AAAAAAAAAG8/vDRFW0SMl-w/s1600/AC1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="332" src="http://2.bp.blogspot.com/-K6pOtmbz3yM/Ty0Y61b4b7I/AAAAAAAAAG8/vDRFW0SMl-w/s640/AC1.png" width="640" /></a></div>
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 12pt; mso-add-space: auto;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-family: "Garamond","serif"; font-size: 14pt;"><o:p><span style="text-decoration: none;"></span></o:p></span></u></b></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">To
Configure Account Structure Click on the configure account structure as shown
in the above snap shot. </span></span></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-pJqXFz0xNIE/Ty0Y8wB1P7I/AAAAAAAAAHE/-VVpsaII2gY/s1600/AC2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="426" src="http://2.bp.blogspot.com/-pJqXFz0xNIE/Ty0Y8wB1P7I/AAAAAAAAAHE/-VVpsaII2gY/s640/AC2.png" width="640" /></a></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">Click on
Activate button to active this Account structure, <span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">Click Yes
to Activate this Account structure<o:p></o:p></span></span></span></div>
<span style="font-family: Calibri;"></span><br />
<span style="font-family: Calibri;"><div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
</div>
</span><br />
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Times New Roman;">
</span></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-Lkj8cSkflKI/Ty0Y-Q4rx_I/AAAAAAAAAHM/vBCB2_Xr6yM/s1600/AC3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="171" src="http://1.bp.blogspot.com/-Lkj8cSkflKI/Ty0Y-Q4rx_I/AAAAAAAAAHM/vBCB2_Xr6yM/s400/AC3.png" width="400" /></a></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt; mso-add-space: auto;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-family: "Garamond","serif"; font-size: 14pt;">Effect on GL<o:p></o:p></span></u></b></div>
<br />
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt; mso-add-space: auto;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-family: "Garamond","serif"; font-size: 14pt;"><o:p><span style="text-decoration: none;"></span></o:p></span></u></b></div>
<span style="font-family: "Calibri","sans-serif"; font-size: 11pt; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">GL > Journal > General Journal<span style="mso-tab-count: 1;"> </span></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-tCOBlFhjZCk/Ty0Y_mxJX2I/AAAAAAAAAHU/HhI0NaxzImo/s1600/AC4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="183" src="http://3.bp.blogspot.com/-tCOBlFhjZCk/Ty0Y_mxJX2I/AAAAAAAAAHU/HhI0NaxzImo/s400/AC4.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">Click on
Lines Button -><span style="mso-spacerun: yes;"> </span>Select the Offset
Account from account structure(MA +Cost center) </span></span></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-7MHnKDV-zvI/Ty0badcjUPI/AAAAAAAAAIM/p1EeYgkQ2aw/s1600/AC5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="318" src="http://3.bp.blogspot.com/-7MHnKDV-zvI/Ty0badcjUPI/AAAAAAAAAIM/p1EeYgkQ2aw/s640/AC5.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;"><o:p><span style="font-family: Times New Roman;">
</span></o:p></span></span></div>
<span style="font-family: Calibri;"></span><br />
<span style="font-family: Calibri;"><div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt; mso-add-space: auto;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-family: "Garamond","serif"; font-size: 14pt;">Configure Advanced Rules</span></u></b></div>
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt; mso-add-space: auto;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt; mso-add-space: auto;">
<span style="font-family: "Garamond","serif"; font-size: 14pt;"><span style="font-size: small;"><span style="font-family: Calibri;"><span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">GL > Setup > chart of accounts > Advanced rule structure</span></span></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt; mso-add-space: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-41m4KEmUd1E/Ty0ZDAW4RnI/AAAAAAAAAHk/ldG0MGvll_k/s1600/AC6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://3.bp.blogspot.com/-41m4KEmUd1E/Ty0ZDAW4RnI/AAAAAAAAAHk/ldG0MGvll_k/s640/AC6.png" width="640" /></a></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Times New Roman;">
</span></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Times New Roman;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">GL >
Setup > chart of accounts > Configure Account structure</span></span></span></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<span style="font-family: Times New Roman;"><div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-dG2MxB9OtAY/Ty0ZFWaAnsI/AAAAAAAAAHs/wE-U2v3isGQ/s1600/AC7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="http://1.bp.blogspot.com/-dG2MxB9OtAY/Ty0ZFWaAnsI/AAAAAAAAAHs/wE-U2v3isGQ/s640/AC7.png" width="640" /></a></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
</div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">Click
Advanced rule to open below Advanced rule form</span></span></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-D6ZrUOThXW0/Ty0ZHlXa8ZI/AAAAAAAAAH0/XXzGMUVZpkI/s1600/AC8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="406" src="http://2.bp.blogspot.com/-D6ZrUOThXW0/Ty0ZHlXa8ZI/AAAAAAAAAH0/XXzGMUVZpkI/s640/AC8.png" width="640" /></a></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
</div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-family: "Garamond","serif"; font-size: 14pt;">Advanced Rules Effect on GL<o:p></o:p></span></u></b></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
</div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
</div>
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">GL > Journal > General Journal<span style="mso-spacerun: yes;"> </span>Click on Lines Button -><span style="mso-spacerun: yes;"> </span>Select the Offset Account from account structure + Advanced rule</span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-9wCrGJQiZx4/Ty0ZJTCxWEI/AAAAAAAAAH8/94NK98hrSOA/s1600/AC9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="352" src="http://3.bp.blogspot.com/-9wCrGJQiZx4/Ty0ZJTCxWEI/AAAAAAAAAH8/94NK98hrSOA/s640/AC9.png" width="640" /></a></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
</div>
</span><div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
</div>
</span><br />
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">As we
have created an advanced rule for main account 50110 i.e User must have to
select department if he selects main account 50110</span></span></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-FKzu5qixYZA/Ty0ZLGKtk6I/AAAAAAAAAIE/DwgzoNUhSD4/s1600/AC10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="316" src="http://4.bp.blogspot.com/-FKzu5qixYZA/Ty0ZLGKtk6I/AAAAAAAAAIE/DwgzoNUhSD4/s640/AC10.png" width="640" /></a></div>
<div class="MsoListParagraph" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<br /><br />
<a href="http://arsalanax.blogspot.com/2012/02/data-model-of-dimension-in-ax-2012.html">Data model of the dimension in AX 2012</a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com4tag:blogger.com,1999:blog-2033061858901462781.post-79846479777829534542012-02-03T21:16:00.003+05:002012-02-03T21:16:41.338+05:00Role based Security in AX<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Calibri;">There is a new pattern introduced in the new version of
Dynamics AX (AX6.0/2012), for the security of the forms/tables etc. which is
called RBS.<o:p></o:p></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">In Microsoft Dynamics AX, role-based security is aligned
with the structure of the business. Users are assigned to security roles based
on their responsibilities in the organization and their participation in business
processes. The administrator grants access to the duties that users in a role
perform, not to the program elements that users must use.</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-bHUWxPYic1w/TywHyXNKWoI/AAAAAAAAAG0/glAYdK6ZJTc/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="474" src="http://2.bp.blogspot.com/-bHUWxPYic1w/TywHyXNKWoI/AAAAAAAAAG0/glAYdK6ZJTc/s640/Untitled.png" width="640" /></a></div>
<span style="mso-no-proof: yes;"><span style="mso-spacerun: yes;"><span style="font-family: Calibri;"> </span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">
</span><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Let’s take a looks at the data models of the Security
framework<br style="mso-special-character: line-break;" />
<br style="mso-special-character: line-break;" />
<o:p></o:p></span></div>
<br />
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: currentColor; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background: rgb(198, 217, 241); border: 1pt solid windowtext; mso-background-themecolor: text2; mso-background-themetint: 51; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 114.5pt;" valign="top" width="191">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: Calibri;">Table<o:p></o:p></span></b></div>
</td>
<td style="background: rgb(198, 217, 241); border-color: windowtext windowtext windowtext rgb(0, 0, 0); border-style: solid solid solid none; border-width: 1pt 1pt 1pt 0px; mso-background-themecolor: text2; mso-background-themetint: 51; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 195pt;" valign="top" width="325">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: Calibri;">Description<o:p></o:p></span></b></div>
</td>
<td style="background: rgb(198, 217, 241); border-color: windowtext windowtext windowtext rgb(0, 0, 0); border-style: solid solid solid none; border-width: 1pt 1pt 1pt 0px; mso-background-themecolor: text2; mso-background-themetint: 51; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 169.3pt;" valign="top" width="282">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: Calibri;">Mapping<o:p></o:p></span></b></div>
</td>
</tr>
<tr style="mso-yfti-irow: 1;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 114.5pt;" valign="top" width="191">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">SecurityRole <o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 195pt;" valign="top" width="325">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Contains list of roles <o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 169.3pt;" valign="top" width="282">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">(AOT</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">Security</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">Roles)<o:p></o:p></span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 2;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 114.5pt;" valign="top" width="191">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">SecurityUserRole <o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 195pt;" valign="top" width="325">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Contains the user to role mappings<span style="mso-spacerun: yes;">
</span><o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 169.3pt;" valign="top" width="282">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">(System Administration </span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">
Users </span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">
User)<o:p></o:p></span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 3;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 114.5pt;" valign="top" width="191">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">SecurityTask <o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 195pt;" valign="top" width="325">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Contains the list of duties and privileges <o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 169.3pt;" valign="top" width="282">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">(AOT</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">Security</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">Privileges/Duties)<o:p></o:p></span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 4;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 114.5pt;" valign="top" width="191">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">SecuritySubTask <o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 195pt;" valign="top" width="325">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Contains the duty to privilege mappings <o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 169.3pt;" valign="top" width="282">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">(AOT</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">Security</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">
Duties</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">
Privileges)<o:p></o:p></span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 114.5pt;" valign="top" width="191">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">SecurityRoleTaskGrant <o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 195pt;" valign="top" width="325">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">contains the list of role to duty mappings <o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 169.3pt;" valign="top" width="282">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">(AOT</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">Security</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">
Roles</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">Duties)<o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
</div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Some Examples<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">///////////////// Code in X++ /////////////////////////////<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;">SecurityRole<span style="mso-spacerun: yes;"> </span>securityRole;</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;">SecurityUserRole<span style="mso-spacerun: yes;"> </span>securityUserRole; </span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;">SecurityTask<span style="mso-spacerun: yes;"> </span>securityTask; </span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;">SecuritySubTask<span style="mso-spacerun: yes;"> </span>securitySubTask;</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;">SecurityRoleTaskGrant<span style="mso-spacerun: yes;"> </span>securityRoleTaskGrant; </span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;">#define.SecurityRole(‘<span style="color: darkred;">BudgetBudgetManager’</span>)</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;">#define.SecurityTask(<span style="color: darkred;">BudgetManagerRoleCenterView</span>)</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 10pt;">// 1. How to the find
record ID of the privilege</span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<b><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">select</span></b><span style="font-family: Consolas; font-size: 10pt;"> <b><span style="color: darkblue;">firstOnly</span></b>
RecId <b><span style="color: darkblue;">from</span></b> securityTask</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">where</span></b> securityTask.AotName<span style="mso-spacerun: yes;"> </span>== #SecurityTask</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;">
</span>&& securityTask.Type<span style="mso-spacerun: yes;"> </span>==
SecurityTaskType::Privilege;</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 10pt;">// 2. How to find the
record ID of the security role of the currently logged-in user aving the
specified security role</span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<b><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">select</span></b><span style="font-family: Consolas; font-size: 10pt;"> <b><span style="color: darkblue;">firstonly</span></b>
RecId <b><span style="color: darkblue;">from</span></b> securityRole</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">exists</span></b> <b><span style="color: darkblue;">join</span></b>
securityUserRole </span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">where</span></b> securityRole.RecId<span style="mso-spacerun: yes;"> </span>== securityUserRole.SecurityRole</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;">
</span>&& securityRole.AotName<span style="mso-spacerun: yes;">
</span>== #SecurityRole </span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;">
</span>&& securityUserRole.User == <b><span style="color: darkblue;">curUserId</span></b>();<o:p></o:p></span></div>
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span></span><br />
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"></span></span><i><span style="color: green; font-family: Consolas; font-size: 10pt;">// 3. How to the find
all the duties containing the specified privilege (security Duty)?</span></i><span style="font-family: Consolas; font-size: 10pt;"><o:p></o:p></span><br />
<b><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">select</span></b><span style="font-family: Consolas; font-size: 10pt;"> SecurityTask <b><span style="color: darkblue;">from</span></b> securitySubTask</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">where</span></b> securitySubTask.SecuritySubTask ==
securityTask.RecId;<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 10pt;">// 4. How to check
whether the privilege is directly associated with role</span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<b><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">select</span></b><span style="font-family: Consolas; font-size: 10pt;"> <b><span style="color: darkblue;">firstOnly</span></b>
RecId <b><span style="color: darkblue;">from</span></b> securityRoleTaskGrant</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">where</span></b> securityRoleTaskGrant.SecurityTask <span style="mso-spacerun: yes;"> </span>== securityTask.RecId</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;">
</span>&& securityRoleTaskGrant.SecurityRole == securityRole.RecId;</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: "MS Gothic"; font-size: 10pt; mso-bidi-font-family: "MS Gothic";"> </span><span style="font-family: Consolas; font-size: 10pt;"><o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 10pt;">// 5. How to check
whether the privilege is associated with role through duty</span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span></span></i><b><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">select</span></b><span style="font-family: Consolas; font-size: 10pt;"> RecId <b><span style="color: darkblue;">from</span></b>
securityRoleTaskGrant</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">exists</span></b> <b><span style="color: darkblue;">join</span></b>
securitySubTask</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">where</span></b> securityRoleTaskGrant.SecurityTask ==
securitySubTask.SecurityTask</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;">
</span>&& securityRoleTaskGrant.SecurityRole == securityRole.RecId;</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span></span></div>
<span style="font-family: "Calibri","sans-serif"; font-size: 10pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><o:p><span style="font-family: MS PGothic; font-size: small;"> </span></o:p></span><span style="font-family: Calibri;">///////////////// Code in X++ /////////////////////////////<o:p></o:p></span><br />
<br />
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com20tag:blogger.com,1999:blog-2033061858901462781.post-23587729237992452642012-02-02T19:14:00.000+05:002012-02-02T19:14:11.915+05:00Development of SSRS reports in AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Calibri;">I have read a document on </span><a href="http://syedbaber.files.wordpress.com/2011/11/developing-ssrs-reports-for-dynamics-ax.docx"><span style="color: blue; font-family: Calibri;">development
of SSRS reports</span></a><span style="font-family: Calibri;"> on dynamics AX written by a friend syed baber Owais,
covering the following topics<o:p></o:p></span><br />
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">SSRS Installation and Configuration<span style="mso-tab-count: 1;"> </span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Editing existing SSRS Reports<span style="mso-tab-count: 1;"> </span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Developing a new SSRS report<span style="mso-tab-count: 1;"> </span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Developing Query Based SSRS reports using VS</span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 1in; mso-list: l0 level2 lfo1; text-indent: -0.25in;">
<span style="font-family: "Courier New"; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Previewing
SSRS reports from Visual Studio</span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 1in; mso-list: l0 level2 lfo1; text-indent: -0.25in;">
<span style="font-family: "Courier New"; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Viewing
SSRS report on browser</span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 1in; mso-list: l0 level2 lfo1; text-indent: -0.25in;">
<span style="font-family: "Courier New"; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Opening
SSRS report from AX</span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 1.5in; mso-list: l0 level3 lfo1; text-indent: -0.25in;">
<span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;"><span style="mso-list: Ignore;">§<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Filtering
a report with an specific parameter</span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Developing RDP based SSRS reports<span style="mso-tab-count: 1;"> </span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Using Controller Class<span style="mso-tab-count: 1;"> </span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 1in; mso-list: l0 level2 lfo1; text-indent: -0.25in;">
<span style="font-family: "Courier New"; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Examples
of controller class usage<span style="mso-tab-count: 1;"> </span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 1.5in; mso-list: l0 level3 lfo1; text-indent: -0.25in;">
<span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;"><span style="mso-list: Ignore;">§<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">HcmEmployeeLeaveController<span style="mso-tab-count: 1;"> </span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 1.5in; mso-list: l0 level3 lfo1; text-indent: -0.25in;">
<span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;"><span style="mso-list: Ignore;">§<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">BankDepositSlipController<span style="mso-tab-count: 1;"> </span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Data Contract class for SSRS Reports<span style="mso-tab-count: 1;"> </span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 1in; mso-list: l0 level2 lfo1; text-indent: -0.25in;">
<span style="font-family: "Courier New"; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Defining
label and help text for parameters<span style="mso-tab-count: 1;"> </span><o:p></o:p></span></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-66441486493820192252012-02-02T17:11:00.002+05:002012-02-02T17:11:51.108+05:00Date Effectivtive pattern in AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: black; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Yesterday, I have read a white paper describing new
Date effective pattern in the dynamics.<o:p></o:p></span><br />
<br />
<div style="vertical-align: top;">
<span style="color: black; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">It demonstrates the two examples (Cust Interest, HCM
Position) to describe the following topics<o:p></o:p></span></div>
<br />
<div style="line-height: 140%; margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in; vertical-align: top;">
<span style="color: black; font-family: Symbol; font-size: 10pt; line-height: 140%; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">The difference between the two types of valid time
state tables</span></div>
<div style="line-height: 140%; margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in; vertical-align: top;">
<span style="color: black; font-family: Symbol; font-size: 10pt; line-height: 140%; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">How valid time state tables are integrated with the
security framework </span></div>
<div style="line-height: 140%; margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in; vertical-align: top;">
<span style="color: black; font-family: Symbol; font-size: 10pt; line-height: 140%; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Various update modes </span></div>
<div style="line-height: 140%; margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in; vertical-align: top;">
<span style="color: black; font-family: Symbol; font-size: 10pt; line-height: 140%; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">How to use the <strong><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">validtimestate</span></strong> keyword in queries </span></div>
<div style="line-height: 140%; margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in; vertical-align: top;">
<span style="color: black; font-family: Symbol; font-size: 10pt; line-height: 140%; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Runtime behaviors </span></div>
<div style="line-height: 140%; margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in; vertical-align: top;">
<span style="color: black; font-family: Symbol; font-size: 10pt; line-height: 140%; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: black; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Scenarios that are not supported by the framework <o:p></o:p></span></div>
<br />
<div style="vertical-align: top;">
<span style="color: black; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">The <a href="http://go.microsoft.com/fwlink/?LinkId=221069"><span style="color: blue;">paper</span></a> also suggests
design patterns for forms that use valid time state tables. <o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-36509469738167270352012-02-02T17:04:00.000+05:002012-02-02T17:04:32.132+05:00extensible data security (XDS) framework in AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-size: 12pt; line-height: 115%;"><span style="font-family: Calibri;">The extensible data security framework is a powerful new
feature in Microsoft Dynamics AX 2012 that has been made available to
developers and customers to address rich data security policy scenarios. It
enables developers and administrators to secure data in shared tables such that
users have access to only the part of the table that is allowed by the enforced
policy. This feature can be used in conjunction with role-based security (also
supported in Microsoft Dynamics AX 2012) to provide more comprehensive security
than was possible in the past.<o:p></o:p></span></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12pt; line-height: 115%;"><span style="font-family: Calibri;">Data Security policy
concepts<o:p></o:p></span></span></b></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 115%;"><span style="font-family: Calibri;">When developing a data security policy, you need to become
familiar with several concepts, such as constrained tables, primary tables,
policy queries, and context<b style="mso-bidi-font-weight: normal;"><o:p></o:p></b></span></span></div>
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: currentColor; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background-color: transparent; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 117.9pt;" valign="top" width="197">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">constrained tables<o:p></o:p></span></span></div>
</td>
<td style="background-color: transparent; border-color: windowtext windowtext windowtext rgb(0, 0, 0); border-style: solid solid solid none; border-width: 1pt 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 360.9pt;" valign="top" width="602">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">A <i>constrained
table </i>is the table or tables in a given security policy from which data
is filtered or secured, based on the associated policy query.<o:p></o:p></span></span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 1;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 117.9pt;" valign="top" width="197">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">primary tables<o:p></o:p></span></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 360.9pt;" valign="top" width="602">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">A <i>primary table
</i>is used to secure the content of the related constrained table.<o:p></o:p></span></span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 2;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 117.9pt;" valign="top" width="197">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">policy queries<o:p></o:p></span></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 360.9pt;" valign="top" width="602">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">A <i>policy query </i>is
used to secure the constrained tables specified in a given extensible data
security policy.<o:p></o:p></span></span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 3; mso-yfti-lastrow: yes;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 117.9pt;" valign="top" width="197">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">context<o:p></o:p></span></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 360.9pt;" valign="top" width="602">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; text-align: justify;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">A policy context
is a piece of information that controls the circumstances under which a given
policy is considered to be applicable. If this context is not set, then the
policy, even if enabled, is not enforced.<o:p></o:p></span></span></div>
</td>
</tr>
</tbody></table>
<br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<span style="font-size: 12pt; line-height: 115%;"><span style="font-family: Calibri;">The </span><a href="http://technet.microsoft.com/en-us/library/hh272862.aspx"><span style="color: blue; font-family: Calibri;">white paper</span></a><span style="font-family: Calibri;">
published by Microsoft which contains complete information of the XDS framework
along with a walk though.<o:p></o:p></span></span></div>
<span style="font-family: "Calibri","sans-serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br clear="all" style="mso-special-character: line-break; page-break-before: always;" />
</span>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-16273638839619205382012-02-01T16:43:00.002+05:002012-02-01T16:43:53.450+05:00How to execute the method on IL in AX<div dir="ltr" style="text-align: left;" trbidi="on">
<span lang="EN" style="font-size: 12pt; mso-ansi-language: EN; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">With the release
of <b>Microsoft Dynamics AX 2012</b>, a huge focus has been around the move for
X++ code to be compiled to IL<o:p></o:p></span></span><br />
<br />
<span lang="EN" style="font-size: 12pt; mso-ansi-language: EN; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">There are certain
areas of AX that always compile down to IL / MSIL / CIL. All of those are in
reference to the .Net Framework execution. This means, that the same C# code
that actually executes, is compiled down to IL. The same now, takes place for
some areas of X++. There are huge benefits in code execution when this is the
case, and why this is such an important topic to understand from a performance
point of view.<o:p></o:p></span></span><br />
<br />
<span lang="EN" style="color: #29303b; font-size: 12pt; mso-ansi-language: EN; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">For
more reading visit this </span><a href="http://dynamics-ax.blogspot.com/2011/11/ax-2012-performance-and-il.html"><span style="color: blue; font-family: Calibri;">link</span></a><o:p></o:p></span><br />
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span lang="EN" style="font-size: 12pt; mso-ansi-language: EN; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Below code will
execute the code in IL explicitly<o:p></o:p></span></span></div>
<br />
<br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;">/// <summary></span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;">///<span style="mso-spacerun: yes;"> </span>Initializes the
<c>PurchTable</c> record from a <c>VendTable</c>
record.</span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;">/// </summary></span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;">/// <param
name="_vendTable"></span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;">///<span style="mso-spacerun: yes;"> </span>The vendor record from which to initialize;
optional.</span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<i><span style="color: green; font-family: Consolas; font-size: 8pt;">/// </param></span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<b><span style="color: darkblue; font-family: Consolas; font-size: 8pt;">server</span></b><span style="font-family: Consolas; font-size: 8pt;"> <b><span style="color: darkblue;">public</span></b>
<b><span style="color: darkblue;">void</span></b><span style="mso-spacerun: yes;">
</span>initFromVendTable(VendTable _vendTable = this.vendTable_OrderAccount())</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;">{</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">container</span></b><span style="mso-spacerun: yes;"> </span>purchTableContainer;</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;">
</span>XppILExecutePermission<span style="mso-spacerun: yes;">
</span>xppILExecutePermission;</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /><span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span><i><span style="color: green;">// Transition to IL to update the sales quantity</span></i></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;">
</span>xppILExecutePermission = <b><span style="color: darkblue;">new</span></b>
XppILExecutePermission();</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;">
</span>xppILExecutePermission.assert();<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;">
</span>purchTableContainer = runTableMethodIL(</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;"> <b><span style="color: darkblue;">tableStr</span></b>(PurchTable),</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span><b><span style="color: darkblue;">tableStaticMethodStr</span></b>(PurchTable,
initFromVendTableIL),</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;"> </span>[buf2Con(this, <b><span style="color: darkblue;">true</span></b>), buf2Con(_vendTable, <b><span style="color: darkblue;">true</span></b>)]);<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;">
</span>CodeAccessPermission::revertAssert();<o:p></o:p></span></div>
<span style="font-family: Consolas; font-size: 8pt;"><span style="mso-spacerun: yes;">
</span>this.con2buf(purchTableContainer);<o:p></o:p></span><br />
<span style="font-family: Consolas; font-size: 8pt;">}</span><br />
<br />
<br />
<span style="color: darkblue; font-family: Consolas; font-size: xx-small;"></span><b><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;">private static</span></span></span></b><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"></span></span></span><span style="font-family: Consolas; font-size: xx-small;"><span style="font-family: Consolas; font-size: xx-small;"> </span></span><b><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;">server</span></span></span></b><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"></span></span></span><span style="font-family: Consolas; font-size: xx-small;"><span style="font-family: Consolas; font-size: xx-small;"> </span></span><b><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;">container</span></span></span></b><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"></span></span></span><span style="font-family: Consolas; font-size: xx-small;"><span style="font-family: Consolas; font-size: xx-small;"> initFromVendTableIL(</span></span><b><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;">container</span></span></span></b><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"><span style="color: darkblue; font-family: Consolas; font-size: xx-small;"></span></span></span><span style="font-family: Consolas; font-size: xx-small;"><span style="font-family: Consolas; font-size: xx-small;"> _inputContract)</span></span><br />
<span style="font-family: Consolas; font-size: xx-small;"><span style="font-family: Consolas; font-size: xx-small;">{</span></span><br />
<span style="font-family: Consolas; font-size: xx-small;">............</span><br />
<span style="font-family: Consolas; font-size: xx-small;"><span style="font-family: Consolas; font-size: xx-small;">}</span></span><br />
<span style="font-family: Consolas; font-size: xx-small;"><span style="font-family: Consolas; font-size: xx-small;"></span></span></div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com0tag:blogger.com,1999:blog-2033061858901462781.post-37618786069312436212012-02-01T16:23:00.002+05:002012-02-01T16:23:40.389+05:00unif of work framework in AX<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: #333333;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">One of the most common design patterns in enterprise software development is the Unit of Work, According to Martin Fowler, the Unit of Work pattern</span></span></span></span></div>
<div style="text-align: justify;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 1in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Symbol; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span></span><span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Keeps track of the objects affected by a
transaction </span></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Symbol; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span></span><span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Coordinates the writing out of changes </span></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 10pt 1in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: black;"><span style="font-family: Symbol; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span></span><span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Resolve the concurrency problem</span></span> </span></div>
<div style="background: white; text-align: justify;">
<span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">A
Unit of Work keeps track of everything you do during a business transaction
that can affect the database. When you're done, it figures out everything that
needs to be done to alter the database as a result of your work.</span></span></div>
<div style="background: white; text-align: justify;">
<br /></div>
<div style="background: white; text-align: justify;">
<span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">In x++, there is a system class exists that can be used to implement the unit of work framework some of the details are as follows</span></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;"></span><div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">UnitofWork</span></b><span style="color: black; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"> class, </span></span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<span style="color: black; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">some important methods<o:p></o:p></span></span></span></div>
<div style="text-align: justify;">
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></div>
<div style="text-align: justify;">
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: currentColor; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 1.7in;" valign="top" width="204"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><a href="http://msdn.microsoft.com/en-us/library/unitofwork.clear.aspx"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><em>clear</em></span></a><o:p></o:p></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border-color: windowtext windowtext windowtext rgb(0, 0, 0); border-style: solid solid solid none; border-width: 1pt 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 4.95in;" valign="top" width="594"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">Clears all the changes<o:p></o:p></span></span></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></tr>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span>
<tr style="mso-yfti-irow: 1;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 1.7in;" valign="top" width="204"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><a href="http://msdn.microsoft.com/en-us/library/unitofwork.deleteonsavechanges.aspx"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><em>deleteonSaveChanges</em></span></a><o:p></o:p></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 4.95in;" valign="top" width="594"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">Deletes the records on commit/saveChanges<o:p></o:p></span></span></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></tr>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span>
<tr style="mso-yfti-irow: 2;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 1.7in;" valign="top" width="204"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><a href="http://msdn.microsoft.com/en-us/library/unitofwork.insertonsavechanges.aspx"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><em>insertonSaveChanges</em></span></a><o:p></o:p></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 4.95in;" valign="top" width="594"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">inserts the records on commit/saveChanges<o:p></o:p></span></span></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></tr>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span>
<tr style="mso-yfti-irow: 3;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 1.7in;" valign="top" width="204"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><a href="http://msdn.microsoft.com/en-us/library/unitofwork.updateonsavechanges.aspx"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><em>updateonSaveChanges</em></span></a><o:p></o:p></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 4.95in;" valign="top" width="594"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">updates the records on commit/saveChange<o:p></o:p></span></span></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></tr>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span>
<tr style="mso-yfti-irow: 4; mso-yfti-lastrow: yes;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 1.7in;" valign="top" width="204"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><a href="http://msdn.microsoft.com/en-us/library/unitofwork.savechanges.aspx"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><em>saveChanges</em></span></a><o:p></o:p></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><td style="background-color: transparent; border-color: rgb(0, 0, 0) windowtext windowtext rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 4.95in;" valign="top" width="594"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">This method will hit the server one time to
commit the changes<o:p></o:p></span></span></span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></td><span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></tr>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></tbody></table>
</div>
<div style="text-align: justify;">
<span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">
<span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><o:p> </o:p></span></span></span></div>
<div style="text-align: justify;">
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">I would like to take an example to
demonstrate the use of the UoW framework,<o:p></o:p></span></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">
<span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Example 1:<o:p></o:p></span></span></span></div>
<div style="text-align: justify;">
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">If there is a need to inserts data in
a bulk to Table1. </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;">there is also a call <em>tJournalHeader.insert() needed in the for loop</em></span></span></span></div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<a href="http://2.bp.blogspot.com/-vCqEx2DZwoQ/TykTe8HUUwI/AAAAAAAAAGM/Y9nSfhkT6uw/s1600/Uow2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" height="270" src="http://2.bp.blogspot.com/-vCqEx2DZwoQ/TykTe8HUUwI/AAAAAAAAAGM/Y9nSfhkT6uw/s400/Uow2.png" width="400" /></span></a></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">using Unit of work</span></div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<a href="http://3.bp.blogspot.com/-mN5ymMH1H-c/TykdorBQdJI/AAAAAAAAAGs/HfsZHZ9Scrw/s1600/uoW3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" height="433" src="http://3.bp.blogspot.com/-mN5ymMH1H-c/TykdorBQdJI/AAAAAAAAAGs/HfsZHZ9Scrw/s640/uoW3.png" width="640" /></span></a></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<b style="mso-bidi-font-weight: normal;"><span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;">Example2:</span></span></b></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="color: black;"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">What if we are doing bulk insert of a journal with many lines and the journal header contains some totals calculated based on its lines. It is impossible to insert lines before header since the value of the journal's surrogate key is unknown. But that would be so convenient because otherwise the header should be inserted first, then the lines and then the header should be updated with the calculated totals<o:p></o:p></span><o:p></o:p></span></span></span></div>
<div style="text-align: justify;">
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></div>
<div class="separator" style="clear: both; text-align: justify;">
<a href="http://2.bp.blogspot.com/-g_hFw5twezA/TykTcBpfHWI/AAAAAAAAAGE/GTvEtbcDOaU/s1600/UowPic1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" height="214" src="http://2.bp.blogspot.com/-g_hFw5twezA/TykTcBpfHWI/AAAAAAAAAGE/GTvEtbcDOaU/s640/UowPic1.png" width="640" /></span></a></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<a href="http://4.bp.blogspot.com/-8jaZ9d4i_kM/TykdgQ7vFjI/AAAAAAAAAGU/bsTiprSXVRs/s1600/uoW4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" height="547" src="http://4.bp.blogspot.com/-8jaZ9d4i_kM/TykdgQ7vFjI/AAAAAAAAAGU/bsTiprSXVRs/s640/uoW4.png" width="640" /></span></a></div>
<div style="text-align: justify;">
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">
</span></div>
<span style="color: black; font-family: Arial, Helvetica, sans-serif;"><div align="justify" class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-UEQYxLLIlLY/Tykdio-v5fI/AAAAAAAAAGc/fUVgnf05Ukg/s1600/uoW5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" height="640" src="http://3.bp.blogspot.com/-UEQYxLLIlLY/Tykdio-v5fI/AAAAAAAAAGc/fUVgnf05Ukg/s640/uoW5.png" width="632" /></span></a></div>
</span><div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="color: black; font-family: Arial, Helvetica, sans-serif;">AX client has the great support of the unit of work as well. This means that
form datasources can be grouped into a unit of work, so all the benefits of
simultaneous commit and surrogate key propagation will be available on forms.
There are a lot of possibilities and tricks there, so this topic worth one or
more dedicated posts as well. </span></div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com0tag:blogger.com,1999:blog-2033061858901462781.post-43974055043296890002012-01-30T02:49:00.001+05:002012-01-30T02:49:04.628+05:00release of Dynamics AX 2012 for Retail<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="margin: 1em 0in; text-align: justify;">
<span lang="EN" style="font-family: "Calibri","sans-serif"; font-size: 16pt; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><span style="color: #3f529c;">Microsoft
announced the release of Dynamics AX 2012 for Retail<o:p></o:p></span></span></h3>
<div class="summary" style="margin: 1em 0in; text-align: justify;">
<span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">On Jan 16<sup>th</sup>, At the <a href="http://events.nrf.com/annual2012/public/enter.aspx"><span style="color: blue;">National Retail
Federation’s annual conference</span></a> today, Microsoft Corp. (Nasdaq “MSFT”)
announced the upcoming release of Microsoft Dynamics AX 2012 for Retail</span><span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><o:p></o:p></span></div>
<div class="summary" style="margin: 1em 0in; text-align: justify;">
<span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Its
enterprise resource planning product designed to provide midsized and
enterprise-level retailers with an offering that includes cross-channel
capabilities, social and mobile commerce, point of sale, and enhancements for
merchandising.<o:p></o:p></span></div>
<div class="summary" style="margin: 1em 0in; text-align: justify;">
<span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Microsoft
Dynamics AX 2012 for Retail helps retailers do the following: <o:p></o:p></span></div>
<div class="summary" style="margin: 1em 0in 1em 0.5in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -0.5in;">
<span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">•<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Connect to customers</span></div>
<div class="summary" style="margin: 1em 0in 1em 0.5in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -0.5in;">
<span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"></span><span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">•<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Empower employees <o:p></o:p></span></div>
<div class="summary" style="margin: 1em 0in 1em 0.5in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -0.5in;">
<span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-fareast-font-family: Calibri;"><span style="mso-list: Ignore;">•<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Execute with insight.<o:p></o:p></span></div>
<div class="summary" style="margin: 1em 0in; text-align: justify;">
<span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><a href="http://www.microsoft.com/Presspass/press/2012/jan12/01-16NRFPR.mspx?rss_fdn=Custom"><span style="color: blue;">For
Further Details</span></a><o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<br /></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com0tag:blogger.com,1999:blog-2033061858901462781.post-45284159877700972772012-01-30T02:25:00.001+05:002012-02-11T21:09:36.398+05:00Dynamics AX technical consultant interview questions<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">Today, I have spent quite a lot of time to gather the interview question for a Dynamics AX Technical Consultant and Developer. I have also provided the links of the answers of those question</span></span></div>
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">1.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">How can we create primary key for a
table? </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://www.amer-ax.com/2010/05/how-to-create-a-primary-key-for-a-dynamics-ax-table/"><span style="color: blue; font-family: Calibri;">Post
by Amer atiya, explaining the process of Primary key creation</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">2.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">what precautions you need for
overriding fetch() method for a report? </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/bb395110.aspx"><span style="color: blue; font-family: Calibri;">msn link of how to
Override the fetch Method to Filter Data for Reports.</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">3.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">Difference between OCC (Optimistic
concurrency control) and PCC (Pessimistic concurrency control)? </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/bb190073.aspx"><span style="color: blue; font-family: Calibri;">MSN Link
explaining OCC and PCC</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">4.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">How many types of MAP there in
Dynamics AX? </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://arsalanax.blogspot.com/2012/01/types-of-map-in-dynamics-ax.html"><span style="color: blue; font-family: Calibri;">I
have written a post explaining the difference</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">5.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">What is cache lookup what is it used
for? </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://dynamicsuser.net/forums/p/30043/157813.aspx"><span style="color: blue; font-family: Calibri;">Dynamics AX Caching</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">6.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">Difference between table and views? </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://www.geekinterview.com/question_details/29308"><span style="color: blue; font-family: Calibri;">Table vs views</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">7.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">why we use dialog? and how to
accomplished it? </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/aa877843(v=ax.10).aspx"><span style="color: blue; font-family: Calibri;">MSDN Link
explaining dialog</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">8.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">what are the different type of index? </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/bb278358.aspx"><span style="color: blue; font-family: Calibri;">Index Overview</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">9.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">Difference b/w cascade + restricted
and restricted delete actions? </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/bb315018(v=ax.10).aspx"><span style="color: blue; font-family: Calibri;">Delete
actions in AX</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">10.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">In
which case delete_from and delete() have same result?</span></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.25in;">
<span lang="EN" style="font-size: 12pt;"><span style="font-family: Calibri;"><strong>Delete() </strong>will delete one record at a time.<o:p></o:p></span></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.25in;">
<span lang="EN" style="font-size: 12pt;"><span style="font-family: Calibri;"><strong>Delete_from </strong>can delete multiple records at a time.<o:p></o:p></span></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-size: 12pt;"><span style="font-family: Calibri;">11.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span style="font-size: 12pt;"><span style="font-family: Calibri;">Explain
sales/purchase order processes in AX. </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://www.dynamicsaxtraining.com/dynamics-ax-trade-and-logistics-training/create-purchase-order"><span style="color: blue; font-family: Calibri;">Purchase
Order</span></a></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://www.dynamicsaxtraining.com/dynamics-ax-trade-and-logistics-training/create-sales-order"><span style="color: blue; font-family: Calibri;">Sales
Order</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">12.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">Can you just tell the
table properties that you can remember</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="color: #333333; font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/bb314725.aspx"><span style="color: blue; font-family: Calibri;">Tables Overview</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">13.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">Different types of
relation? Explain it detail?</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/aa556809.aspx"><span style="color: blue; font-family: Calibri;">Relations in
Tables</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">14.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">Explain Queries? What’s
it used for?</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="color: #333333; font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/bb314753.aspx"><span style="color: blue; font-family: Calibri;">AOT Query</span></a></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="color: #333333; font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/aa638454.aspx"><span style="color: blue; font-family: Calibri;">X++ Query</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">15.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">Explain different types
of reports?</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-indent: 0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">There
are two types of reports in AX</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt 0.5in;">
<span style="color: #333333; font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/cc553120.aspx"><span style="color: blue; font-family: Calibri;">SSRS Reports</span></a><span style="font-family: Calibri;"> </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt 0.5in;">
<span style="color: #333333; font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/bb427701.aspx"><span style="color: blue; font-family: Calibri;">X++ Reports</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">16.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">Differentiate auto design
spec & Generated design? Which one is a preferable choice and why ?</span></span><span style="color: #333333; font-size: 12pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto;">
<span style="color: #333333; font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/cc967418.aspx"><span style="color: blue; font-family: Calibri;">Report Design for
X++ Reports</span></a><span style="font-family: Calibri;"> <o:p></o:p></span></span></div>
<br />
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">17.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">What are all the add- on
tools you used in Dynamics AX (It’s an indirect question for AIF)</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">18.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><a href="http://msdn.microsoft.com/en-us/library/bb278358.aspx"><span style="color: blue; font-family: Calibri;">Explain
primary index and Cluster index? Explain in detail?</span></a><span style="font-family: Calibri;"> </span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-indent: -0.25in;">
<br /></div>
<br />
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">19.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">What is the default index for a table?</span></span><br />
<br />
<span style="color: #333333; font-family: Calibri;"> <a href="http://arsalanax.blogspot.com/2012/02/default-index-for-table-in-ax-x.html">Default Index in Table</a></span></div>
<div style="margin-left: 0.25in;">
</div>
<br />
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 12pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">20.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">Did you work with EP (Enterprise Portal & Workflow) how you
can implement this features into your projects ?</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;"> </span><a href="http://www.blogger.com/Microsoft%20Dynamics%20AX%20requires%20a%20unique%20index%20on%20each%20table.%20If%20there%20are%20no%20indexes%20on%20a%20table%20or%20all%20the%20indexes%20are%20disabled,%20a%20system%20index%20is%20automatically%20created.%20The%20system%20index%20is%20created%20on%20the%20RecId%20and%20DataAreaId%20fields%20if%20the%20DataAreaId%20field"><span style="color: blue; font-family: Calibri;">EP
in AX 2012</span></a><o:p></o:p></span></div>
<br />
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">21.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">Can you just point out some best practice you used when u
develop a project?</span></span><span style="color: #333333; font-size: 12pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-indent: -0.25in;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">22.</span><span style="font-family: 'Times New Roman'; font-size: 7pt; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span><span style="font-family: Calibri;"><span style="color: #333333; font-size: 12pt;">Did you worked with base
modules?</span></span><span style="color: #333333; font-size: 12pt;"><o:p> </o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 12pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="color: #333333; font-size: 12pt;"><span style="font-family: Calibri;">There is a also a </span><a href="http://www.google.com.pk/url?sa=t&rct=j&q=differentiate%20auto%20design%20spec%20%26%20generated%20design%20in%20morph%20x%20reporting&source=web&cd=1&ved=0CCAQFjAA&url=http%3A%2F%2Fdynamicsuser.net%2Fcfs-filesystemfile.ashx%2F__key%2FCommunityServer.Compo"><span style="color: blue; font-family: Calibri;">link</span></a><span style="font-family: Calibri;">
containing a document that have hundreds of question<o:p></o:p></span></span></div>
</div>
Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com19tag:blogger.com,1999:blog-2033061858901462781.post-40803511279060232232012-01-30T01:45:00.001+05:002012-01-30T01:45:13.001+05:00types of MAP in dynamics AX<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #222222; font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">There are two types of Maps available
in dynamics AX<o:p></o:p></span></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<span style="color: #222222; font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">1. <b style="mso-bidi-font-weight: normal;">X++ Maps</b>: it can be used as a temp data store for the given scope
of a process. This takes us less over head, and is much quicker than a TempTable.
</span><a href="http://dynamics-ax.blogspot.com/2006/07/map-mapenumerator-objects.html"><span style="color: #473624; font-family: Calibri;">For
Further reading</span></a><o:p></o:p></span></div>
<span style="color: #222222; font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">2. <b style="mso-bidi-font-weight: normal;">AOT Maps</b>: A map can unify the access to similar columns and methods
that are present in multiple tables. You associate a map field with a field in
one or more tables. This enables you to use the same field name to access
fields with different names in different tables. Methods on maps enable you to
create or modify methods that act on the table fields that the map references. <o:p></o:p></span></span><br />
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com4tag:blogger.com,1999:blog-2033061858901462781.post-20762773067372968052012-01-30T01:11:00.000+05:002012-01-30T01:20:51.049+05:00passing parameters between forms in AX<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">In dynamics AX, working
with forms, there are times when you need to pass some information from current
form to the opened form, so the question arrived is that what's the best way to
open the new form and pass information. <o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;"><strong>Answer</strong>: It depends upon
the information that is needed in the new form; there is Args class that plays
an important role to pass the information. Let’s take a look on some of the
important methods of that class<o:p></o:p></span></div>
<br />
<span style="font-family: Calibri;"><strong>Args class (Argument)<o:p></o:p></strong></span><br />
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">"The Args class is
used to pass arguments such as a name, a caller, and parameters between
application objects"<o:p></o:p></span></div>
<br />
<span style="font-family: Calibri;">Some important methods are<o:p></o:p></span><br />
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: currentColor; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background-color: transparent; border: 1pt solid black; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; padding: 0in 5.4pt; width: 108.9pt;" valign="top" width="145"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: Calibri;">Caller<o:p></o:p></span></b></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
</td>
<td style="background-color: transparent; border-color: black black black rgb(0, 0, 0); border-style: solid solid solid none; border-width: 1pt 1pt 1pt 0px; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt; width: 369.9pt;" valign="top" width="493"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Gets or sets the
instance of the object that created this instance of the Args class. </span><o:p><span style="font-family: Calibri;"> </span></o:p></div>
</td>
</tr>
<tr style="mso-yfti-irow: 1;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 108.9pt;" valign="top" width="145"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: Calibri;">name<o:p></o:p></span></b></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 369.9pt;" valign="top" width="493"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Gets and sets the name
of the application object to call.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 2;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 108.9pt;" valign="top" width="145"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: Calibri;">parm<o:p></o:p></span></b></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 369.9pt;" valign="top" width="493"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Gets or sets a string
that specifies miscellaneous information for the called object. </span><o:p><span style="font-family: Calibri;"> </span></o:p></div>
</td>
</tr>
<tr style="mso-yfti-irow: 3;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 108.9pt;" valign="top" width="145"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;"><b style="mso-bidi-font-weight: normal;">parmEnum</b><o:p></o:p></span></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 369.9pt;" valign="top" width="493"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Gets or sets the
enumeration value of the enumeration type that is specified in the
parmEnumType method. </span><o:p><span style="font-family: Calibri;"> </span></o:p></div>
</td>
</tr>
<tr style="mso-yfti-irow: 4;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 108.9pt;" valign="top" width="145"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: Calibri;">parmEnmType<o:p></o:p></span></b></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 369.9pt;" valign="top" width="493"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Gets or sets the ID
value of any enumeration type. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 5;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 108.9pt;" valign="top" width="145"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: Calibri;">ParmObject<o:p></o:p></span></b></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 369.9pt;" valign="top" width="493"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Gets or sets an instance
of any object to pass to the called object. <o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
</td>
</tr>
<tr style="mso-yfti-irow: 6; mso-yfti-lastrow: yes;">
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black; border-style: none solid solid; border-width: 0px 1pt 1pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 108.9pt;" valign="top" width="145"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: Calibri;">record<o:p></o:p></span></b></div>
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<br /></div>
</td>
<td style="background-color: transparent; border-color: rgb(0, 0, 0) black black rgb(0, 0, 0); border-style: none solid solid none; border-width: 0px 1pt 1pt 0px; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt; width: 369.9pt;" valign="top" width="493"><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Gets and sets the record
from the table on which the caller object is working.<o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">There are four methods
that can be used to pass extra information to the new class: <o:p></o:p></span></div>
<br />
<ol style="text-align: left;">
<li><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">The <b style="mso-bidi-font-weight: normal;">parm</b> method – to pass strings </span></div>
</li>
<li><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">The <b style="mso-bidi-font-weight: normal;">parmEnum </b>and<b style="mso-bidi-font-weight: normal;"> parmEnumType</b>
method – to pass enumeration values </span></div>
</li>
<li><div class="MsoNoSpacing" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">The <b style="mso-bidi-font-weight: normal;">parmObject</b> method – to pass an object of any type. </span><o:p><span style="font-family: Calibri;"> </span></o:p></div>
</li>
</ol>
<span style="font-family: Calibri;">Examples:<o:p></o:p></span><br />
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">1.</span><span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span><span style="font-family: Calibri;">If you need a
data from the parent form main data source for the current record, so you don’t
need to do anything in parent, just create a display menu item and give the
form name that needs to be opened, create a menuItem button and assign the
newly created menu item.</span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in;">
<span style="font-family: Calibri;">Override
the Init method on opened form<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in;">
<span style="font-family: Calibri;">And
you get the parent dataset records as</span><o:p><span style="font-family: Calibri;"> </span></o:p></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt; text-indent: 0.5in;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">element.<span style="color: black;">args</span>().<span style="color: black;">record</span>()</span></div>
<br />
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">2.</span><span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span><span style="font-family: Calibri;">Need to pass any
object/string/Enum<o:p></o:p></span></div>
<span style="font-family: Calibri;"> Use
the same approach for creating the button<o:p></o:p></span><br />
<br />
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<b style="mso-bidi-font-weight: normal;"><span style="color: #222222; font-family: "Arial","sans-serif"; mso-fareast-font-family: "Times New Roman";">Parent
form</span></b></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">void clicked()<br />
{<br />
<span style="mso-spacerun: yes;"> </span>Args args;<br />
<span style="mso-spacerun: yes;"> </span>FormRun formRun;<br />
<span style="mso-spacerun: yes;"> </span><br />
<span style="mso-spacerun: yes;"> </span>super(); <br />
<br />
<span style="mso-spacerun: yes;"> </span>args = new Args(formstr(FormName));</span></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in; text-indent: 0.25in;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>//
To pass any string value<br />
<span style="mso-spacerun: yes;"> </span>args.parm(<string value>);</span></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in; text-indent: 0.25in;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>//
To pass any object<br />
<span style="mso-spacerun: yes;"> </span>args.parmObject(<object>);</span></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in; text-indent: 0.25in;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>//
To pass any Enum<span style="mso-spacerun: yes;"> </span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>args.parmEnum( EnumValue);<br />
<span style="mso-spacerun: yes;"> </span>args.parmEnumType( EnumNum( <EnumName>)
);<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in; text-indent: 0.25in;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span>formRun
= classFactory.FormRunClass(args);<br />
<span style="mso-spacerun: yes;"> </span>formRun.init();<br />
<span style="mso-spacerun: yes;"> </span>formRun.run();<br />
<span style="mso-spacerun: yes;"> </span>formRun.wait();<br />
<span style="mso-spacerun: yes;"> </span>formRun.detach();<br />
<span style="mso-spacerun: yes;"> </span>parenttable_ds.refresh(); //
Refreshing parent table DataSourceTable<br />
<span style="mso-spacerun: yes;"> </span>parenttable_ds.executeQuery(); //
Refreshing Parent DataSourceTable <br />
</span><span style="color: #222222; font-family: "Arial","sans-serif"; mso-fareast-font-family: "Times New Roman";">}<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<b style="mso-bidi-font-weight: normal;"><span style="color: #222222; font-family: "Arial","sans-serif"; mso-fareast-font-family: "Times New Roman";">Child
Form<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<span style="font-family: Times New Roman;">
</span><span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="font-family: "Courier New", Courier, monospace;">void init()<br />
{<br />
<span style="mso-spacerun: yes;"> </span>args = element.args();<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<span style="font-family: "Courier New", Courier, monospace;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span></span><span style="font-family: "Courier New", Courier, monospace;"><span style="color: #222222; font-family: "Arial","sans-serif";">// get string
parameter</span></span><span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><br /><span style="font-family: "Courier New", Courier, monospace;">
<span style="mso-spacerun: yes;"> </span><string> = args.parm();<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<span style="font-family: "Courier New", Courier, monospace;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span><span style="color: #222222; font-family: "Arial","sans-serif";">// get object
parameter</span></span></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #222222; font-family: "Arial","sans-serif";"></span></span><span style="font-family: "Courier New", Courier, monospace;"><span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span><object>
= args.parmObject();<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<span style="font-family: "Courier New", Courier, monospace;">
<span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span></span><span style="font-family: "Courier New", Courier, monospace;"><span style="color: #222222; font-family: "Arial","sans-serif";">// get
enum parameter<br />
</span><span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span></span><span style="font-family: "Courier New", Courier, monospace;"><span style="color: #222222; font-family: "Arial","sans-serif";">if(
element.args().parmEnumType() == EnumNum( <EnumName>) )<br />
</span><span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span></span><span style="font-family: "Courier New", Courier, monospace;"><span style="color: #222222; font-family: "Arial","sans-serif";">{<br />
</span><span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span></span><span style="font-family: "Courier New", Courier, monospace;"><span style="color: #222222; font-family: "Arial","sans-serif";"><span style="mso-spacerun: yes;"> </span><enum contol/variable> <span style="mso-spacerun: yes;"> </span>=( element.args().parmEnum() );<br />
</span><span lang="EN" style="font-family: "Courier New"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><span style="mso-spacerun: yes;"> </span></span><span style="color: #222222; font-family: "Arial","sans-serif";">}</span></span></div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #222222; font-family: "Arial","sans-serif";"></span></span><span style="color: #222222; font-family: "Arial","sans-serif"; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><span style="font-family: "Courier New", Courier, monospace;">}</span></span><br />
<span style="color: #222222; font-family: "Arial","sans-serif"; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">
</span><br />
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">3.</span><span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;">
</span></span></span><span style="font-family: Calibri;">There are many parameters
that you need to pass to the child form.<o:p></o:p></span></div>
<div style="text-align: justify;">
<span style="font-family: Calibri;">In that scenario, you need to create an extra class (parameter/contract
class), you can first set the parameters in the init method for that class, use
the parmObject for setting and gets the object on the child form<o:p></o:p></span></div>
<br />
<div class="MsoListParagraph" style="background: white; margin: 0in 0in 12pt 0.5in;">
<br /></div>
<br />
<div class="MsoNormal" style="background: white; margin: 0in 0in 12pt 0.25in;">
<br /></div>
<br />
<div class="MsoNoSpacing" style="margin: 0in 0in 0pt 0.5in;">
<br /></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com12tag:blogger.com,1999:blog-2033061858901462781.post-91316172096696339482012-01-29T23:08:00.001+05:002012-01-30T01:13:49.071+05:00override canSubmitToWorkflow() method of list page form in ax 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="font-size: large;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><strong>Q</strong>: </span><span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">How can we override canSubmitToWorkflow()
method of list page form in ax 2012 as there is no method to modify</span><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"> (template
type is listpage). The requirement is to create a form and to enable workflow
for both client and EP<o:p></o:p></span></span><br />
<span style="font-size: large;"><br /></span><br />
<div style="text-align: justify;">
<span style="font-size: large;"><span lang="EN" style="font-family: "Calibri","sans-serif"; mso-ansi-language: EN; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><strong>Answer</strong>: If you want to enable workflow on a
listpage (Client, EP), but you need to override the canSubmitToWorkflow method
at the table level. In AX 2012 the listpage are deployed and rendered on EP on
a single click so the best practice is to use the templateType == listpage, to
make sure that both the client and EP provides the same functionality.</span><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><o:p></o:p></span></span></div>
<u1:p></u1:p><span style="font-size: large;">
</span><br />
<div class="MsoNormal" style="margin: 0in 0in 12pt;">
<br /></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com0tag:blogger.com,1999:blog-2033061858901462781.post-57354426332146158692012-01-29T22:36:00.000+05:002012-01-29T22:37:01.173+05:00Coding standards of dynamics AX X++<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-align: justify;">
<span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">I have read an
article about the </span><a href="http://www.packtpub.com/article/technical-best-practices-for-dynamics-ax-shared-and-aot-object-standards"><span style="color: red; font-family: Calibri;">technical
standard</span></a><span style="font-family: Calibri;"> to write the code in dynamics ax, that covered the followed
standards. <o:p></o:p></span></span></div>
<span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">X++ Standards<o:p></o:p></span></span><br />
<br />
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Text Constant Standards</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Exception Handling</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Branching</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Code Layout</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Methods</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Handling Dates</span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 12pt 0.5in; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Label Standards</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-align: justify;">
<span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">AOT Object
Standards<o:p></o:p></span></span></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Data Dictionary Extended data type<o:p></o:p></span></span></div>
<br />
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; mso-add-space: auto; mso-list: l0 level2 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: "Courier New"; font-size: 12pt; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Base Enum</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; mso-add-space: auto; mso-list: l0 level2 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: "Courier New"; font-size: 12pt; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Tables</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; mso-add-space: auto; mso-list: l0 level2 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: "Courier New"; font-size: 12pt; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Feature keys</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 1in; mso-add-space: auto; mso-list: l0 level2 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: "Courier New"; font-size: 12pt; mso-fareast-font-family: "Courier New";"><span style="mso-list: Ignore;">o<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Table collection<o:p></o:p></span></span></div>
<br />
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Classes</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Forms</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Reports</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Jobs</span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 12pt 0.5in; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Menu items</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-align: justify;">
<span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">The links is
quite handful for the AX developers especially for those who are working for a vendor
of Microsoft like me.<o:p></o:p></span></span></div>
</div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1tag:blogger.com,1999:blog-2033061858901462781.post-1278674258683258112012-01-29T22:26:00.000+05:002012-01-30T01:21:08.838+05:00type of users in Dynamics AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;"><strong>Question</strong>: How
many type of users are in Dynamics AX 2012 and what are their duties?<o:p></o:p></span></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-align: justify;">
<span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;"><strong>Answer</strong>: There are
four types of user in AX 2012 (I have copy the matter from a </span><a href="http://www.google.com.pk/url?sa=t&rct=j&q=difference%20between%20the%20functional%20user%20and%20enterprise%20user%20in%20ax&source=web&cd=1&ved=0CCAQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F3%2FD%2F7%2F3D7C4FAC-A971-4078-9909-E05EB619EE7F"><span style="color: #473624; font-family: Calibri;">link</span></a><span style="font-family: Calibri;">)</span></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0pt 0.5in; mso-list: l3 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="color: #333333; font-family: "Tahoma","sans-serif"; font-size: 8.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Tahoma;"><span style="mso-list: Ignore;">1.<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Enterprise</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l3 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="color: #333333; font-family: "Tahoma","sans-serif"; font-size: 8.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Tahoma;"><span style="mso-list: Ignore;">2.<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Functional</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin: 0in 0in 0pt 0.5in; mso-list: l3 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="color: #333333; font-family: "Tahoma","sans-serif"; font-size: 8.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Tahoma;"><span style="mso-list: Ignore;">3.<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Task </span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 12pt 0.5in; mso-list: l3 level1 lfo1; text-align: justify; text-indent: -0.25in;">
<span style="color: #333333; font-family: "Tahoma","sans-serif"; font-size: 8.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Tahoma;"><span style="mso-list: Ignore;">4.<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-size: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Self Server </span></span></div>
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Enterprise User:</span></span></b><br />
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Unrestrictive access to setup, administer all
parameters and functional processes across the enterprise. Key Roles whose work
impacts multiple users’ activities or tasks such as budgeting, forecasting,
planning or scheduling <o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Manage complete cross organizational activities
and business including: Legal, Financial, Payroll, Compensation & Benefits
and IT <o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Setting up and Defining Organizations, Business
Unit, departments, divisions, Positions, and employee Jobs <o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Access to all Manufacturing Roles and functions
excluding Shop Floor Control and Quality Management <o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Managing cross organizational processes <o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Approving professional user processes <o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 12pt; text-align: justify;">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="font-family: Calibri;">Functional Users:</span></span></b> </div>
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Manage a set of activities in the process to
create, fabricate, sell, deliver, or support the product or the service sold by
their company.</span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Manage a shop floor within a production or
manufacturing cycle.<o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Manage a set of projects and related services
incl. the management of relevant resources.<o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Manage HR cycles: Recruitment, Trainings, and
On/Off boarding of employees.<o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Manage budget transfers and requests pertaining
to his / her operational department, division, or unit.<o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Create applicants / employee master data records;
create a job or a position requisition within the organization. <o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Raise invoices pertaining to their clients.<o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Approve Vendor invoices or voucher for rendered
services.<o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Create and Manage master data records pertaining
to their Customers, Vendors, as well as their product inventory or catalog.<o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Approver of Self Serve or Task Users. <o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in;">
<b style="mso-bidi-font-weight: normal;"><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Functional
Users do not and cannot perform (these are completed by Enterprise Users): <o:p></o:p></span></b></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">ERP system setup, Data base setup or reports
customizations.<o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Functions related to setting up (System
Configuration) projects, productions, services or financial parameters
(Product, Inventory, projects, production, route, service grouping, etc.) <o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">financial Transactions related to Employee
Payroll, Customer and vendor settlements, payments, credits, checks, cash
dispenses, all Accounting functions & activities </span></div>
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l1 level1 lfo2; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">transaction spanning cross Business Units or
Legal entities processes: Budgeting and Resourcing <o:p></o:p></span></div>
<br />
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt;"><span style="font-family: Calibri;">Task User:<o:p></o:p></span></span></b><br />
<span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Users access the system to: </span><br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo3; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Enter billable time (Project Activities,
Production card, etc.) </span></div>
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo3; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Billable expenses (project and other types) </span></div>
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo3; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Performance management and goal setting, annual
reviews, etc. <o:p></o:p></span></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt;">
<b style="mso-bidi-font-weight: normal;"><span style="color: windowtext; font-family: "Calibri","sans-serif"; font-size: 14pt; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Self
Serve User:<o:p></o:p></span></b></div>
<br />
<div class="Default" style="margin: 0in 0in 0pt 0.5in; mso-list: l2 level1 lfo4; text-indent: -0.25in;">
<span style="color: windowtext; font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="color: windowtext; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Employee Self Serve Discrete Scenarios (Payroll
Clock In/Out, Expense Report, Personal Data, Time & Attendance, Personal
Service Requisitions<o:p></o:p></span></div>
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Calibri","sans-serif"; font-size: 11pt; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">
</span></b></div>Arsalan Gulzarhttp://www.blogger.com/profile/02423058021246542971noreply@blogger.com1