tag:blogger.com,1999:blog-32277224885799648772024-02-19T09:47:17.831+03:00Hasan's Dynamics 365 Finance and Supply Chain, Ax 2012 WorldEverything about D365 FO, Ax 2009, Ax 2012, Ax 4.0, Ax 3.0.
(As information is shared, it is valued, evaluated and multiplied)Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.comBlogger62125tag:blogger.com,1999:blog-3227722488579964877.post-56575610697526024662022-11-26T14:17:00.003+03:002022-11-26T14:17:35.049+03:00D365 FO error: Unable to install this application because an application with the same identity is already installed<p><span style="background-color: white; color: #2b2b2b; font-family: "Segoe UI", SegoeUI, "Segoe UI Web Regular", "Segoe UI Symbol", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 15px;">I was trying to open workflow configuration form in D365 Finance and getting below error.</span></p><p style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", SegoeUI, "Segoe UI Web Regular", "Segoe UI Symbol", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 15px; font-stretch: normal; line-height: 1.33; margin: 0px 0px 30px; text-rendering: optimizelegibility;"><strong style="box-sizing: border-box;">Unable to install this application because an application with the same identity is already installed. To install this application, either modify the manifest version for this application or uninstall the preexisting application</strong>.</p><h2 id="cause" style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", SegoeUI, "Segoe WP", Tahoma, Arial, sans-serif; font-size: 30px; font-weight: 300; line-height: 40px; margin: 0px; overflow-wrap: break-word; padding: 0px; text-rendering: optimizelegibility;">Cause</h2><p style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", SegoeUI, "Segoe UI Web Regular", "Segoe UI Symbol", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 15px; font-stretch: normal; line-height: 1.33; margin: 0px 0px 30px; text-rendering: optimizelegibility;">This issue occurs if the application was cached in the ClickOnce application cache. The application must be removed from the cache before you can successfully run it.</p><h2 id="solution" style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", SegoeUI, "Segoe WP", Tahoma, Arial, sans-serif; font-size: 30px; font-weight: 300; line-height: 40px; margin: 0px; overflow-wrap: break-word; padding: 0px; text-rendering: optimizelegibility;">Solution</h2><p style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", SegoeUI, "Segoe UI Web Regular", "Segoe UI Symbol", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 15px; font-stretch: normal; line-height: 1.33; margin: 0px; text-rendering: optimizelegibility;">To clear the ClickOnce application cache, follow these steps:</p><ol style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", SegoeUI, "Segoe UI Web Regular", "Segoe UI Symbol", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 1.5em; list-style-image: initial; list-style-position: initial; margin: 1em 0px; padding: 0px 0px 0px 40px;"><li style="box-sizing: border-box;">Click <strong style="box-sizing: border-box;">Start</strong>, click <strong style="box-sizing: border-box;">Run</strong>, type cmd, and then click <strong style="box-sizing: border-box;">OK</strong>.</li><li style="box-sizing: border-box;">Type the following command, and then press Enter: <strong style="box-sizing: border-box;">rundll32 dfshim CleanOnlineAppCache</strong></li></ol>Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-90523026089251231552021-10-25T22:20:00.007+03:002021-10-25T22:20:35.536+03:00D365 FO Task recorder screenshots<p> https://syedrafayali.wordpress.com/2019/02/14/dynamics-365-task-recorder-screenshots-extensions/</p>Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-86242005865093396692020-10-28T15:28:00.002+03:002020-10-28T15:29:56.134+03:00Setting up PowerBI embedded and Analytical workspaces in Dynamics 365 for Finance and Operations in a OneBox Environment<p><br /></p><p><a href="https://docs.microsoft.com/en-us/archive/blogs/dynamicsaxbi/accessing-analytical-workspaces-on-1box-environment">https://docs.microsoft.com/en-us/archive/blogs/dynamicsaxbi/accessing-analytical-workspaces-on-1box-environment</a></p><p> </p><p><br /></p><p><a href="http://www.everythingdynamicsaxbi.com/2019/02/03/how-to-configure-power-bi-embedded-for-dynamics-365-for-finance-and-operations-one-box-environment/">http://www.everythingdynamicsaxbi.com/2019/02/03/how-to-configure-power-bi-embedded-for-dynamics-365-for-finance-and-operations-one-box-environment/</a></p><p><br /></p>Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-26079085074611878432019-12-28T15:04:00.001+03:002019-12-28T15:04:14.625+03:00Attaching a selected document to Dynamics 365 for Finance and Operations<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">PurchTable</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> purchaseTable;</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> System.Net.</span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">WebClient</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> webClient;</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> System.IO.</span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">MemoryStream</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> stream;</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in; text-indent: 0.5in;">
<br /></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in; text-indent: 0.5in;">
<span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">FileUploadTemporaryStorageResult</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> fileUploadResult = </span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">File</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">::GetFileFromUser (</span><span style="color: blue; font-family: consolas; font-size: 9.5pt;">classstr</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">(</span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">ImageFileUploadTemporaryStorageStrategy</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">));</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: blue; font-family: consolas; font-size: 9.5pt;">if</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> (fileUploadResult && fileUploadResult.getUploadStatus())</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> {</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: dodgerblue; font-family: consolas; font-size: 9.5pt;">str</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> imageFilePathName = fileUploadResult.getDownloadUrl();</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">InteropPermission</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> perm = </span><span style="color: blue; font-family: consolas; font-size: 9.5pt;">new</span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">InteropPermission</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">(</span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">InteropKind</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">::ClrInterop);</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> perm.assert();</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><i><span style="color: green; font-family: consolas; font-size: 9.5pt;">// BP Deviation Documented</span></i><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> webClient = </span><span style="color: blue; font-family: consolas; font-size: 9.5pt;">new</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> System.Net.</span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">WebClient</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">();</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><i><span style="color: green; font-family: consolas; font-size: 9.5pt;">// BP Deviation Documented</span></i><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> stream = </span><span style="color: blue; font-family: consolas; font-size: 9.5pt;">new</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">System.IO.</span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">MemoryStream</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">(webClient.DownloadData(imageFilePathName));</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in; text-indent: 0.5in;">
<span style="color: blue; font-family: consolas; font-size: 9.5pt;">select</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> purchaseTable </span><span style="color: blue; font-family: consolas; font-size: 9.5pt;">where</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> purchaseTable.PurchId == </span><span style="color: darkred; font-family: consolas; font-size: 9.5pt;">"PO-0002"</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">; </span><i><span style="color: green; font-family: consolas; font-size: 9.5pt;">// any record for tables</span></i></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in; text-indent: 0.5in;">
<i><span style="color: green; font-family: consolas; font-size: 9.5pt;"><br /></span></i></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in; text-indent: 0.5in;">
<span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">DocuRef</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> docuref =</span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">DocumentManagement</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">::attachFile(purchaseTable.TableId,purchaseTable.RecId, purchaseTable.DataAreaId,</span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">DocuType</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">::typeFile(),stream,fileUploadResult.getFileName(), fileUploadResult.getFileContentType(),fileUploadResult.getFileName());</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><i><span style="color: green; font-family: consolas; font-size: 9.5pt;">// download/view the attachment</span></i><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: dodgerblue; font-family: consolas; font-size: 9.5pt;">str</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> displayUrl = DocumentManagement::getAttachmentPublicUrl(docuref);</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">Browser</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> br = </span><span style="color: blue; font-family: consolas; font-size: 9.5pt;">new</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">Browser</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">();</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> br.navigate(displayUrl);</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> </span><span style="color: darkcyan; font-family: consolas; font-size: 9.5pt;">CodeAccessPermission</span><span style="color: #333333; font-family: consolas; font-size: 9.5pt;">::revertAssert();</span><span style="color: #333333; font-family: arial, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"> }</span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;"><br /></span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<span style="color: #333333; font-family: consolas; font-size: 9.5pt;">thanks for great help...</span></div>
<div class="MsoNormal" style="background: white; color: #606060; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 14.49px; line-height: normal; margin-bottom: 0in;">
<a href="http://prdpmv.blogspot.com/2017/08/attaching-user-selected-document-to.html">http://prdpmv.blogspot.com/2017/08/attaching-user-selected-document-to.html</a></div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-16784104820731170942019-11-13T14:50:00.001+03:002019-11-13T14:50:31.801+03:00run report not in d365 fo menu<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://rapiduat1.sandbox.operations.dynamics.com/?cmp=1061&mi=Output%3ASysCompanySize">https://xxxxxx.sandbox.operations.dynamics.com/?cmp=xxxx&mi=Output%3ASysCompanySize</a></div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-62744567022547872272019-11-06T17:34:00.005+03:002019-11-06T17:34:52.928+03:00default dimension ve ledger dimension relationship<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
thank you for blog <a class="url fn n profile-usercard-hover" data-profile-rendered="true" data-profile-userid="eda914cf2f164f6fb160f49a14d3fe1b" href="https://social.msdn.microsoft.com/profile/Bill+Frandsen" style="background-color: white; box-sizing: border-box; color: #337ab7; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 13px; text-decoration-line: none;">Bill Frandsen</a>..<br />
<br />
<a href="https://blogs.msdn.microsoft.com/ax_gfm_framework_team_blog/2013/02/15/ledger-account-combinations-part-1-dimensions/">https://blogs.msdn.microsoft.com/ax_gfm_framework_team_blog/2013/02/15/ledger-account-combinations-part-1-dimensions/</a><br />
<br />
<h4 style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px; font-weight: normal; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
Introduction</h4>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">In Dynamics AX 2009, dimensions were limited to a minimum of three and a maximum of ten, and entered in a set order that required code customizations and database synchronization for each dimension added. In Dynamics AX 2012, the dimension framework was expanded to allow unlimited dimensions which can be dynamically created by the user, and entered in any order. The unlimited nature of the new model, coupled with taking advantage of relational database design as well as optimizing for performance requirements has led to a more complex data model than existed in the past. In this series of blog posts, we will discuss the various areas of the dimension framework, and how they work together to give a better understanding of “What happens when I create a ledger account combination?”</span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">The model below in figure 1 shows the various areas within the dimension framework.</span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px; text-align: center;">
<a href="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/5008.P1_IMG1.png" original-url="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/5008.P1_5F00_IMG1.png" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;"><img alt="" border="0" original-url="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/5008.P1_5F00_IMG1.png" src="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/5008.P1_IMG1.png" style="border: 0px; box-sizing: border-box; height: auto; max-width: 100%; vertical-align: middle;" /></a></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-weight: 700;"><span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Figure 1: Dimensions in framework</span></span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">This initial blog post covers the Dimensions, Dimension Values, Categorizations and Backing Entities regions highlighted in figure 1 above in pale yellow.</span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Subsequent blog posts will cover:</span></span></div>
<ul style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px; margin-top: 0px;">
<li style="box-sizing: border-box;"><span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;"><a href="http://blogs.msdn.com/b/ax_gfm_framework_team_blog/archive/2013/02/15/ledger-account-combinations-part-2-_2800_dimension-enumerations-default-dimensions_2900_-.aspx" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;" title="Dimension Enumerations and Default Dimensions">Dimension Enumerations and Default Dimensions</a></span></span></li>
<li style="box-sizing: border-box;"><span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;"><a href="http://blogs.msdn.com/b/ax_gfm_framework_team_blog/archive/2013/02/15/ledger-account-combinations-part-3-_2800_structures-constraints_2900_-.aspx" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;" title="Structures and Constraints">Structures and Constraints</a></span></span></li>
<li style="box-sizing: border-box;"><span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;"><a href="http://blogs.msdn.com/b/ax_gfm_framework_team_blog/archive/2013/02/15/ledger-account-combinations-part-4-_2800_advanced-rules_2900_-.aspx" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;" title="Advanced Rules">Advanced Rules</a></span></span></li>
<li style="box-sizing: border-box;"><span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;"><a href="http://blogs.msdn.com/b/ax_gfm_framework_team_blog/archive/2013/02/15/ledger-account-combinations-part-5-_2800_ledger-dimensions_2900_-.aspx" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;" title="LedgerDimensions">LedgerDimensions</a></span></span></li>
<li style="box-sizing: border-box;"><span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;"><a href="http://blogs.msdn.com/b/ax_gfm_framework_team_blog/archive/2013/02/15/ledger-account-combinations-part-7-_2800_advanced-topics_2900_-.aspx" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;" title="Advanced topics ">Advanced topics</a> including hash keys, hashes and other key data model elements</span></span></li>
</ul>
<h4 style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px; font-weight: normal; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Dimension Attributes</span></span></h4>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">A dimension attribute, which will be referred to as a dimension, simply represents an additional piece of classifying information that a user would like to associate with a ledger account combination. It represents classes of things, not specific instances. Examples of things that can be used to create a dimension are Department, Cost Center, Expense Purpose, Customer, Vendor, Item – which are all classes of entities that already exist in the system; or custom entities that are specific to a particular installation such as license plate number or event name or ticket number.</span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">When a dimension is created, the user chooses to use values for it from either an existing entity in the system such as Customers or Departments, or to create a custom list. The dimension framework keeps track of a reference for this dimension to a table in the system. For existing entities such as Customers, a reference to the CustTable table is used. For custom entities that are defined by the user, a reference to the DimensionFinancialTag table is used. This metadata about what a dimension represents is stored in the DimensionAttribute table for each dimension defined.</span></span> </div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">The following form shows an example of two dimensions, one to represent customers that already exist in the application, and another that represents a new custom list.</span></span></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<a href="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/4174.P1_IMG2.png" original-url="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/4174.P1_5F00_IMG2.png" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;"><img alt="" border="0" original-url="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/4174.P1_5F00_IMG2.png" src="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/4174.P1_IMG2.png" style="border: 0px; box-sizing: border-box; height: auto; max-width: 100%; vertical-align: middle;" /></a></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-weight: 700;"><span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Figure 2: Financial dimensions form</span></span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">The data is stored in the DimensionAttribute table. The SQL query below in figure 3 shows some of the basic information associated with each dimension.</span></span></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<a href="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/0334.P1_IMG3.png" original-url="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/0334.P1_5F00_IMG3.png" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;"><img alt="" border="0" original-url="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/0334.P1_5F00_IMG3.png" src="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/0334.P1_IMG3.png" style="border: 0px; box-sizing: border-box; height: auto; max-width: 100%; vertical-align: middle;" /></a></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-weight: 700;"><span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Figure 3: DimensionAttribute storage query results</span></span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">The Type determines whether the dimension is backed by an existing entity in the system or a custom list. It is also important to note that the dimension framework does not directly reference the existing entity backing table such as CustTable. Instead, a custom view is created to make an entity available in the system for use in the dimension framework. As of Dynamics AX 2012 R2, 36 existing entities have been enabled to be used as dimensions in the system. </span></span> </div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">It is possible for a user to create more than one dimension based on the same entity. There may be instances where an entity in the system is used for multiple different purposes when classifying transaction activity in the system. In this case, multiple dimensions can be defined for it, one for each of its purposes. A common example would be a cost center backing entity used to represent the primary cost center (e.g. selling) and the cost center the transaction is being traded against (e.g. purchasing).</span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Internally, special dimensions exist that are automatically created to support key functionality of the dimension framework. A primary example is the Main Account dimension. This allows a main account to be treated as a dimension by the dimension framework, but also prevents it from being used by a user to create a dimension. The other types of special dimensions are system generated ones that are used by the dimension framework for internal purposes.</span></span></div>
<h4 style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px; font-weight: normal; line-height: 1.1; margin-bottom: 10px; margin-top: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Dimension Attribute Values</span></span></h4>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">A dimension attribute value is a specific instance of a dimension used within the dimension framework. The values for a dimension are determined by the ViewName specified on the DimensionAttribute record. In the case of an existing entity, such as CustTable, values consist of the records in that table. In the case of a custom list, it is a specific set of records within the DimensionFinancialTag table. Values that are available for a particular dimension are viewable by clicking the “Financial dimension values” button on the Dimension details form as shown in figure 2 above. When the list is provided by an existing entity, such as CustTable, it is not editable from this form. To create a new dimension value for Customer, the user would go directly to the Customer form and create a new customer. Once created, the new customer will become available for use in the dimension framework. When the list is provided by the user as a custom list, the user will be able to modify the list directly on this form.</span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Example of a list of values provided by CustTable (with no values stored in the dimension framework):</span></span></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<a href="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/8461.P1_IMG4.jpg" original-url="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/8461.P1_5F00_IMG4.jpg" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;"><img alt="" border="0" original-url="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/8461.P1_5F00_IMG4.jpg" src="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/8461.P1_IMG4.jpg" style="border: 0px; box-sizing: border-box; height: auto; max-width: 100%; vertical-align: middle;" /></a></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;"><span style="box-sizing: border-box; font-weight: 700;">Figure 4: Financial dimensions values form (existing list)</span></span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Example when provided by a custom list (with values stored in the dimension framework):</span></span></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<a href="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/3716.P1_IMG5.jpg" original-url="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/3716.P1_5F00_IMG5.jpg" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;"><img alt="" border="0" original-url="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/3716.P1_5F00_IMG5.jpg" src="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/3716.P1_IMG5.jpg" style="border: 0px; box-sizing: border-box; height: auto; max-width: 100%; vertical-align: middle;" /></a></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;"> <span style="box-sizing: border-box; font-weight: 700;">Figure 5: Financial dimensions form (custom list)</span></span></span><span style="box-sizing: border-box; font-weight: 700;"></span></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<a href="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/8637.Fix1_6.png" original-url="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/8637.Fix1_5F00_6.png" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;"><img alt="" border="0" original-url="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-50-86/8637.Fix1_5F00_6.png" src="https://msdnshared.blob.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/50/86/8637.Fix1_6.png" style="border: 0px; box-sizing: border-box; height: auto; max-width: 100%; vertical-align: middle;" /></a></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-weight: 700;"><span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Figure 6: Dimension setup tables query results</span></span></span></div>
<div align="center" style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">In both of these cases, the Financial dimension values form is displaying what values exist for the entity, not what values have actually been used within the dimension framework. The dimension framework representation of these values is not created until it is used within the framework requiring it to hold a reference to it. This allows for the ability for values to be deleted that have not yet been used, and for storage size and performance optimization.</span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">Once a dimension value is referenced requiring it to be saved by the dimension framework, it is stored in the DimensionAttributeValue table. This table is the link between the DimensionAttribute and the specific RecId of the record in the ViewName view or table referenced on the DimensionAttribute. Both the DimensionAttribute and DimensionAttributeValue records are needed to navigate back to the originating value that the user has entered.</span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">In a system where nothing has been referenced by the dimension framework, there will be no records in the DimensionAttributeValue table.</span></span></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Segoe UI", Tahoma, Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 14px;">
<div style="box-sizing: border-box; margin-bottom: 10px;">
<span style="box-sizing: border-box; font-size: x-small;"><span style="box-sizing: border-box; font-family: Calibri;">In the <a href="http://blogs.msdn.com/b/ax_gfm_framework_team_blog/archive/2013/02/15/ledger-account-combinations-part-2-_2800_dimension-enumerations-default-dimensions_2900_-.aspx" style="background-color: transparent; box-sizing: border-box; color: #337ab7; text-decoration-line: none;" title="next blog post">next blog post</a>, the storage of dimensions as dimension enumerations and of dimension values as default dimensions will be explained.</span></span></div>
</div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-87324342670636943422019-07-29T17:10:00.004+03:002019-07-29T17:10:19.443+03:00Create warehouse addresses through code<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
<span style="font-family: inherit; font-size: 9.75pt;"> </span></div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
<br /></div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
InventLocation
warehouse;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
LogisticsPostalAddressView postalAddressView;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
LogisticsPostalAddress
postalAddress;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
LogisticsEntityLocationMap locationMap;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
container
role, roleMap;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
Map
LocationRoleMap;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
LogisticsPostalAddressEntity postalAddressEntity =
new LogisticsPostalAddressEntity();</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
warehouse
= InventLocation::find('CR004');</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
postalAddressView.Street
= 'Test street222';</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
postalAddressView.City
= 'Tcity';</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
postalAddressView.State
= '';</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
postalAddressView.ZipCode
= '622001';</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
postalAddressView.CountryRegionId = 'SASCO';</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
postalAddressView.LocationName = 'TDlvAddr';</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
postalAddress =
postalAddressEntity.createPostalAddress(postalAddressView);</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
locationMap =
LogisticsEntityLocationMap::find(tableNum(InventLocationLogisticsLocation),
warehouse.RecId, postalAddress.Location);</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
locationMap.Entity
= warehouse.RecId;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
locationMap.Location
= postalAddress.Location;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
locationMap.IsPostalAddress = NoYes::Yes;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
locationMap.IsPrimary =
NoYes::Yes;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
locationMap.IsPrivate
= NoYes::No;</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
LocationRoleMap =
LogisticsLocationEntity::getDefaultLocationRoleFromEntity(tableName2id("InventLocation"));</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
roleMap
= map2Con(LocationRoleMap);</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
role
= conpeek(roleMap, 1);</div>
<div style="font-family: inherit; font-size: 9.75pt; margin: 0in;">
locationMap.addEntityLocation(role ,true);</div>
<br /><br />
<br />
<span style="color: #979797; font-size: 13px;">thanks. </span><a href="http://axcorner.blogspot.com/2014/01/create-warehouse-addresses-through-code.html" style="font-size: 13px;">http://axcorner.blogspot.com/2014/01/create-warehouse-addresses-through-code.html</a></div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-51790823017008148372017-12-12T22:06:00.003+03:002017-12-12T22:06:11.241+03:00Lookup not works in Enterprise portal<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
If user clicks on lookups then lookup form will display but the selected value will not reflect in to the text box.</div>
<div class="" style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
Solution: Disable IE ESC for the users<br style="box-sizing: border-box;" />1. Open the Server Manager Tool. Configure IE ESC is located on the right hand side of the interface in the section heading Security Information.<br style="box-sizing: border-box;" />2. Select the link Configure IE Esc and the configuration window will open. At this point you can choose whether to turn off IE ESC for Administrators or for Users or for both.</div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-7537956912540921022017-11-01T13:15:00.001+03:002017-11-01T13:15:37.201+03:00hata: excel aktarım: The number of arguments provided is different from the number of arguments accepted by the method.<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 16px;">
<pre class="prettyprint linenums x-hidden-focus" style="background: rgb(238, 238, 238) !important; border: none !important; box-sizing: border-box; font-family: monospace, serif; font-size: 12px; padding: 10px !important; white-space: pre-wrap;">The number of arguments provided is different from the number of arguments accepted by the method.
</pre>
</div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
Update post : </div>
<div class="x-hidden-focus" style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
The solution is :</div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 16px;">
<pre class="prettyprint linenums" style="background: rgb(238, 238, 238) !important; border: none !important; box-sizing: border-box; font-family: monospace, serif; font-size: 12px; margin-left: 30px; padding: 10px !important; white-space: pre-wrap;">boolean importLines()
{
SysExcelApplication application = SysExcelApplication::construct();
SysExcelWorkBooks workBooks = application.workbooks();
SysExcelWorkSheets workSheets;
SysExcelWorkSheet workSheet;
SysExcelCells cells;
</pre>
<pre class="prettyprint linenums" style="background: rgb(238, 238, 238) !important; border: none !important; box-sizing: border-box; font-family: monospace, serif; font-size: 12px; padding: 10px !important; white-space: pre-wrap;">// the solution is puting the bellow line code after initializing SysExcelApplication</pre>
<pre class="prettyprint linenums" style="background: rgb(238, 238, 238) !important; border: none !important; box-sizing: border-box; font-family: monospace, serif; font-size: 12px; padding: 10px !important; white-space: pre-wrap;">application.displayAlerts(false);</pre>
<pre class="prettyprint linenums x-hidden-focus" style="background: rgb(238, 238, 238) !important; border: none !important; box-sizing: border-box; font-family: monospace, serif; font-size: 12px; padding: 10px !important; white-space: pre-wrap;">//.... code
//and In the end
application.workbooks().close();
application.quit();
application.finalize();
application = null;
}</pre>
</div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-23343828990311728322017-02-12T15:10:00.002+03:002017-02-12T15:10:49.597+03:00Approve Workflow by Code x++<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
WorkflowWorkItemTable WorkflowWorkItemTable;<br />
<br />
while select WorkflowWorkItemTable<br />
where<br />
WorkflowWorkItemTable.UserId == 'hasan.bi'<br />
&& workflowWorkItemTable.Type == WorkflowWorkItemType::WorkItem<br />
&& workflowWorkItemTable.Status == WorkflowWorkItemStatus::Pending<br />
&& WorkflowWorkItemTable.RefTableId == tableNum(CPMContractAdvanceRequest)<br />
{<br />
WorkflowWorkItemActionManager::dispatchWorkItemAction(<br />
WorkflowWorkItemTable,<br />
"Auto Approve by ADMIN", // comment<br />
'hasan.bi', // << user ID<br />
WorkflowWorkItemActionType::Complete,<br />
"CPMContractAdvanceRequestAppApprove", // << menu item action approval workflow<br />
false); //is not web Menu Item<br />
}</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-60567718202091980552017-02-05T15:21:00.004+03:002017-02-05T15:21:29.234+03:00CIL generation errors and solutions<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 class="post-title entry-title" itemprop="name" style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 22px; font-stretch: normal; font-weight: normal; line-height: normal; margin: 0.75em 0px 0px; position: relative;">
thansks blog..</h3>
<h3 class="post-title entry-title" itemprop="name" style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-stretch: normal; font-weight: normal; line-height: normal; margin: 0.75em 0px 0px; position: relative;">
<a href="http://axvuongbao.blogspot.com.tr/2013/12/fix-parameter-could-not-be-serialized.html"><span style="font-size: x-small;">http://axvuongbao.blogspot.com.tr/2013/12/fix-parameter-could-not-be-serialized.html</span></a></h3>
<div>
<br /></div>
<h3 class="post-title entry-title" itemprop="name" style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 22px; font-stretch: normal; font-weight: normal; line-height: normal; margin: 0.75em 0px 0px; position: relative;">
Fix some errors from: CIL generation, Database Synchronize in AX 2012</h3>
<div class="post-header" style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 10.8px; line-height: 1.6; margin: 0px 0px 1.5em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-6044139224724215561" itemprop="description articleBody" style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px; line-height: 1.4; position: relative; width: 570px;">
<span style="color: blue;"><b>1.) "A parameter could not be serialized":</b></span><br />For a quick resolve: uncheck option "Excute business operations in CIL" under Tools-> Options -> Development tab.<br /><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx8jioVt1YnBcMiAUXEOmVnWb5I5BWVCDAwPk7WJeyEuNpUbuXIjcbqhdKqGkYA9fvMvUkOdkt0jpBpakiRm5tNJlYFkCqTLD6X7y9YMFeiITy1R4wxfuK7xLxnRnSymXMlcZg9_3OMyA/s1600/error.jpg" imageanchor="1" style="clear: left; color: #888888; float: left; margin-bottom: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx8jioVt1YnBcMiAUXEOmVnWb5I5BWVCDAwPk7WJeyEuNpUbuXIjcbqhdKqGkYA9fvMvUkOdkt0jpBpakiRm5tNJlYFkCqTLD6X7y9YMFeiITy1R4wxfuK7xLxnRnSymXMlcZg9_3OMyA/s400/error.jpg" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" width="400" /></a></div>
<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />The reason is that you haven't been able to do a successful FULL CIL compile.<br />Run again and try to fix the error in CIL.<br /><br /><span style="color: blue;"><b>2.)"CIL generation: source array was not long enough...":</b></span><br /><br />1. Stop the AOS.<br />2. Delete all of the source in the C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL directory.<br />3. Start the AOS.<br />4. Perform a full CIL generation.<br />5.(Only do if errors are still there and you have no error when compile X++, just comment the code notice in Compiler output with /*..*/, recompile CIL and delete comment tag)<br /><br /><span style="color: blue;"><b>3.) "CIL generation error : The given key was not present in the dictionary":</b></span><br /><span style="color: blue;"><b><br /></b></span>1. Check the CIL log file, generally located at "C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL\Dynamics.Ax.Application.dll.log"<br />2. You will find the AOT object for which the CIL generator found the error.<br />3. Compile that object, fix the error, or delete (if needed) and then regenerate the IL.<br />4. (Only do if errors are still there : Stop AOS > Delete the .auc file from users\\Appdata folder > Restart AOS)<br /><br /><span style="color: blue;"><b>4.) DB synchronize error: "Field mismatch in union query. Field ... is not compatible with field ..."</b></span><br /><br />Check your EDT concern to that field ( in query, table, view). They have different size.<br />So you just change the size to be the same.<br />Or check someone changed size of standard EDT. It's the reason cause this error<br /><br /><div class="MsoNormal">
<b><span style="color: blue;">5.) "Duplicate type with name 'Dynamics.Ax.application.' in assembly 'Dynamics.Ax.application "</span></b><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
1. Stop the ax service.<o:p></o:p></div>
<div class="MsoNormal">
<br />2. Truncate the SysXPPAssembly in db model<br /></div>
<div class="MsoNormal">
3. Delete all the files in below directory in server where AOS hosted:<br /><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL<br /><div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
4. Start the service<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
5. Compile full CIL</div>
</div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-61937685430713822882017-01-03T12:03:00.002+03:002017-01-03T12:03:35.159+03:00Email drill-down link not working<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: #eeeeee; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px;">Copy the AxHLink.Exe...</span></div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-56735715042184968522016-12-28T11:34:00.000+03:002016-12-28T11:34:05.030+03:00Ax 2012 deki Word-Add in çilesine karşı 2009 Document Handling ile devam<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
https://www.youtube.com/watch?v=NVSxc2jg2iY<br />
<br />
<br /></div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-63310448713114030262016-11-15T00:51:00.001+03:002016-11-15T00:51:14.586+03:00Document Attachment through X++<div dir="ltr" style="text-align: left;" trbidi="on">
<pre style="background-color: #eeeeee; clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 16px; margin-bottom: 28px; overflow: auto; padding: 14px; tab-size: 4; word-wrap: normal;">static void hb_attach(Args _args)
{
DocuRef docuRef;
DocuActionArchive archive;
CustTable _custtable;
str _name;
;
_name=@"c:\\hb.docx";
select RecId from _custtable where _custtable.AccountNum =="M0001";
if (_custtable!=null)
{
ttsBegin;
docuRef.clear();
docuRef.RefRecId = _custtable.RecId;
docuRef.RefTableId = tableNum("custtable");
docuRef.RefCompanyId = curext();
docuRef.Name = _name;
docuRef.TypeId = 'File';
docuRef.insert();
archive = new DocuActionArchive();
archive.add(docuRef, _name);
ttsCommit;
}
}
</pre>
<div>
<br /></div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-79724092389068291052016-11-15T00:47:00.001+03:002016-11-15T00:47:23.890+03:00Get full physical path on attachment AX 2012<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background: none white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: #444444; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; text-align: left; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<span style="font-family: Arial, Helvetica, sans-serif;"><code class="jscript plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">select firstOnly DocuRef</code><code class="jscript plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">order by docuRef.RecId DESC</code><code class="jscript spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="jscript plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">where</code><code class="jscript spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="jscript plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">DocuRef.RefRecId == 645484</code><code class="jscript spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="jscript plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">&& docuRef.RefTableId == 56446</code><code class="jscript spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="jscript plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">&& docuRef.RefCompanyId == curext();</code><br /><code class="jscript spaces" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"> </code><code class="jscript plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-shadow: none !important; box-sizing: content-box !important; color: black !important; direction: ltr !important; display: inline !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">filename = DocuRef.completeFilename();</code></span></div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-90535558364900028792016-11-14T00:29:00.002+03:002016-11-14T00:29:29.721+03:00Send event by x++<div dir="ltr" style="text-align: left;" trbidi="on">
static void Event_sendAlertByCode(Args _args)<br />
{<br />
EventNotificationSource _source;<br />
EventNotification event = EventNotification::construct(EventNotificationSource::Sync);<br />
InventTable inventTable;<br />
;<br />
<br />
inventTable = InventTable::find('03.09.2013'); // sample record for which alert is shown<br />
<br />
event.parmRecord(inventTable);<br />
event.parmUserId(curuserid()); // user for which this alert to be shown<br />
event.parmDataSourceName('InventTable'); //form datasource<br />
event.parmMenuFunction(new MenuFunction('InventTable', MenuItemtype::Display));<br />
event.parmSubject('Test');<br />
event.parmMessage('Test Event alert');<br />
event.create();<br />
<br />
}</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-29597445852912221372016-11-14T00:20:00.001+03:002016-11-14T00:20:28.847+03:00Send mail with outlook<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> Description255 recipientEmail;</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> Notes emailBody;</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> Description255 subjectText;</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> Filename fileName;</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> SmmOutlookEmail smmOutlookEmail = new SmmOutlookEmail();</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> </span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> recipientEmail = "test@hotmail.com";</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> subjectText = "Test Email";</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> fileName = @"C:\Users\admin\Desktop\test.jpg";</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> emailBody = "Hi,\nThis is a test email";</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> </span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> if (smmOutlookEmail.createMailItem())</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> {</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> smmOutlookEmail.addEMailRecipient(recipientEmail);</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> smmOutlookEmail.addSubject(subjectText);</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> smmOutlookEmail.addFileAsAttachment(fileName);</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> smmOutlookEmail.addBodyText(emailBody);</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> smmOutlookEmail.sendEMail(smmSaveCopyOfEMail::No,true);// false for outlook popup</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> }</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> else</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> {</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> error("Could not communicate with Microsoft Outlook Client.");</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /><span style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;"> }</span><br style="background-color: white; color: #333333; font-family: "Helvetica Neue Light", HelveticaNeue-Light, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; text-align: justify;" /></div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-34617589600846410142016-11-11T01:16:00.000+03:002016-11-11T01:16:05.768+03:00progressbar sample<div dir="ltr" style="text-align: left;" trbidi="on">
static void operationProgress_progressBars(Args _args)<br />
{<br />
#AviFiles<br />
SysOperationProgress progress = new SysOperationProgress();<br />
int i;<br />
;<br />
<br />
progress.setCaption("Progress bar example…");<br />
progress.setAnimation(#AviUpdate);<br />
progress.setTotal(10000);<br />
progress.getCount_RU();<br />
for (i = 1; i <= 10000; i++)<br />
{<br />
progress.setText(strfmt("The value of i is %1", i));<br />
progress.setCount(i, 1);<br />
}<br />
} </div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-42444861818183350112016-11-10T23:27:00.000+03:002016-11-10T23:27:07.739+03:00Kill the excel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<pre style="background-color: #f2f2f2; border-radius: 3px; box-sizing: border-box; color: #1a1a1a; font-family: monospace, serif; font-size: 0.9em; padding: 10px; word-wrap: normal;">System.Collections.IEnumerable processes;
System.Collections.IEnumerator enumerator;
System.Diagnostics.Process process;
try
{
processes = System.Diagnostics.Process::GetProcessesByName("EXCEL");
enumerator = processes.GetEnumerator();
while (enumerator.MoveNext())
{
process = enumerator.get_Current();
process.Kill();
}
}
catch (Exception::CLRError)
{
throw error(AifUtil::getClrErrorMessage());
}</pre>
<pre style="background-color: #f2f2f2; border-radius: 3px; box-sizing: border-box; color: #1a1a1a; font-family: monospace, serif; font-size: 0.9em; padding: 10px; word-wrap: normal;">
</pre>
<pre style="background-color: #f2f2f2; border-radius: 3px; box-sizing: border-box; color: #1a1a1a; font-family: monospace, serif; font-size: 0.9em; padding: 10px; word-wrap: normal;">thanks for Martin. Martin!!! you are the man:)</pre>
<pre style="background-color: #f2f2f2; border-radius: 3px; box-sizing: border-box; padding: 10px; word-wrap: normal;"><span style="color: #1a1a1a; font-family: monospace, serif;"><span style="font-size: 14.4px;">https://dynamicsuser.net/ax/f/developers/68865/axapta-close-windows-application-process-with-x</span></span></pre>
<pre style="background-color: #f2f2f2; border-radius: 3px; box-sizing: border-box; padding: 10px; word-wrap: normal;"><span style="color: #1a1a1a; font-family: monospace, serif;"><span style="font-size: 14.4px;">
</span></span></pre>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-91907426994593627172016-11-09T18:01:00.002+03:002016-11-09T18:01:47.190+03:00Access Denied: MCRInventSearchController<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">For create products, i will take this error.</span></div>
<div style="text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">Solution:</span></div>
<div style="text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="background-color: white; color: #303131; font-size: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">You'll need to give access to the MCRInventSearch class, updateReleaseProducts method as a ServerMethod on either a privilege, duty, role</span></span></div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-68931747842247232732016-11-07T10:46:00.007+03:002016-11-09T18:02:12.660+03:00Workflow: Create custom work item queue<div dir="ltr" style="text-align: left;" trbidi="on">
1) First: CustomXXX document is not available for selection in the work item queue. See below.<br />
<br />
To fix this we simply need an attribute on the workflow document class. i.e<br />
[WorkflowDocIsQueueEnabledAttribute(<b>true</b>, "CustomXXX")]<br />
<b>class</b> CustomXXXWorkflowDocument <b>extends</b> WorkflowDocument<br />
{<br />
}<br />
<br />
Now we can create a work item queue based on this document.<br />
<br />
2) The answer to this was to create the following class:<br />
<b>class</b> CustomXXXTaskCreatedEventHandler <b>extends</b> WorkflowQueueCreatedEventHandler<br />
{<br />
}<br />
<br />
<b>protected</b> <b>void</b> mapFields()<br />
{<br />
#Workflow<br />
<br />
CustomXXX CustomXXX;<br />
WorkflowDocIsQueueEnabledAttribute attribute;<br />
DictClass dictClass;<br />
<br />
dictClass = <b>new</b> DictClass(<b>classNum</b>(CustomXXXDocument));<br />
attribute = dictClass.getAttribute(#WorkflowDocumentAttribute);<br />
<br />
CustomXXX = CustomXXX::findRecId(this.parmWorkflowWorkitemTable().RefRecId);<br />
<br />
this.parmDocumentId(CustomXXX.CustomXXXId);<br />
this.parmDocumentType(attribute.parmFriendlyName());<br />
this.parmCompanyInfo(CustomXXX.company());<br />
}<br />
<br />
HB: This was based on classes\PurchTableTaskCreatedEventHandler.<br />
<br />
This class extends WorkflowQueueCreatedEventHandler which in turn implements WorkflowWorkItemsCreatedEventHandler.<br />
In order to trigger this event you must point the workflow tasks to the above class.<br />
Find the task under AOT/Workflow/Tasks. Look for the property WorkItemsCreatedEventHandler. Put the name of your event handler in here. (in my case CustomXXXTaskCreatedEventHandler).<br />
<br />
Please go <span class="field-item-description user-defined-markup" id="fragment-13333_QuoteText">home/Work Items/ Work items assigned to my queues...</span><br />
<span class="field-item-description user-defined-markup"><br /></span>
<span class="field-item-description user-defined-markup">thanks </span>David <span class="field-item-description user-defined-markup">for topic : </span><a href="https://community.dynamics.com/ax/f/33/t/126896">https://community.dynamics.com/ax/f/33/t/126896</a><br />
<br />
<br />
<div class="MsoNormal">
<span style="color: #1f497d;"><o:p></o:p></span></div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-63886111972882881652016-11-07T10:46:00.005+03:002016-11-07T10:46:52.379+03:00Workflow: Create custom work item queue<div dir="ltr" style="text-align: left;" trbidi="on">
1) First: CustomXXX document is not available for selection in the work item queue. See below.<br />
<br />
To fix this we simply need an attribute on the workflow document class. i.e<br />
[WorkflowDocIsQueueEnabledAttribute(<b>true</b>, "CustomXXX")]<br />
<b>class</b> CustomXXXWorkflowDocument <b>extends</b> WorkflowDocument<br />
{<br />
}<br />
<br />
Now we can create a work item queue based on this document.<br />
<br />
2) The answer to this was to create the following class:<br />
<b>class</b> CustomXXXTaskCreatedEventHandler <b>extends</b> WorkflowQueueCreatedEventHandler<br />
{<br />
}<br />
<br />
<b>protected</b> <b>void</b> mapFields()<br />
{<br />
#Workflow<br />
<br />
CustomXXX CustomXXX;<br />
WorkflowDocIsQueueEnabledAttribute attribute;<br />
DictClass dictClass;<br />
<br />
dictClass = <b>new</b> DictClass(<b>classNum</b>(CustomXXXDocument));<br />
attribute = dictClass.getAttribute(#WorkflowDocumentAttribute);<br />
<br />
CustomXXX = CustomXXX::findRecId(this.parmWorkflowWorkitemTable().RefRecId);<br />
<br />
this.parmDocumentId(CustomXXX.CustomXXXId);<br />
this.parmDocumentType(attribute.parmFriendlyName());<br />
this.parmCompanyInfo(CustomXXX.company());<br />
}<br />
<br />
HB: This was based on classes\PurchTableTaskCreatedEventHandler.<br />
<br />
This class extends WorkflowQueueCreatedEventHandler which in turn implements WorkflowWorkItemsCreatedEventHandler.<br />
In order to trigger this event you must point the workflow tasks to the above class.<br />
Find the task under AOT/Workflow/Tasks. Look for the property WorkItemsCreatedEventHandler. Put the name of your event handler in here. (in my case CustomXXXTaskCreatedEventHandler).<br />
<br />
Please go <span class="field-item-description user-defined-markup" id="fragment-13333_QuoteText">home/Work Items/ Work items assigned to my queues...</span><br />
<span class="field-item-description user-defined-markup"><br /></span>
<span class="field-item-description user-defined-markup">thanks </span>David <span class="field-item-description user-defined-markup">for topic : </span><a href="https://community.dynamics.com/ax/f/33/t/126896">https://community.dynamics.com/ax/f/33/t/126896</a><br />
<br />
<br />
<div class="MsoNormal">
<span style="color: #1f497d;"><o:p></o:p></span></div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-56969849808841278272016-11-07T10:34:00.004+03:002016-11-07T10:34:33.020+03:00Ax 2012 lookup reference sample<div dir="ltr" style="text-align: left;" trbidi="on">
<pre style="background-color: #eeeeee; clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 16px; margin-bottom: 28px; overflow: auto; padding: 14px; tab-size: 4; word-wrap: normal;">public Common lookupReference(FormReferenceControl _formReferenceControl)
{
HcmWorker HcmWorker;
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysReferenceTableLookup sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(HcmWorker), _formReferenceControl, true);
;
sysTableLookup.addLookupField(fieldNum(HcmWorker, PersonnelNumber));
sysTableLookup.addLookupField(fieldNum(HcmWorker, Person));
queryBuildDataSource = query.addDataSource(tableNum(HcmWorker));
return sysTableLookup.performFormLookup();
}</pre>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-74843265375187952972016-11-02T23:09:00.004+03:002016-11-02T23:09:53.780+03:00Stopped (error): X++ Exception: Work item could not be created. Insufficient rights for user<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
Stopped (error): X++ Exception: Work item could not be created. Insufficient rights for user xxx.</div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
at SysWorkflowWorkItem-create</div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
SysWorkflowWorkItem-createWorkItems</div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
SysWorkflow-save</div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
SysWorkflowQueue-resume</div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
That workflow is only working if the user john has "System Admin" rights.</div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
<br /></div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
<br /></div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
For solution;</div>
<div style="background-color: white; box-sizing: border-box; color: #303131; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 15px; line-height: 20px; margin-bottom: 0.5em;">
a developer by going to the AOT > Workflow > Workflow types: select your workflow and in properties in the fields: 'DocumentWebMenuItem' and 'DocumentMenuItem' are menu items that the roles need in order to be able to run your workflows. If you add these, the problem should be solved</div>
</div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0tag:blogger.com,1999:blog-3227722488579964877.post-60808306963889364902015-05-27T21:10:00.002+03:002015-05-27T21:10:38.493+03:00DIEF hata: The version of Microsoft Excel is not supported.-The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine<div dir="ltr" style="text-align: left;" trbidi="on">
Merhaba,<br />
<br />
DIEF ile r3 versiyonunda gelen özellikler, 2009 versiyonundaki veri aktarımı sistemini özleyen danışmanları sevindiriyor. Bunlardan birisi source data formatlarda excel olarak format oluşturabilmek. Gerçekten güzel düşünülmüş bir yapı.<br />
<br />
Bununla ilgili bir hata aldım.<br />
<br />
<strong>The version of Microsoft Excel is not supported.-The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.</strong><br />
<br />
Bir blogta bir çözüm buldum. Alex zaten bu konunun en paylaşımcı kişilerinden...<br />
<br />
<span style="font-size: xx-small;"><a href="http://ax2012dmfdataimport.blogspot.com.tr/2014/05/dynamics-ax-2012-dixf-issues-and.html" target="_blank">http://ax2012dmfdataimport.blogspot.com.tr/2014/05/dynamics-ax-2012-dixf-issues-and.html </a></span><br />
<br /></div>
Hasan bilginhttp://www.blogger.com/profile/11269397459191139009noreply@blogger.com0