tag:blogger.com,1999:blog-60343079529666218752024-03-13T07:53:23.468-07:00AXforRetailFindings about AX for RetailEugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-6034307952966621875.post-85854507062184018132018-05-22T15:30:00.003-07:002018-05-22T15:30:58.708-07:00Understanding POS reportsHats off to Kurt once again, for this walkthrough on understanding mPOS reports:<br />
<br />
https://kurthatlevik.com/2015/08/12/dax-2012-r3-retail-channel-pos-reports/<br />
<br />
#noteToSelfEugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.com0tag:blogger.com,1999:blog-6034307952966621875.post-10930229121332243092017-04-06T17:02:00.000-07:002017-04-06T17:02:34.384-07:00Editing license configuration requires *Maintenance Mode* - use Deployment.Setup tool<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Today I tried to change license keys in Dynamics 365 for Operations to enable <i>Commerce essentials</i> license key. What was unexpected comparing to previous AX versions is that i could not do it.</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">The warning says:</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><i>This form is read-only unless the system is in the maintenance mode. Maintenance mode can be enabled in this environment by running maintenance job from LCS, or using Deployment.Setup tool locally</i></span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Luckily there is a long guide on <a href="https://ax.help.dynamics.com/en/wiki/configuration-mode/" target="_blank">AX wiki</a>. To spare you some time here is all you need to know:</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">1. Navigate to your AOS folder (e.g. C:\AOSService\PackagesLocalDirectory\Bin</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">2. Press Shift on keyboard, hold it, right-click in Explorer</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5w8ViTS9UY2m8_CpBdV4FMqzPn7vmUtSnRrX_XYmI3bQixla9Hqy9YLIklv7Wo2iOnKQECIO__coE2GXY2mQqOE8cu-KAp1jphH_bjvqYkh3tQKrkQN2JQ5JayWeJDczHHXpk5Sf34BI/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5w8ViTS9UY2m8_CpBdV4FMqzPn7vmUtSnRrX_XYmI3bQixla9Hqy9YLIklv7Wo2iOnKQECIO__coE2GXY2mQqOE8cu-KAp1jphH_bjvqYkh3tQKrkQN2JQ5JayWeJDczHHXpk5Sf34BI/s1600/Untitled.png" /></a></div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">3. Paste this and change parameters with your variables:</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">Microsoft.Dynamics.AX.Deployment.Setup.exe -setupmode maintenancemode --metadatadir C:\AOSService\PackagesLocalDirectory --bindir C:\AOSService\PackagesLocalDirectory --sqlserver "." --sqldatabase "AxDB" --isinmaintenancemode true --sqluser Godzilla --sqlpwd 1</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: helvetica neue, arial, helvetica, sans-serif;">pay particular attention to Metadatadir, bindir, sqluser, sqlpwd parameters</span><br />
<span style="font-family: helvetica neue, arial, helvetica, sans-serif;"><br /></span>
<span style="font-family: helvetica neue, arial, helvetica, sans-serif;">4. Paste into the command line window</span><br />
<span style="font-family: helvetica neue, arial, helvetica, sans-serif;">5. This is what you should get:</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsMrldhOKXx_rx8JEijdQBXb-rvRsyChI47ue8qWfPXhk_NtMtdh7sHLFA_WQjysXxDy9pCik3MyB386r-jmEyNnuUJNOIDcTITmrRM-IqFdh4aRmJxIpVqCoC3VOrju5m0oZ1bzV-Ltk/s1600/Untitled222.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsMrldhOKXx_rx8JEijdQBXb-rvRsyChI47ue8qWfPXhk_NtMtdh7sHLFA_WQjysXxDy9pCik3MyB386r-jmEyNnuUJNOIDcTITmrRM-IqFdh4aRmJxIpVqCoC3VOrju5m0oZ1bzV-Ltk/s1600/Untitled222.png" /></a></div>
<span style="font-family: helvetica neue, arial, helvetica, sans-serif;"><br /></span>
<span style="font-family: helvetica neue, arial, helvetica, sans-serif;">6. Type </span><span style="font-family: Courier New, Courier, monospace;">iisreset -noforce </span><span style="font-family: helvetica neue, arial, helvetica, sans-serif;">and press enter</span><br />
<span style="font-family: helvetica neue, arial, helvetica, sans-serif;">7. Log back into Dynamics 365 for Operations</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Now you'll be able to edit the license keys.</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Once you do,</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Remember to turn off the maintenance mode:</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: "Courier New", Courier, monospace;">Microsoft.Dynamics.AX.Deployment.Setup.exe -setupmode maintenancemode --metadatadir C:\AOSService\PackagesLocalDirectory --bindir C:\AOSService\PackagesLocalDirectory --sqlserver "." --sqldatabase "AxDB" --sqluser Godzilla --sqlpwd 1 </span><span style="font-family: "Courier New", Courier, monospace;">--isinmaintenancemode </span><b style="font-family: "Courier New", Courier, monospace;">false</b>EugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.com0tag:blogger.com,1999:blog-6034307952966621875.post-12579533233469170882012-03-25T21:54:00.000-07:002012-03-25T21:54:57.296-07:00Retail 2012 virtual launch event<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUigH2zG4Nmdrm2W4WB3PDc1W3ZmgjC_7tRuRTuZ1CFt3sfdiLhkSCFzVcYDkSkahu5evK7v7MUQBpZbqayuGG1hlwBPt29gYR8VIkW_yY-E7JZxrwsxSznz5tjla4eLRaI5B72uWOjIY/s1600/WP_000075.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUigH2zG4Nmdrm2W4WB3PDc1W3ZmgjC_7tRuRTuZ1CFt3sfdiLhkSCFzVcYDkSkahu5evK7v7MUQBpZbqayuGG1hlwBPt29gYR8VIkW_yY-E7JZxrwsxSznz5tjla4eLRaI5B72uWOjIY/s1600/WP_000075.jpg" /></a></div><div style="background-color: white; color: #333333; font-family: 'Segoe UI', Arial, Verdana; font-size: 12px; line-height: 18px; margin-bottom: 10px; text-align: left;"><br />
</div><div style="background-color: white; color: #333333; font-family: 'Segoe UI', Arial, Verdana; font-size: 12px; line-height: 18px; margin-bottom: 10px; text-align: left;">After AX convergence, there was a retail event. </div><div style="background-color: white; color: #333333; font-family: 'Segoe UI', Arial, Verdana; font-size: 12px; line-height: 18px; margin-bottom: 10px; text-align: left;">To get inspired & motivated watch these exciting videos and demos:</div><ul style="background-color: white; color: #333333; font-family: 'Segoe UI', Arial, Verdana; font-size: 12px; line-height: 18px; text-align: left;"><li><a href="https://presentations.inxpo.com/Shows/microsoft/2-12/Registration/registration.htm?CR_CC=200085801&CR_ID=90614489" style="color: #0066dd; font-weight: bold; text-decoration: none;" target="_blank">Watch the on-demand global Virtual Launch Event</a> to see how leading retailers are using this solution to support rapid growth, and learn about the other powerful capabilities that are new to Microsoft Dynamics AX 2012, or</li>
<li><a href="https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:4;F:APIUTILS!51004&PageID=E92B616D-677F-42E0-A1B4-70FB40C95FE3&CR_CC=200085801&CR_ID=90614489" style="color: #0066dd; font-weight: bold; text-decoration: none;" target="_blank">Download the Gartner ERP strategy whitepaper.</a> (this link did not work, try at your own risk).</li>
</ul><div style="background-color: white; color: #333333; font-family: 'Segoe UI', Arial, Verdana; font-size: 12px; line-height: 18px; margin-bottom: 10px; text-align: left;">You can follow <a href="https://twitter.com/#!/MSFTDynamicsERP" style="color: #0066dd; font-weight: bold; text-decoration: none;" target="_blank">@MSFTDynamicsERP</a> on Twitter to learn about new exciting marketing materials.</div><br class="Apple-interchange-newline" />EugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.com0tag:blogger.com,1999:blog-6034307952966621875.post-16451138462748924302012-02-06T22:07:00.000-08:002012-02-06T22:07:41.411-08:00OPOS Problems?<div dir="ltr" style="text-align: left;" trbidi="on">A step that is often overlooked after an OPOS driver install is the installation of common control objects from Monroe Consulting Services. They can be found <a href="http://monroecs.com/oposccos_current.htm" target="_blank">here</a>.<br />
I faced the same troubleshooting problem when setting up HP rp5700 with Dynamics AX for Retail 2009.</div>EugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.com0tag:blogger.com,1999:blog-6034307952966621875.post-35962474353188076852012-01-21T14:44:00.000-08:002012-01-21T14:44:50.107-08:00Stack trace: The company XX does not exist. (S)\Classes\DirParty\updateAddressFromDirParty - line 149<div dir="ltr" style="text-align: left;" trbidi="on">This is a case worthy of Agatha Christie.<br />
Starting conditions:<br />
Error infolog appeared when saving an address for a vendor by a user, who has access to only a subset of virtual company's company set.<br />
<br />
In other words: We have a virtual company that shares DirParty and Vendor tables. Let's say the companies in the virtual company are: 01,02,03,04,05. The user has permissions to access only 01 and 02.<br />
<br />
The user creates a Vendor record. When adding the address, the error appears.<br />
<br />
On a closer look, the DirParty class, method UpdateAddressFromDirParty has an interesting function: for a public address create address records in all the real companies which are the part of the virtual company. In our case 01,02,03,04,05.<br />
So the conflict arises: The user only has permissions for 01 and 02, while the program wants to update more.<br />
The solution is to introduce some sort of validation of whether the user has permission to the company, which AX is trying to update:<br />
<br />
<span style="font-family: 'Courier New', Courier, monospace;"> if(Sysdataarea::checkAccessible(dataAreaId)==false)</span><br />
<span style="font-family: 'Courier New', Courier, monospace;"> {</span><br />
<span style="font-family: 'Courier New', Courier, monospace;"> infolog.closeInfolog(100);</span><br />
<span style="font-family: 'Courier New', Courier, monospace;"> continue</span><br />
<span style="font-family: 'Courier New', Courier, monospace;"> }</span><br />
<span style="font-family: inherit;">That is a crude way to verify whether the user has access to the company Dynamics AX wants to </span>update<span style="font-family: inherit;"> an address in. </span><br />
<span style="font-family: inherit;">Place this code right after the following line:</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">dataAreaId = conpeek(addressDataAreaList,i);</span><br />
<span style="font-family: 'Courier New', Courier, monospace;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO1aaK-QwAw5u_AHB21iSp3WLiYUeJuNX_vtwXFb11CIR9feQA685g0DqZc0kdZrK-TZchDFkJHuGGsYCgQVNtasBLE1DCoDlrJ0DX6mIhOj0OZ7OaHXuUViG8VPdXQ_o8ymz3dCklQok/s1600/Untitled1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO1aaK-QwAw5u_AHB21iSp3WLiYUeJuNX_vtwXFb11CIR9feQA685g0DqZc0kdZrK-TZchDFkJHuGGsYCgQVNtasBLE1DCoDlrJ0DX6mIhOj0OZ7OaHXuUViG8VPdXQ_o8ymz3dCklQok/s320/Untitled1.png" width="320" /></a></div><span style="font-family: 'Courier New', Courier, monospace;"><br />
</span><br />
<span style="font-family: inherit;">Of course, test it out before applying to a production environment.</span><br />
</div>EugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.com0tag:blogger.com,1999:blog-6034307952966621875.post-70228862000185715852011-09-20T13:46:00.000-07:002011-09-20T13:46:50.900-07:00AX 2009 not importing the records into a virtual table<div dir="ltr" style="text-align: left;" trbidi="on">Not an AX4Retail post per se, but rather a generic finding.<br />
Just had a situation where i've shared address tables to a virtual company. Did the re-import and the data did not appear in the target companies. The import also did import the data into the single company, not to the virtual company.<br />
This was a strangely manefesting issue, given the fact that it was RU6 AX2009.<br />
However a simple AOS restart fixed the whole situation. Now the address data.<br />
Cause is unknown.</div>EugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.com0tag:blogger.com,1999:blog-6034307952966621875.post-30683964818658033122011-08-31T11:54:00.000-07:002011-09-26T13:46:30.186-07:00Training for Dynamics AX for Retail in October 2011<div dir="ltr" style="text-align: left;" trbidi="on">Allright, finally we've got the link. You can register for the upcoming training <a href="https://training.partner.microsoft.com/learning/app/management/registrationex/LMS_Registration.aspx?UserMode=0&Mode=0&ActivityID=746101">here</a>. It will be taking place in Atlanta, GA from the 3rd till 6th of October. Starts monday morning at 8 AM sharp!<br />
<br />
As usual, two days of functionality-oriented stuff and two days of more technical stuff, mixed with more functionality. No programming assignments.<br />
<br />
UPDATE: it is actually cancelled. I'll post here when/where is the next one i'm conducting..</div>EugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.com0tag:blogger.com,1999:blog-6034307952966621875.post-43226456181924566892011-08-26T15:51:00.000-07:002011-08-26T15:51:14.919-07:00Error 12288 An error when connecting to store connect<div dir="ltr" style="text-align: left;" trbidi="on">Captain obvious... AX for Retail's installation documentation mentions that the store connect service should run under a dedicated domain account. Remember this when setting up the store-side Retail store connect.<br />
Also other steps to troubleshoot this errors would include:<br />
1. making sure the store connect service is running at the store side<br />
2. make sure HQ-side computer can resolve the name of the store-side SC server name into an IP address.<br />
3. make sure that you've set up corresponding port numbers<br />
4. make sure that these ports/store connect program are not blocked by the firewall<br />
5. verify that you use/or not "use encryption" at both sides (in HQ and in Store's Retail store connect)<br />
6. also make sure that you have set up IPsecure in case you use encryption<br />
<br />
Hope that helps.<br />
<br />
</div>EugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.com0tag:blogger.com,1999:blog-6034307952966621875.post-5364912031964845632011-08-11T11:21:00.000-07:002011-08-11T11:26:21.125-07:00Regarding AX2012Just attended a call regarding future direction of AX for Retail. <div>It looks like the first release for Microsoft Dynamics AX 2012 will retain the same functionality as R2 for AX 2009 with some slight variations in the following:</div><div><ol><li>Product structure</li><li>Retail hierarchy will lose the limitation of 4 levels</li><li>Organizational structure</li></ol>Regarding the last one it would make sense that it would drive the data distribution and be used in promotions, but it is too early to tell whether it will. </div><div>
<br /></div><div>Again, not all the countries will see AX2012 at the same time, since it does not become available in some market until later.</div>EugeneGTIhttp://www.blogger.com/profile/05259880469948209979noreply@blogger.com0