tag:blogger.com,1999:blog-22941406441443522102024-03-21T07:27:33.133+04:00Axapta/D365 Corner...World of AX KnowledgeJitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.comBlogger72125tag:blogger.com,1999:blog-2294140644144352210.post-3699290978979601412020-03-28T16:39:00.000+04:002020-03-28T16:41:58.921+04:00D365 FO upgrade from AX 2012 R2:<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="font-family: Calibri; font-size: 11pt; margin: 0in;">
<span style="font-weight: bold;">D365 FO upgrade from AX 2012 R2:</span></div>
<div style="font-family: Calibri; font-size: 11pt; margin: 0in;">
<br /></div>
<div style="font-family: Calibri; font-size: 11pt; margin: 0in;">
I am going to explain technical work stream for D365 FO upgrade from AX 2012 R2.</div>
<div style="font-family: Calibri; font-size: 11pt; margin: 0in;">
<br /></div>
<div style="font-family: Calibri; font-size: 11pt; margin: 0in;">
Below steps is high level points for the upgrade however I will post other articles for each major steps which required detail information.<span style="font-size: 11pt;"> </span></div>
<div style="font-family: Calibri; font-size: 11pt; margin: 0in;">
<br /></div>
<ol style="direction: ltr; font-family: Calibri; font-size: 11pt; margin-bottom: 0in; margin-left: 0.375in; margin-top: 0in; unicode-bidi: embed;" type="1">
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;" value="1"><span style="font-size: 11pt;">As part of the prerequisite Install KB 4048614 and Install latest cumulative update before starting any upgrade activity.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Analyze and Identify all CRs and SSRS report which not required or deprecated in D365.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Cleanup any CRs or functionality in AX 2012 which is not being used which will help to reduce upgrade cost and upgrade time as well.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Configure LCS .</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Configure DevOps.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Create test cases and process including ISV in BPML(Business process modular library )in LCS.</span></li>
</ol>
<ol style="direction: ltr; font-family: Calibri; font-size: 11pt; margin-bottom: 0in; margin-left: 0.375in; margin-top: 0in; unicode-bidi: embed;" type="1">
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;" value="7"><span style="font-size: 11pt;">Run upgrade analysis: estimate the AX 2012 preparation work.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Run code upgrade tile: estimate the code upgrade work.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Analyze LCS output report from LCS and find out over layered and conflict objects which will be base during code upgrade.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Run LCS code upgrade tool with "only estimation" check box unchecked and then LCS will create report and also create work items and repository in the DevOps.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Map DevOps repository with Dev VS to start code upgrade.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Next is to start code upgrade and then data upgrade however this approach is good if you have less customization and you can follow water fall model. But if there is huge customization and want reduce the project duration then follow below steps.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">As part of data upgrade work first on schema based objects Like EDT, Enum, Table and view.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Work on overlaying and conflict objects all above related objects add all these objects in a separate model and move to Dev folder.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Map this Dev folder with D365 Dev instance and start data upgrade task parallel to the code upgrade for other object type and it will save significant time in overall project and also enable and involve early in the team to start functional validation after data and code upgrade.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Also we can Fast track or crash code upgrade duration by adding more resources in the project. However adding more developers for code upgrade we need extra precautions, setup and control to avoid further code conflict which I will discuss in the separate post.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">There are two part in code upgrade first one to work on overlaying and conflict objects by creating extension in the system ,secondly to check added code and objects after system is compiled with no error because after adding code we can not check objects from front end as there are errors in the system.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">During the code upgrade source ISV can be ignored and after successful code upgrade D365 compatible ISV package need to added in D365 through source control so that ISV related data can be upgraded during data upgrade.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">During data upgrade most of the errors are due to duplicate records and ISV related errors. So its good practice to discuss with ISV vendor and cleanup orphan and stranded data before starting data upgrade to avoid any ISV related errors.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Once code upgrade and data upgrade are completed functional testing can be started. However, if code upgrade completed before data upgrade then functional team can start CR testing with Std data so that any bug/issue can be highlighted in advance and fixed before actual functional testing.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">First data upgrade is the part of development data upgrade which used to identify duration of each step and any error so that these orphan or duplicate data can be cleaned in AX 2012 production before starting next data upgrade in UAT. Also this data upgrade will help for functional testing before UAT.</span></li>
<li style="margin-bottom: 0px; margin-top: 0px; vertical-align: middle;"><span style="font-size: 11pt;">Its always recommended to do Mock cut over to simulate actual production data upgrade.</span></li>
</ol>
<div>
<span style="font-family: calibri;"><span style="font-size: 14.6667px;"><br /></span></span></div>
<div>
<span style="font-family: calibri;"><span style="font-size: 14.6667px;">#Stay Happy #Stay tune</span></span></div>
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-66272776176587225722019-07-08T19:27:00.001+04:002019-07-08T19:27:47.980+04:00How to add document note in D365<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;">class</span><span style="font-family: Consolas; margin: 0px;"> </span><span style="font-family: Consolas; margin: 0px;">VendAccountDocument_JKS</span></span><span style="font-family: Consolas; margin: 0px;"></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;">{</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<br /></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span></span><span style="font-family: Consolas; margin: 0px;">static</span><span style="font-family: Consolas; margin: 0px;"> </span><span style="font-family: Consolas; margin: 0px;">void</span><span style="font-family: Consolas; margin: 0px;"> main(</span><span style="font-family: Consolas; margin: 0px;">Args</span><span style="font-family: Consolas; margin: 0px;"> _args)</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;"><span style="margin: 0px;"> </span>{</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span></span><span style="font-family: Consolas; margin: 0px;">VendTable</span><span style="font-family: Consolas; margin: 0px;"> vendTable;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span></span><span style="font-family: Consolas; margin: 0px;">DocuType</span><span style="font-family: Consolas; margin: 0px;"> docuType;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span></span><span style="font-family: Consolas; margin: 0px;">DocuRef</span><span style="font-family: Consolas; margin: 0px;"> docuRef;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span>vendTable = </span><span style="font-family: Consolas; margin: 0px;">VendTable</span><span style="font-family: Consolas; margin: 0px;">::find(</span><span style="font-family: Consolas; margin: 0px;">'BRMF-000001'</span><span style="font-family: Consolas; margin: 0px;">);</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span>docuType = </span><span style="font-family: Consolas; margin: 0px;">DocuType</span><span style="font-family: Consolas; margin: 0px;">::find(</span><span style="font-family: Consolas; margin: 0px;">'Note'</span><span style="font-family: Consolas; margin: 0px;">);</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span></span><span style="font-family: Consolas; margin: 0px;">if</span><span style="font-family: Consolas; margin: 0px;"> (!docuType ||</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span>docuType.TypeGroup != </span><span style="font-family: Consolas; margin: 0px;">DocuTypeGroup</span><span style="font-family: Consolas; margin: 0px;">::Note)</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;"><span style="margin: 0px;"> </span>{</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span></span><span style="font-family: Consolas; margin: 0px;">throw</span><span style="font-family: Consolas; margin: 0px;"> error(</span><span style="font-family: Consolas; margin: 0px;">"Invalid document type"</span><span style="font-family: Consolas; margin: 0px;">);</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;"><span style="margin: 0px;"> </span>}</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;"><span style="margin: 0px;"> </span>docuRef.RefCompanyId =
vendTable.dataAreaId;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;"><span style="margin: 0px;"> </span>docuRef.RefTableId = vendTable.TableId;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;"><span style="margin: 0px;"> </span>docuRef.RefRecId = vendTable.RecId;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;"><span style="margin: 0px;"> </span>docuRef.TypeId = docuType.TypeId;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span>docuRef.Name = </span><span style="font-family: Consolas; margin: 0px;">'Automatic note'</span><span style="font-family: Consolas; margin: 0px;">;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span>docuRef.Notes = </span><span style="font-family: Consolas; margin: 0px;">'Added from X++'</span><span style="font-family: Consolas; margin: 0px;">;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;"><span style="margin: 0px;"> </span>docuRef.insert();</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: white;"><span style="font-family: Consolas; margin: 0px;"><span style="margin: 0px;"> </span>info(</span><span style="font-family: Consolas; margin: 0px;">"Document
note has been added successfully"</span><span style="font-family: Consolas; margin: 0px;">);</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="font-family: Consolas; margin: 0px;"><span style="color: white;"><span style="margin: 0px;"> </span>}</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<br /></div>
<br />
<div style="margin: 0px 0px 13.33px;">
<span style="font-family: Consolas; line-height: 115%; margin: 0px;"><span style="color: white;">}</span></span></div>
<b></b><i></i><u></u><sub></sub><sup></sup><strike></strike><span style="color: black;"></span><span style="color: white;"></span></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-12572242982489938992019-07-08T19:20:00.000+04:002019-07-13T09:19:39.774+04:00How to read excel and update record in AX2012 :<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;">static void POCUpdatePurchaseDetails_JS(Args _args)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;">{</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> SysExcelApplication application;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> SysExcelWorkbooks workbooks;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> SysExcelWorkbook workbook;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> SysExcelWorksheets worksheets;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> SysExcelWorksheet worksheet;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> SysExcelCells cells;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> COMVariantType type;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> Dialog dialog = new Dialog("Excel upload utility");</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> dialogField dialogFilename;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> int row;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> int totalUpdatedRecord = 0;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> FileName filename;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> InventTable inventTable;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> ItemId itemId;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> ItemGroup itemGroup;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> InventTableModule inventTableModule;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> ;</span><br />
<span style="font-family: inherit; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> application = SysExcelApplication::construct();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> workbooks = application.workbooks();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> dialogFilename = dialog.addField(extendedTypeStr(FilenameOpen),"@SYS53125");</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> dialog.filenameLookupTitle("Update data from excel file");</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> dialog.filenameLookupFilter(["@SYS28576",'*XLSX', "@SYS28576",'*XLS']);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> if (!dialog.run())</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> return;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> filename = dialogFilename.value();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> try</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> workbooks.open(filename);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> catch (Exception::Error)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> throw error("File cannot be opened.");</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> workbook = workbooks.item(1);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> worksheets = workbook.worksheets();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> worksheet = worksheets.itemFromNum(1);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> cells = worksheet.cells();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> row=1;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> do</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> row++;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> itemId = cells.item(row, 1).value().bStr();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> ttsbegin;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> inventTable = InventTable::find(itemId,true);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> inventTableModule=InventTableModule::find(inventTable.ItemId,ModuleInventPurchSales::Purch,true);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> if (inventTable)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> inventTableModule.Price=str2num(cells.item(row, 2).value().bStr());</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> inventTableModule.PriceUnit=str2num(cells.item(row, 3).value().bStr());</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> inventTableModule.update();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> totalUpdatedRecord++;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> ttscommit;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> type = cells.item(row+1, 1).value().variantType();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> while (type != COMVariantType::VT_EMPTY);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> application.quit();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;"> info(strFmt('Data updated, total record=%1 record',totalUpdatedRecord));</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit; font-size: xx-small;">}</span></div>
<div class="separator" style="clear: both;">
</div>
<b></b><i></i><u></u><sub></sub><sup></sup><strike></strike><br /></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-81426816230126259112019-07-08T18:31:00.000+04:002019-07-08T19:34:23.361+04:00How to find SQL query in D365:<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: #f3f3f3; font-family: "arial" , "sans-serif"; margin: 0px;">How to find SQL query out of the AOT query:</span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: #f3f3f3; font-family: "arial" , "sans-serif"; margin: 0px;"><br />
<span style="-webkit-text-stroke-width: 0px; float: none; margin: 0px; orphans: 2; word-spacing: 0px;">static void AOTQuery(Args _args)<br />
<span style="-webkit-text-stroke-width: 0px; float: none; margin: 0px; orphans: 2; word-spacing: 0px;">{</span></span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: #f3f3f3; font-family: "arial" , "sans-serif"; margin: 0px;"><span style="-webkit-text-stroke-width: 0px; float: none; margin: 0px; orphans: 2; word-spacing: 0px;"> QueryRun queryRun;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: #f3f3f3; font-family: "arial" , "sans-serif"; margin: 0px;"><span style="-webkit-text-stroke-width: 0px; float: none; margin: 0px; orphans: 2; word-spacing: 0px;"> ;</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: #f3f3f3; font-family: "arial" , "sans-serif"; margin: 0px;"><span style="-webkit-text-stroke-width: 0px; float: none; margin: 0px; orphans: 2; word-spacing: 0px;"> queryRun = new Quer<span style="-webkit-text-stroke-width: 0px; float: none; margin: 0px; orphans: 2; word-spacing: 0px;">yRun(queryStr(QueryName));//add
any name of query here in place of QueryName</span></span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: #f3f3f3; font-family: "arial" , "sans-serif"; margin: 0px;"><span style="-webkit-text-stroke-width: 0px; float: none; margin: 0px; orphans: 2; word-spacing: 0px;">
info(queryRun.query().toString());</span></span></div>
<br />
<div style="line-height: normal; margin: 0px;">
<span style="color: #f3f3f3; font-family: "arial" , "sans-serif"; margin: 0px;"><span style="-webkit-text-stroke-width: 0px; float: none; margin: 0px; orphans: 2; word-spacing: 0px;">}</span></span></div>
<span style="-webkit-text-stroke-width: 0px; float: none; orphans: 2; word-spacing: 0px;"></span><b></b><i></i><u></u><sub></sub><sup></sup><strike></strike></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-18521460391678257422019-07-08T18:22:00.000+04:002019-07-08T19:35:00.229+04:00Create Query dynamically in AOT through code:<div dir="ltr" style="text-align: left;" trbidi="on">
Create Query dynamically in AOT through code:<br />
<br />
static void CreateQueryInAOT(Args _args)<br />
{<br />
TreeNode treeNodeObj;<br />
Query queryObj; // Extends TreeNode class.<br />
QueryBuildDataSource qbds;<br />
QueryBuildRange qbr;<br />
QueryRun qr;<br />
CustTable xrecCustTable;<br />
str queryName = "TestQuery";<br />
// Macro.<br />
#AOT<br />
// Delete the query from the AOT, if the query exists.<br />
treeNodeObj = TreeNode::findNode(#QueriesPath);<br />
treeNodeObj = treeNodeObj.AOTfindChild(queryName);<br />
if (treeNodeObj) { treeNodeObj.AOTdelete(); }<br />
// Add the query to the AOT.<br />
treeNodeObj = TreeNode::findNode(#QueriesPath);<br />
treeNodeObj.AOTadd(queryName);<br />
queryObj = treeNodeObj.AOTfindChild(queryName);<br />
// Further define the query.<br />
qbds = queryObj.addDataSource(tablenum(CustTable));<br />
qbr = qbds.addRange(fieldnum(CustTable, CustGroup));<br />
qbr.value("Inter");<br />
// Compile the query.<br />
queryObj.AOTcompile(1);<br />
queryObj.AOTsave();<br />
// Run the query.<br />
qr = new QueryRun("TestQuery");<br />
while ( qr.next() )<br />
{<br />
xrecCustTable = qr.GetNo(1); // 1 means first data source.<br />
Global::info(strFmt("%1 , %2",<br />
xrecCustTable.AccountNum, xrecCustTable.CustGroup));<br />
} </div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-3998799100332412412019-06-23T14:24:00.001+04:002019-07-08T19:35:29.790+04:00Saving last value on the form<div dir="ltr" style="text-align: left;" trbidi="on">
We can save last value on the form in AX so that when next time form will open it will show last saved value in the certain control:<br />
<br />
We will take example to save value of below mark control on inventory counting form:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/--MbKW8cYQKo/XQ9Q2uvcSpI/AAAAAAAAAcA/Xo1-Ua5v82kBH7hkuOQ1-uCSjLcwEXm2gCLcBGAs/s1600/AllOpenPosted.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="83" data-original-width="561" src="https://1.bp.blogspot.com/--MbKW8cYQKo/XQ9Q2uvcSpI/AAAAAAAAAcA/Xo1-Ua5v82kBH7hkuOQ1-uCSjLcwEXm2gCLcBGAs/s1600/AllOpenPosted.png" /></a></div>
<br />
Below are the steps to enable this functionality:<br />
1. Add below code snippet in class declaration:<br />
<br />
AllOpenPosted allOpenPostedTrans<br />
#define.CurrentVersion(1)<br />
#localmacro.CurrentList<br />
allOpenPostedTrans<br />
#endmacro<br />
<br />
2. Add below methods on the InventJournalTable form:<br />
<br />
//To save default value in case if no last value available<br />
public void initParmDefault()<br />
{<br />
allOpenPostedTrans= AllOpenPosted::All;<br />
}<br />
<br />
//To convert object to container<br />
public container pack()<br />
{<br />
return [#CurrentVersion, #CurrentList];<br />
}<br />
<br />
//To convert container to object<br />
public boolean unpack(container _packedClass)<br />
{<br />
int version = RunBase::getVersion(_packedClass);<br />
switch (version)<br />
{<br />
case #CurrentVersion:<br />
[version, #CurrentList] = _packedClass;<br />
return true;<br />
default:<br />
return false;<br />
}<br />
return false;<br />
}<br />
<br />
//To save last design name<br />
public IdentifierName lastValueDesignName<br />
{<br />
return element.args().menuItemName();<br />
}<br />
<br />
//To save last value<br />
public IdentifierName lastValueElementName<br />
{<br />
return this.name();<br />
}<br />
<br />
//To save valueType in this case Form<br />
public UtilElementType lastValueType()<br />
{<br />
return UtilElementType::Form;<br />
}<br />
<br />
//To store User Id<br />
public UserId lastValueUserId()<br />
{<br />
return curUserId();<br />
}<br />
<br />
//To save Legal entity details<br />
public DataAreaId lastValueDataAreaId()<br />
{<br />
return curext();<br />
}<br />
3. Add below code in Run(above Super) and Close(last in method) form's method:<br />
Run:<br />
<span class="fontstyle0">xSysLastValue::getLast(this);<br />AllOpenPosted.selection(allOpenPostedTrans );</span><br />
<br />
Close:<br />
<span class="fontstyle0">allOpenPostedTrans = AllOpenPosted.selection();<br />xSysLastValue::saveLast(this);</span><br />
<br />
Compile and open form change value in the "show " control and close form next time form will open with last value in the show field.<br />
<br />
I hope this will help !!!!<br />
<br />
<br />
<span style="font-family: "consolas";"><br /></span>
<br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><br /></span><span style="font-family: "consolas";"><br /></span><br />
<span style="font-family: "consolas";"><br /></span>
<br />
<div>
<br /></div>
</div>
<br /></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-50292497047086208592019-06-23T12:07:00.001+04:002019-06-23T12:15:06.818+04:00Create dialog run time and update respective record on Dialog<div dir="ltr" style="text-align: left;" trbidi="on">
Below are the method to create Dialog dynamically, inter value, fetch value from dialog and update dialog field automatically :<br />
<br />
class DialogDemo extends RunBase<br />
{<br />
DialogField fieldAccount;<br />
DialogField fieldName; <br />
DialogField fieldGroup;<br />
VendAccount vendAccount;<br />
VendName vendName;<br />
VendGroupId vendGroupId;<br />
<br />
}<br />
<br />
//Convert object to container<br />
Public Container pack()<br />
{ <br />
return conNull();<br />
}<br />
<br />
//Convert container to object<br />
Public boolean unpack(container _packedClass)<br />
{<br />
return true;<br />
}<br />
<br />
// Dialog layout<br />
Object dialog()<br />
{<br />
Dialog dialog;<br />
dialog = super();<br />
dialog.caption("Customer information");<br />
dialog.allowUpdateOnSelectCtrl(true);<br />
fieldAccount=dialog.addField(Extendedtypestr(VendAccount),"Vendor Account");<br />
fieldName=dialog.addField(Extendedtypestr(VendName));<br />
fieldName.enabled(false);<br />
dialog.addTabPage("Details");<br />
fieldgroup=dialog.addField(Extendedtypestr(vendGroupId));<br />
fieldgroup.enabled(false);<br />
return dialog;<br />
<br />
}<br />
<br />
//Fetch value from Dialog<br />
public boolean getFromDialog()<br />
{<br />
vendAccount=fieldAccount.value(); <br />
vendName=fieldName.value();<br />
vendGroupId=fieldGroup.value();<br />
return super();<br />
}<br />
<br />
public static void main(Args _args)<br />
{<br />
DialogDemo dialogDemo= new DialogDemo();<br />
if(DialogDemo.prompt())<br />
{<br />
DialogDemo.run();<br />
}<br />
}<br />
//field value assignment<br />
public void dialogSelectCtrl()<br />
{<br />
VendTable vendTable;<br />
vendTable=vendTable::find(fieldAccount.value());<br />
fieldName.value(vendTable.name());<br />
fieldGroup.value(vendTable.VendGroup);<br />
<br />
}<br />
<br />
//To execute logic<br />
Public void run()<br />
{<br />
info(strFmt("Vend Account: %1", vendAccount));<br />
info(strFmt("Vend Name: %1", vendName));<br />
info(strFmt("Vend Group: %1", vendGroupId));<br />
}</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-79981396814451641032019-01-05T17:54:00.003+04:002019-01-08T09:16:37.239+04:00Error after clicking on “ Show all fields” in Dynamics AX<div dir="ltr" style="text-align: left;" trbidi="on">
Recently i noticed that "show all fields" functionality is not working on Vendor Inter company form. After further investigation i came to know that this functionality is working on most of the form . However, for few forms it through below error.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-bap3SdhZgN4/XDQuJj81f0I/AAAAAAAAAaA/pBlrdLYHRBE05XGl44gSEoe5FX_H_qiBwCLcBGAs/s1600/Error.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="439" data-original-width="355" src="https://4.bp.blogspot.com/-bap3SdhZgN4/XDQuJj81f0I/AAAAAAAAAaA/pBlrdLYHRBE05XGl44gSEoe5FX_H_qiBwCLcBGAs/s1600/Error.png" /></a></div>
<br />
I do some research and find that there is a bug in system in below method.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-D3_HygEXeq0/XDQumIddcAI/AAAAAAAAAaI/f8t1RPp2StQ3431fyEhzkbGeLhtO01YTACLcBGAs/s1600/SysRecordInfo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="613" data-original-width="756" src="https://4.bp.blogspot.com/-D3_HygEXeq0/XDQumIddcAI/AAAAAAAAAaI/f8t1RPp2StQ3431fyEhzkbGeLhtO01YTACLcBGAs/s1600/SysRecordInfo.png" /></a></div>
<br />
This is bug in system. Actually any form name can not be more than 40 char. but in our case '_ShowAllRecords_'+dictTable.name() is 55 char (InterCompanyTradingRelationSetupCustomer(40), _ShowAllRecords(15)) and hence system throw above error.<br />
<br />
As work around I removed _ShowAllRecords and now this functionality is working for intercompany form.<br />
<br />
Secondly there is also few KB in LCS that can be explored for permanent solution.<br />
<br />
I hope above post help to resolve this issue.<br />
<br /></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-904009036360386372019-01-05T17:53:00.002+04:002019-06-13T14:48:48.628+04:00Passing parameter between forms in Dynamics AX<div dir="ltr" style="text-align: left;" trbidi="on">
<b>How to: Pass Args from one form to another form in AX
2012</b><br />
<br />
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
<span style="font-family: inherit;">Passing parameter from one form to another is easy in
AX and this concept help a lot during development and it can be achieved through Args class.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">I am going to demonstrate below simple example to understand how
Args works and what are the different options available in dynamics AX.<o:p></o:p></span><br />
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">Form1: POCVehicleForm<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">Form2: POCInsuranceMaster <span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">And there is one common field vehicleId in both data source.
<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">Task1: Pass record, string value and enum value from Form1
to Form2.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">Task2: Filter data on form 2 according to the vehicle Id
from form one.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">Solution: Added one button on the POCVehicleForm to pass
value on POCInsuranceMaster form. <o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">Add below code snippet on "Insurance Master" clicked method on POCVehicleForm
.</span></div>
<div class="MsoNormal">
<span style="font-family: inherit;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;">void clicked()<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;">{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>MenuFunction<span style="mso-spacerun: yes;"> </span>mf;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>Args<span style="mso-spacerun: yes;"> </span>args;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>FormRun<span style="mso-spacerun: yes;"> </span>formRun;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>//Initialise Args<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>args= new Args();<o:p></o:p></span><br />
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>//Pass record <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>args.record(POCVehicle);<o:p></o:p></span><br />
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>//Pass string value "Vehicle Id" <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>args.parm(Grid_VehicleId.valueStr());<span style="mso-spacerun: yes;"> </span></span><br />
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>//Pass Enam value<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>args.parmEnum(VehicleType::Truck);<o:p></o:p></span><br />
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>//Pass enum type<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>args.parmEnumType(enumNum(VehicleType));<o:p></o:p></span><br />
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>formRun=ClassFactory.formRunClass(args);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>formRun.init();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>formRun.run();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>formRun.wait();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;">}</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-0RAu_F7pd08/XQIpYK8n61I/AAAAAAAAAbs/xGFXIWK72aAuszJXGfN7JpNr51uQsVlOwCLcBGAs/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="395" data-original-width="628" src="https://1.bp.blogspot.com/-0RAu_F7pd08/XQIpYK8n61I/AAAAAAAAAbs/xGFXIWK72aAuszJXGfN7JpNr51uQsVlOwCLcBGAs/s1600/11.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">Add below code snippet on POCInsurance’s init method.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;">public void init()<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;">{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>POCVehicle<span style="mso-spacerun: yes;"> </span>pocVehicle;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>Query<span style="mso-spacerun: yes;"> </span>query;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>super();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"> // Get record buffer</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>pocVehicle=element.args().record();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span><br />
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"><br /></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> // Validate if parameter is not null and record belong to right table </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>if(element.args() &&
element.args().record().TableId== tableNum(POCVehicle))<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span><br />
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> // Filter data according to the Vehicle ID </span>POCInsurenceMaster_ds.query().dataSourceName('POCInsurenceMaster').addRange(fieldNum(PO CInsurenceMaster,vehicleID)).value(SysQuery::value(pocVehicle.VehicleId));<o:p></o:p></span><br />
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> // Show String and enum value </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>info(strfmt("PARM:%1,PARMENUM:%2)",
element.args().parm(),element.args().parmEnum()));</span><span style="font-family: inherit;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: inherit;">}<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: inherit;">Below is the result after clicking on Insurance Master
button on POCVehicleForm</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-P_4Clhzcc_Y/XQIp-3fxX5I/AAAAAAAAAb0/pH5W-wQiusQan0NJOvx9aPVOmK9EjEHSQCLcBGAs/s1600/12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="290" data-original-width="552" src="https://1.bp.blogspot.com/-P_4Clhzcc_Y/XQIp-3fxX5I/AAAAAAAAAb0/pH5W-wQiusQan0NJOvx9aPVOmK9EjEHSQCLcBGAs/s1600/12.png" /></a></div>
<span style="font-family: inherit;"><br /></span><span style="font-family: inherit;">Below is the Args important methods:</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;"></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 604px;">
<colgroup><col style="mso-width-alt: 3840; mso-width-source: userset; width: 79pt;" width="105"></col>
<col style="mso-width-alt: 18249; mso-width-source: userset; width: 374pt;" width="499"></col>
</colgroup><tbody>
<tr height="20" style="height: 15.0pt;">
<td class="xl63" height="20" style="height: 15.0pt; width: 79pt;" width="105"><span style="color: blue;"><b>Args
Methods</b></span></td>
<td class="xl63" style="width: 374pt;" width="499"><span style="color: blue;"><b>Details</b></span></td>
</tr>
<tr height="20" style="height: 15.0pt;">
<td height="20" style="height: 15.0pt;">record</td>
<td>Get and set current or multiple record from caller table</td>
</tr>
<tr height="20" style="height: 15.0pt;">
<td height="20" style="height: 15.0pt;">caller</td>
<td>Get or set the instance of the caller object</td>
</tr>
<tr height="20" style="height: 15.0pt;">
<td height="20" style="height: 15.0pt;">parm</td>
<td>Get or sets string value including string field on caller form</td>
</tr>
<tr height="20" style="height: 15.0pt;">
<td height="20" style="height: 15.0pt;">parmEnum</td>
<td>Get or set enum value</td>
</tr>
<tr height="20" style="height: 15.0pt;">
<td height="20" style="height: 15.0pt;">name</td>
<td>Get and set the name of the application object to call</td>
</tr>
<tr height="20" style="height: 15.0pt;">
<td height="20" style="height: 15.0pt;">parmObject</td>
<td>Get or set an instance of any object to pass on called object like any
custom class </td>
</tr>
<tr height="20" style="height: 15.0pt;">
<td height="20" style="height: 15.0pt;">parmEnumType</td>
<td>Get or set enum name</td>
</tr>
</tbody></table>
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-10658770571860095252019-01-05T17:50:00.000+04:002019-01-07T11:58:09.536+04:00Passing parameter from Form to Class through Args in Dynamics AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<br /></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-61597579906544099652019-01-04T12:56:00.002+04:002019-01-05T17:10:15.409+04:00How to read excel and update record in AX2012 through X++ code<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";">static void POCUpdatePurchaseDetails_JS(Args _args)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";">{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>SysExcelApplication<span style="mso-spacerun: yes;">
</span>application;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>SysExcelWorkbooks<span style="mso-spacerun: yes;"> </span>workbooks;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>SysExcelWorkbook<span style="mso-spacerun: yes;"> </span>workbook;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>SysExcelWorksheets<span style="mso-spacerun: yes;">
</span>worksheets;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>SysExcelWorksheet<span style="mso-spacerun: yes;"> </span>worksheet;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>SysExcelCells<span style="mso-spacerun: yes;"> </span>cells;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>COMVariantType<span style="mso-spacerun: yes;"> </span>type;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>Dialog
dialog = new<span style="mso-spacerun: yes;"> </span>Dialog("Excel
upload utility");<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>dialogField<span style="mso-spacerun: yes;">
</span>dialogFilename;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>int row;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>int<span style="mso-spacerun: yes;"> </span>totalUpdatedRecord = 0;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>FileName<span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>filename;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>InventTable<span style="mso-spacerun: yes;">
</span>inventTable;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>ItemId<span style="mso-spacerun: yes;"> </span>itemId;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>ItemGroup<span style="mso-spacerun: yes;"> </span>itemGroup;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>InventTableModule<span style="mso-spacerun: yes;">
</span>inventTableModule;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>application = SysExcelApplication::construct();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>workbooks
= application.workbooks();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>dialogFilename = dialog.addField(extendedTypeStr(FilenameOpen),"@SYS53125");<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>dialog.filenameLookupTitle("Update data from excel file");<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>dialog.filenameLookupFilter(["@SYS28576",'*XLSX', "@SYS28576",'*XLS']);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>if (!dialog.run())<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>return;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>filename
= dialogFilename.value();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>try<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>workbooks.open(filename);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>catch
(Exception::Error)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>throw
error("File cannot be opened.");<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>workbook
= workbooks.item(1);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>worksheets = workbook.worksheets();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>worksheet
= worksheets.itemFromNum(1);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>cells =
worksheet.cells();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>row=1;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>do<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>row++;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>itemId = cells.item(row, 1).value().bStr();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>ttsbegin;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>inventTable = InventTable::find(itemId,true);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>inventTableModule=InventTableModule::find(inventTable.ItemId,ModuleInventPurchSales::Purch,true);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>if
(inventTable)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>inventTableModule.Price=str2num(cells.item(row, 2).value().bStr());<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>inventTableModule.PriceUnit=str2num(cells.item(row,
3).value().bStr());<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>inventTableModule.update();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>totalUpdatedRecord++;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>ttscommit;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>type
= cells.item(row+1, 1).value().variantType();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>while
(type != COMVariantType::VT_EMPTY);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;">
</span>application.quit();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";"><span style="mso-spacerun: yes;"> </span>info(strFmt('Data
updated, total record=%1 record',totalUpdatedRecord));<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "consolas";">}<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<br /></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-37113685440367237682019-01-03T18:33:00.002+04:002019-01-05T17:55:13.552+04:00Error while restarting AX 2012 service<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;"><b>Issue: </b>The database
Servername\ModelDatabase is not recognised as a model store<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;">Below error occurred
while restarting AX2012 service after database restore:<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;"> </span><a href="https://1.bp.blogspot.com/-GfwPicHslHQ/XC4bUi-OKbI/AAAAAAAAAZc/---sZRtDIQICBWFUeujqG322LqdcfhYAQCEwYBhgL/s1600/Error.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="193" data-original-width="457" height="135" src="https://1.bp.blogspot.com/-GfwPicHslHQ/XC4bUi-OKbI/AAAAAAAAAZc/---sZRtDIQICBWFUeujqG322LqdcfhYAQCEwYBhgL/s320/Error.png" width="320" /></a></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;"> </span><span style="font-family: "times new roman" , serif; font-size: 13.5pt;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;"><b>Event log error:</b></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;">Object Server 01:The
database Servername\ModelDatabase is not recognized as a model store</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;">Object Server
01: Fatal SQL condition during login. Error message:
"[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for
user “User name”<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;"><br />
<br />
<!--[if !supportLineBreakNewLine]--><br />
<!--[endif]--><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;"><b>Solution:</b> <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;">1. This issue happen
when service account do not have access on the database from where we took
backup. So simply AOS component can be uninstalled and installed again which
will fix the issue.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;">2. After database
refresh add AX service account in database security section and provide proper
permission which will fix the issue.<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;">login. Error message:
"[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for
user “User name”<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-8390502425469552712018-12-31T14:16:00.000+04:002018-12-31T14:16:07.090+04:00D365 Finance and Operations <div dir="ltr" style="text-align: left;" trbidi="on">
D365 Finance and Operations<span style="mso-spacerun: yes;"> </span>is the latest version of Microsoft Dynamics ERP. D365 Finance and Operations is a cloud based enterprise resource planning (ERP) service for enterprises and built on Microsoft Azure.<br />
<br />
<div class="MsoNormal">
D365 Finance and Operations facilitates and support customer's unique requirement and also provide the flexibility to modify ERP system to align their requirement to support operation in more effective and efficient way without any changes in operation processes.<br />
<br /></div>
<div class="MsoNormal">
Moreover, D365FO provide better platform through ERP functionality to run constantly changing business in competitive and challenging environment without hassle of maintaining infrastructure and software.</div>
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-78976093725947183262018-12-24T13:55:00.001+04:002019-01-05T17:12:57.408+04:00Refresh Caller form data source in AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: inherit;">Refresh Caller form data source:</span><br />
<span style="font-family: inherit;">Parent Form: POCVehicleForm</span><br />
<span style="font-family: inherit;">Child Form: POCInsurenceMaster</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">Write below code snippet on click method of button on POCVehicleForm</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">void clicked()</span><br />
<span style="font-family: inherit;">{</span><br />
<span style="font-family: inherit;"> MenuFunction mf;</span><br />
<span style="font-family: inherit;"> Args args;</span><br />
<span style="font-family: inherit;"> ;</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;"> args= new Args();</span><br />
<span style="font-family: inherit;"> args.record(POCVehicle);</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;"> mf=new MenuFunction(identifierStr(POCInsurenceMaster), MenuItemType::Display);</span><br />
<span style="font-family: inherit;"> mf.run(args);</span><br />
<span style="font-family: inherit;">}</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">Overwrite below method on POCInsurenceMaster:</span><br />
<span style="font-family: inherit;"><br /></span>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> public void closeOk()</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> {</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: "calibri";"><span style="font-family: inherit;"> #Task</span></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> FormRun formRun;</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> super();</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> // Buffer of
calling form.</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> formRun =
element.args().caller();</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> // Check if
caller is form</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> if(formRun)</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> {</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;">
formRun.task(#taskF5);</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> }</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: inherit;"> }<o:p></o:p><o:p></o:p></span><br />
<span style="font-family: inherit;"><span style="font-family: "calibri";"><br /></span>
<span style="font-family: "calibri";">Open POCInsurenceMaster from POCVehicleForm and once update record and close child form then parent form will be refreshed.</span></span></div>
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-20225143358303472772018-12-24T13:38:00.000+04:002019-01-05T17:55:55.494+04:00Update multiple record through MultiSelectionHelper class in AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<b><span style="font-family: inherit;">Main method of class:<o:p></o:p></span></b></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
</div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><b><span style="font-family: "consolas";">public</span></b><span style="font-family: "consolas";"> <b>static</b> <b>void</b>
main(Args args)<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;">{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>FormDataSource<span style="mso-spacerun: yes;"> </span>formDataSource;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>TableName<span style="mso-tab-count: 4;"> </span>tableName;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;">
</span>FormRun<span style="mso-spacerun: yes;">
</span>caller = args.caller();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;">
</span>MultiSelectionHelper<span style="mso-spacerun: yes;">
</span>helper = MultiSelectionHelper::createFromCaller(caller);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;">;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
</div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span><i>// Find correct form data source</i><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><b>for</b>
(i = <b>1</b>; i <= caller.dataSourceCount(); i++)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;">
</span>formDataSource = caller.dataSource(i);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
</div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><b>if</b>
(formDataSource.table() == <b>tableNum</b>(TableName))<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><b>break</b>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
</div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><i>//Create
ranges for the selected records</i><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;">
</span>helper.createQueryRanges(formDataSource.queryBuildDataSource(), <b>fieldStr</b>(TableName,
RecId));<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
</div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><i>// Traverse
the selected records</i><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>tableName
= helper.getFirst();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
</div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><b>ttsBegin</b>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>while(tableName)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-tab-count: 1;"> </span>//
Logic placeholder-Start<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-tab-count: 1;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-tab-count: 1;"> </span>//
Logic placeholder-End<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
</div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
</div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>tableName
= helper.getNext();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: inherit;"><span style="mso-spacerun: yes;"> </span><b>ttsCommit</b>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: "consolas";"><span style="font-family: inherit;">}</span><span style="font-family: "consolas"; font-size: 8pt;"><o:p></o:p></span></span></div>
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-83743998896774827602018-12-24T11:28:00.000+04:002019-01-07T12:01:52.325+04:00Update multiple selected records on form in AX 2012 through Class and Passing parameter from Form to Class<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: "consolas";">Passing parameter through Args in AX is very easy important functionality. To demonstrate this i used one form and added one button to call class.</span><br />
<span style="font-family: "consolas";">Below are the artefacts:</span><br />
<span style="font-family: "consolas";"><br /></span>
<span style="font-family: "consolas";"><b>Table:</b>pocVehicle</span><br />
<span style="font-family: "consolas"; line-height: 115%;"><strong>Class:</strong>POCVehicleMasterClass</span><br />
<span style="font-family: "consolas"; line-height: 115%;"><strong>ManuItem:</strong>POCVehicleMasterClass<o:p></o:p></span><br />
<span style="font-family: "consolas"; line-height: 115%;"><br /></span>
<span style="font-family: "consolas"; line-height: 115%;"><b style="font-family: "Times New Roman";"><span style="font-family: "consolas"; line-height: 11.5px;">Method on Form button click:</span></b></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: "consolas"; line-height: 115%;">void clicked()<br />
{<br />
<br />
MenuFunction mf;<br />
//POCVehicle pocVehicle;<br />
<br />
Args args=new Args();<br />
;<br />
args.record(pocVehicle);<br />mf= new MenuFunction(identifierStr(POCVehicleMasterClass),
MenuItemType::Action);<br />
mf.run(args);<br />
<br />
} <o:p></o:p></span></div>
<span style="font-family: "consolas"; line-height: 115%;"><br />
<strong>Main Methods on Class </strong><b>POCVehicleMasterClass :</b></span><br />
<span style="font-family: "consolas"; line-height: 115%;"><br />
Public static void main(Args _args)<br />
<br />
{<br />
POCVehicle pocVehicle;<br />
<br />
POCVehicleMasterClass myClass;<br />
<br />
FormDataSource formdatasource;<br />
<br />
Common common;<br />
;<br />
<br />
myClass= new POCVehicleMasterClass();<br />
<br />
if(_args.record().TableId==tableNum(POCVehicle))<br />
<br />
{<br />//Buffer selected records<br />
common=_args.record();<br />//formdatasource=_args.record().dataSource();<br />
//Records data source<br />
formdatasource=common.dataSource();<br />//Passing parameter to class updateRecord method<br />
myClass.UpdateRecord(formdatasource,_args);<br />
}<br />
<br />
}</span><br />
<span style="font-family: "consolas"; line-height: 115%;"><br /></span>
<span style="font-family: "consolas"; line-height: 115%;"><b>Second method on the class:</b><br />
<br />
Public void UpdateRecord(FormDataSource datasource, Args args)<br />
{<br />
<br />
POCVehicle pocvehicle;<br />
FormDataSource formDataSource;<br />
int recordCount, recorUpdated;<br />
;<br />
<br />
formDataSource= datasource;<br />//Count selected records<br />
RecordCount= formDataSource.recordsMarked().lastIndex();<br />
recorUpdated=0;<br />
<br />
//Update all selected records<br />
for(pocvehicle=formDataSource.getFirst(true)? formDataSource.getFirst(true):
formDataSource.cursor() ; pocvehicle ;pocvehicle=formDataSource.getNext())<br />
<br />
{<br />ttsBegin;<br />
pocvehicle.Insurence= NoYes::No;<br />
pocvehicle.update();<br />ttsCommit;<br />
recorUpdated++;<br />
<br />
}<br />//Refresh caller form datasource with same pointer<br />
<br />
formDataSource.research(true);<br />
<br />
info(strFmt('%1 records selected and %2 records updated ',
RecordCount,recorUpdated));<br />
<br />
}</span></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-18979477115736189282014-09-01T17:36:00.002+04:002014-09-04T13:50:15.299+04:00AX Interview Question<div dir="ltr" style="text-align: left;" trbidi="on">
Hi friends, Before to dive in actual post i would like to thank to all my friends for your love and appriciation.
I hope attached document will help to find out some good question and answer for interview.
<iframe height="550" src="https://docs.google.com/file/d/0B5yL_2oBAUUoQkpIbzNsRk5zTmM/preview" width="750"></iframe>
Happy DAXing!!!
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-76017182027547434892014-08-19T17:23:00.000+04:002014-09-01T16:36:16.868+04:00In-Place Data upgrade checklist issue in AX 2012 R3 and AX 2012 R2 upgrade<div dir="ltr" style="text-align: left;" trbidi="on">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><br />
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="371">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:8.0pt;
mso-para-margin-left:0in;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
</style>
<![endif]-->
<br />
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<div style="text-align: justify;">
<span style="color: white;"><b><span style="font-size: 11pt;">Issue:</span></b><span style="font-size: 11pt;"> </span></span></div>
<span style="color: white;">
</span><div style="text-align: justify;">
<span style="color: white;"><span style="font-size: 11pt;">We observed this during AX 2012 R2 and AX 2012 R3 data upgrade
other than the Launch Data Upgrade stage, a different stage Presynchronization
is blocked: instead of showing the ReleaseUpdateCockpit form but the
ReleaseUpdateScriptsHistory form pops up unexpectedly. </span></span></div>
<div style="text-align: justify;">
<br /></div>
<span style="color: white;">
</span><div style="text-align: justify;">
<span style="color: white;"><b><span style="font-size: 11pt;">Solution:</span></b><span style="font-size: 11pt;">This
turned out that back dated rows were recorded into the log table
ReleaseUpdateScriptsHistory (ScriptStage=16: Presynchronization; ScriptStage=17:
Launch Data Upgrade). We have dropped the relevant records from the
ReleaseUpdateScriptsHistory:</span></span></div>
<div style="text-align: justify;">
<br /></div>
<span style="color: white;">
</span><div style="text-align: justify;">
<span style="color: white;"><span style="font-size: 11pt;"> delete from ReleaseUpdateScriptsHistory where ScriptStage
in (16,17,18)</span></span></div>
<div style="text-align: justify;">
<br /></div>
<span style="color: white;">
</span><div style="text-align: justify;">
<span style="color: white;"><span style="font-size: 11pt;">After dropping data Presynchronization and launch data upgrade
worked properly.</span></span></div>
<span style="color: white;">
</span><div style="text-align: justify;">
<br /></div>
<span style="color: white;">
</span><div style="text-align: justify;">
<span style="color: white;"><span style="font-size: 11pt;">Happy DAXing!!! </span></span></div>
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="371">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:8.0pt;
mso-para-margin-left:0in;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
</style>
<![endif]-->
<span style="color: #212121; font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";"><br /></span><br />
<br /></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com1tag:blogger.com,1999:blog-2294140644144352210.post-68937534575488996172013-10-09T15:40:00.004+04:002013-10-09T15:40:58.023+04:00EP in AX 2012 R2 <div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
EP Home Page in AX 2012 R2</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-OYLpJTwKufM/UlVAIjpAg4I/AAAAAAAAAN0/eE1bynBgM9U/s1600/EP.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="312" src="http://2.bp.blogspot.com/-OYLpJTwKufM/UlVAIjpAg4I/AAAAAAAAAN0/eE1bynBgM9U/s640/EP.png" width="640" /></a></div>
<br /></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com1tag:blogger.com,1999:blog-2294140644144352210.post-58824586782480640482013-10-06T01:03:00.001+04:002013-10-06T02:16:50.672+04:00Create SO through AIF<div dir="ltr" style="text-align: left;" trbidi="on">
Hi friends File System adapter play vital role while we integrate AX with any other application. So here a process to create SO and return his Sales id through the AIF.
<iframe src="https://docs.google.com/file/d/0B5yL_2oBAUUodWRTSEFvZm1EOGs/preview" width="750" height="550"></iframe>
Happy DAXing!!!
<br /></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-38025653859893174032013-10-06T00:01:00.003+04:002013-10-09T11:40:05.534+04:00AX 2012 R2 CU1 Upgrade<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Hi Friends again I am here with a mesmerizing post "AX 2012 R2 CU1 upgrade" which is a complete and meticulous document for in-place
upgrade along with the retail and many ISV's. I hope it will help you to conquer the Upgrade.....Happy DAXing!!!!!
<iframe src="https://docs.google.com/file/d/0B5yL_2oBAUUodkllRUFGZDNYdXM/preview" width="750" height="550"></iframe>
</div>Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-81558753894622302762013-05-30T11:22:00.002+04:002013-10-06T02:22:50.468+04:00AX 2012 CU4 Upgrade<div dir="ltr" style="text-align: left;" trbidi="on">
AX 2012 Process flow: Hi all now we jump in new concept that is CU4. for AX 2012 R2 upgrade CU4 will come in picture which is mandetory for the AX 2012 r2.<br />
<br />
<br />
Step 1. Install all components Except DB<br />
<div style="border: currentColor;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="border: currentColor;">
<div class="separator" style="clear: both; text-align: left;">
<a href="http://4.bp.blogspot.com/-J5FJnMmZJBQ/UlBhQsBqoYI/AAAAAAAAANI/seJqHLMRNAg/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="451" src="http://4.bp.blogspot.com/-J5FJnMmZJBQ/UlBhQsBqoYI/AAAAAAAAANI/seJqHLMRNAg/s640/11.png" width="640" /></a></div>
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-71_orFqo1Ig/UlBhcxfQIaI/AAAAAAAAANQ/3T11tf-4ekY/s1600/22.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="528" src="http://4.bp.blogspot.com/-71_orFqo1Ig/UlBhcxfQIaI/AAAAAAAAANQ/3T11tf-4ekY/s640/22.png" width="640" /></a></div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
</div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
</div>
<div align="left" class="separator" style="border: currentColor; clear: both; text-align: center;">
</div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div style="border: currentColor;">
Step 2. run schema command on the DB</div>
<div style="border: currentColor;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-NNlwqHGkfNw/UlBhsrgAu8I/AAAAAAAAANY/iz1iw0iAUak/s1600/33.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="242" src="http://1.bp.blogspot.com/-NNlwqHGkfNw/UlBhsrgAu8I/AAAAAAAAANY/iz1iw0iAUak/s320/33.png" width="320" /></a></div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
<a href="http://3.bp.blogspot.com/-IwLJX0eVrqs/Uab7v4QcdSI/AAAAAAAAAME/z4RftIc9eEY/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a> </div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
Step 3. run CU4 installable and check DB only </div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="http://3.bp.blogspot.com/-hYazpXXIKaU/UlBiuqf5tCI/AAAAAAAAANk/Yk5iq_eYzcA/s1600/444.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="265" src="http://3.bp.blogspot.com/-hYazpXXIKaU/UlBiuqf5tCI/AAAAAAAAANk/Yk5iq_eYzcA/s320/444.png" width="320" /></a></div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
<a href="http://2.bp.blogspot.com/-OxOXR3VD_0Y/Uab74MyPK6I/AAAAAAAAAMM/ruTqs9Z3x8A/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a> </div>
<div style="border: currentColor;">
<br /></div>
<div style="border: currentColor;">
Step4. Select start the S/W update check list and complete it</div>
<div style="border: currentColor;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
<a href="http://1.bp.blogspot.com/-LTvahuI4Vm8/Uab78RwCeZI/AAAAAAAAAMU/9tR7bHpyoHA/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="http://1.bp.blogspot.com/-LTvahuI4Vm8/Uab78RwCeZI/AAAAAAAAAMU/9tR7bHpyoHA/s400/6.png" width="363" yya="true" /></a></div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
Step 5. below is the check list which should complete successfully</div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
<a href="http://1.bp.blogspot.com/-V2-KaF5uVDk/Uab8BZlQllI/AAAAAAAAAMc/ouShe6ax_bU/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="http://1.bp.blogspot.com/-V2-KaF5uVDk/Uab8BZlQllI/AAAAAAAAAMc/ouShe6ax_bU/s400/7.png" width="325" yya="true" /></a></div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="border: currentColor; clear: both; text-align: left;">
Step 6. At last check the version and installed model it should match to the CU4 one.</div>
<div class="separator" style="border: currentColor; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-44gBKpYhlIA/Uab7ftnJTyI/AAAAAAAAALs/gr9UYv-kopE/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="576" src="http://3.bp.blogspot.com/-44gBKpYhlIA/Uab7ftnJTyI/AAAAAAAAALs/gr9UYv-kopE/s640/1.png" width="640" yya="true" /></a></div>
<div style="border: currentColor;">
<br /></div>
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-56393218671745040262013-05-22T16:31:00.003+04:002013-10-06T02:24:17.675+04:00How to install and configure AX 2012 dynamics connector<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">How to install and configure AX 2012 dynamics connector <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" 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-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Install Business connector XPO <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" 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-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Merge the code if any error occurred<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" 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;">3.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Run the class dynamics connector<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" 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;">4.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Check the dynamics connector default service in the inbound port it should activate<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" 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;">5.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Open connector<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" 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;">6.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Adapter setting<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" 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;">7.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Click on refresh services button<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" 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;">8.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Check all services along with connector services<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 10pt 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;">9.</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Click on configure button</span><br />
<br /></div>
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-21278690534804375422013-05-22T16:27:00.005+04:002013-10-06T02:25:24.446+04:00Dynamics CRM Connector error<div dir="ltr" style="text-align: left;" trbidi="on">
<strong>Error:</strong> value cann't be null. Parameter name:type<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-efYwE3oh_Tc/UZy5Tpf9ttI/AAAAAAAAALU/Q4arKVy_VM8/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="130" src="http://1.bp.blogspot.com/-efYwE3oh_Tc/UZy5Tpf9ttI/AAAAAAAAALU/Q4arKVy_VM8/s400/2.png" width="400" ya="true" /></a></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;"><b style="mso-bidi-font-weight: normal;">Occurrence:</b> This error occurred while we try to configure services through connector.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;"><b style="mso-bidi-font-weight: normal;">Reason:</b> This error occurred if we have checked customized document check box but not select any data policy in the inbound port.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;"><b style="mso-bidi-font-weight: normal;">Solution:</b> cleared check box as shown in the screen shot. <o:p></o:p></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-aH-r2Sjr_6c/UZy5Xz0J1TI/AAAAAAAAALc/_Vh2h0vsK8A/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="416" src="http://4.bp.blogspot.com/-aH-r2Sjr_6c/UZy5Xz0J1TI/AAAAAAAAALc/_Vh2h0vsK8A/s640/3.png" width="640" ya="true" /></a></div>
<br /></div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0tag:blogger.com,1999:blog-2294140644144352210.post-16645070730370426872013-05-22T16:24:00.004+04:002013-10-06T02:26:13.625+04:00Dynamics Connector error in AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<strong>Error:</strong> An Exception of type MataDataException has occured while performing the operation<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-uwd_VfsNwEo/UZy4kNcqIII/AAAAAAAAALI/ecViW0cu9DE/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="430" src="http://3.bp.blogspot.com/-uwd_VfsNwEo/UZy4kNcqIII/AAAAAAAAALI/ecViW0cu9DE/s640/1.png" width="640" ya="true" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;"><b style="mso-bidi-font-weight: normal;">Occurrence:</b> This error occurred and we try to refresh services in dynamics connector adapter.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;"><b style="mso-bidi-font-weight: normal;">Reason:</b> This error occurred while any objects not have reference. In our case we have uninstalled RF Smart. But some objects have left to delete. And they have no reference.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;"><b style="mso-bidi-font-weight: normal;">Solution:</b> Delete unreferenced objects( for track that object browse file in C:\ProgramData\Microsoft Dynamics\Connector for Microsoft Dynamics\Logs). <o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
</div>
Jitendra Kumar Singh, PMPhttp://www.blogger.com/profile/06499054502421174311noreply@blogger.com0