Dynamics Axapta blog

Hi, Please refer the below link to discovered the top 10 issue in the Ax coding. must read. http://blogs.msdn.com/b/axinthefield/archive/2014/02/18/top-10-issues-discovered-in-the-dynamics-ax-code-review.aspx Thanks, Vijaykarthik

Hi, To import the master data (like customer, vendor, worker..etc) by using Data import and export framework (DIXF) in Ax 2012 R3. Refer the below link for step by step explanation, http://shafeaa.blogspot.ae/2015/07/import-workers-using-data-import.html Thanks, Vijaykarthik

Hi, The below link is explain the use of excel add-in to import the general journal header and lines. http://www.daxfinanceblog.com/dynamics-ax/2015/1/11/upload-a-general-journal-from-excel-in-dynamics-ax2012-r3 I followed and imported the same. It is using the standard web service (which is coming in out of box). No customization/job is required. Note: Please check the Data source for General ledger is available or not. if not you can create it (after registration of LedgerGeneralJournalService) "Document Data sources" is available in Org.admin -> setup -> Document management. Happy Importing. Thanks, Vijaykarthik

Hi, I had situation, when my log file size is increased and there is no space in my drive. so I could not able to login to Ax. I used the shrink data base file option to reduced the log file size. For that, I have done below steps, 1) stopped my AOS service 2) Open SQL 2012 management studio 3) To set the Recovery model =  "SIMPLE" for your DB. (my case AxDevDB) (Choose Your DB, right click and go to properties and then go to Option tab to see the recovery model) 4) Right click the DB and choose SHRINK -> File and choose the AXDevDB_log file and press ok. (it will reduce 99% of the log file size). 5) To set back the Recovery model = "FULL" for your DB. 6) Start the AOS Service. To run the SQL Script, use below, USE AxDevDB; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE AxDevDB SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (AxDevDB_Log, 1); GO -- Reset th...

Hi, To build the procurement category in ax 2012, we are going to use the " EcoResCategoryImportService ". This service is available in the standard ax box. In this article, interest thing is how to build the XML file from EXCEL. I love that. (It is easy to build the xml file, if we know this way) Please refer the link below for the detailed document, http://www.junctionsolutions.com/dynamicsax/loading-a-merchandising-hierarchy-with-no-programming/ Create XML from Excel. https://www.youtube.com/watch?v=9h7TW--M8BU Note: Before import, you must enable the " Execute business operations in CIL" in this path, File > Tools > Options > Development > General > Execute business operations in CIL Thanks, Vijaykarthik

Hi, The below job is used to copy the favorites from one user to another user. static void CopyFavoritesJob(Args _args) { SysPersonalization FromSysPersonalization; SysPersonalization ToSysPersonalization; UserId FromUserId= 'user01' ; UserId ToUserId= 'user03' ; ; ttsbegin ; // step 1 - delete current favorites menu from user while select forupdate ToSysPersonalization where ToSysPersonalization.ElementType==UtilElementType::UserMenu && ToSysPersonalization.UserId==ToUserId { ToSysPersonalization.doDelete(); } // step 2 - duplicate from user01 while select FromSysPersonalization where FromSysPersonalization.UserId==FromUserId && FromSysPersonalization.ElementType==UtilElementType::UserMenu { ToSysPersonalization.data(FromSysPersonalization); ToSysPersonalization.UserId=ToUserId; ToSysPersonalization.doInsert(); } ttscommit...

Hello, Error when validate settings in Report servers by any admin account which is not account used to install the AX reporting services extensions. Scenario: In Microsoft Dynamics AX 2012 R2, if i login as an user with admin rights in both AX and SQL reporting services and in AX, under System administration, Setup, Business intelligence, Reporting Services, Report servers after i click "Validate settings", i receive the following error. "Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager." If i login as a user that was used to install the reporting services extensions and deployed the reports and ran the "Validate settings", the settings will be validated as correct. In reporting services report manager site, i have already granted the AX-Admins AD group as System Administrator under site settings, Home folder s...