Category Archives: Microsoft Dynamics AX

AxBuild.exe compilation error

Yesterday when i try to compile my AX 2012 R3 with AxBuild.Exe, i was getting the following error “Object Server 01:  Can not create default Keyset. Error code -2146893809”. Here i was running the command prompt as an Adminitrator and … Continue reading

Posted in Microsoft Dynamics AX | Tagged , , , | Leave a comment

AX2012 R3 demo data transfer tool not detecting the database

Hello Friends, Today i have tried to import the demo data into my AX 2012 R3 instance. But the test data transfer tool is not detecting my database. It is always showing that no databases found, even though the database … Continue reading

Posted in Microsoft Dynamics AX | Leave a comment

Getting Vendor addresses based on Address type in AX 2012 R2/R3

The following query gets the vendor addresses  select ROW_NUMBER() over (partition by v.accountNum order by dpl.isprimary desc, lpa.recid) as AddressNumber,v.ACCOUNTNUM,lpa.ADDRESS,llr.NAME from VENDTABLE V  join DIRPARTYLOCATION Dpl on v.party=dpl.party  and dpl.ISPOSTALADDRESS=1  join LOGISTICSPOSTALADDRESS lpa on dpl.LOCATION=lpa.LOCATION    join DIRPARTYLOCATIONROLE dplr on … Continue reading

Posted in Microsoft Dynamics AX | Leave a comment

AX 2012 CU7 faster compilation

To perform the faster compilation of AX, follow the steps below Go to following server configuration window “Control Panel\System and Security\Administrative Tools\Microsoft Dynamics AX 2012 Server Configuration.lnk” Enable the feature hot swapping assemblies Go to command prompt (open as Administrator) … Continue reading

Posted in Microsoft Dynamics AX | Leave a comment