Posts

Showing posts from January, 2016

How to change client Language in ax 2012

Image
Hello,  As you know that Dynmics Ax run on different languages. So I gonna tell you how to change client language country/region specific. this is nothing but a very simple step to do. Go To > File > Tools > Options > After that go to General tab and select the language which you want to use in your client. then apply and exit. In my case I was using Arabic language. Now restart your client and see the difference. You can do it from your database also . Go to Database server  . In my case it is sql server 2014. Select your database > tables > UserInfo > select the user > change the language code. Done Thanks.

Report server error rsServerConfigurationError ax 2012 ssrs report / SQL server 2014

Image
Hello , Today I ran a ssrs report and got the below error. Error while setting server report parameters. Error message: The report server has encountered a configuration error. Logon failed for the unattended execution account. ( rsServerConfigurationError ) Reason could be that the execution account doesn't have proper access to DB server. In case if you want this to be the desired setting, then In Report Manager Site, select the Credentials are not required option. Otherwise you can provide proper access to execution account on your db server. Solution: Go To > Report Services Configuration Manager > Connect to report services Now select Service Acount tab and check the Credentials. And Set the right username and password. Do the same thing with Execution Account then click on apply and Exit. Now run the same report I will work.  Thanks.

Create record in inventdim table through code X++ in ax 2012

Hi , Today I am going to tell you how to create record in inventdim table through code. In InventDim Table we cant use .insert() method for creating record. As it is very important table and hit many transaction so it is recommended not to play with this table unless it is not necessary. may be it cause data in consistancy. But as like me if you have to do with this table you can use below code at your own risk. Its is working code for sure.  ttsBegin;         item = InventTable::find(ItemId);                  // Item id = "Item-0001"         inventdim.InventSiteId          = Site;              // Site = "Site1"         inventdim.InventLocationId      = Location;  // Location = "Location1"         if(item.colorActive())       ...

Number Sequence for existing module in ax 2012

Image
Number sequences are unique identifiers that can be associated with a master record so that they can be individually distinguished. They can be either formatted as alpha-numeric strings or simply as numbers. Microsoft Dynamics AX 2012 provides an easy to implement framework to generate custom number  sequences. Scenario As part of this tutorial, a custom number sequence will be generated for the Customer Groups setup form ( Accounts receivable  à  Setup  à  Customers  à  Customer groups ) Steps First create a new  Extended Data Type (EDT) . Open  AOT  à Data Dictionary  à  Extended Data Types Right Click on  Extended Data Types  and create a new EDT  NumSeqDemoCustGroupNum  of type  String Set the properties as shown below Now go to  AOT  à  Classes  and open the  NumberSeqModuleCustomer  class by right clicking it and selecting  View Code ...

Reports showing username and password when opening SSRS report

Image
Reports showing username and password when opening SSRS report When opening a report you see the username and password dialog Now what is the possible reason for this issue. You might have changed your AX reporting service account to any other account in the reporting service extension recently, as shown below. Note : In my case I did the same.  Solution : To resolve this issue I just redeployed all my reports from AOT and issue gone.   Please check with any one report. If u get your issue resolved then redeploy all your report. Thanks. 

You are not authorized to access table "abcTableName" (Table Name). Contact your system administrator

Image
You may experience the subject mentioned error while opening a table / view   Solution : There are two solution for this error and  its depend on error you are facing 1. If it is because of view then check the view. is there any field available or not. Just add a field in ur view and problem will be solve. 2. If it is because of Table then check configuration key for that table is enable or not go to > system administration > Setup > License > License Configuration > now check your configuration key and enable the same and sync the table.

Product / Product Master Import through DIXF Ax 2012 R3

Image
The Microsoft Dynamics AX 2012 Data Import/Export Framework helps you import and export data in AX which include master data, open stock, and balances. For Microsoft Dynamics AX 2012 R3, Data Import/Export Framework is included in the release. For Microsoft Dynamics AX 2012 R2, Data Import/Export Framework is available in cumulative update 7 for Microsoft Dynamics AX 2012 R2. For AX 2012 or Microsoft Dynamics AX 2012 Feature Pack, Data Import/Export Framework is available from Information Source-download. Step 1: Define Parameters Navigation: Data import export framework > Setup > Data import/export framework parameters Create a folder in your directory Browse the location for the folder which is created Validate the directory, it will show the Green check box Step 2: Pre-defined Entities in AX AX has some of the pre-defined entities inbuilt in the application of which we will use one of them. Navigation: Data import export framework > Setup ...