Microsoft Dynamics AX 2012 Leading Zero Reading From Excel Sheet

I was importing the financial dimensions values i,e Business Unit , Cost Centre and Department.

I got stuck while importing the value 02 and after reading this value from excel sheet it was considered as 2.

after searching a lot to fix this issue I found the following links that helps me to resolve this issue.

http://dynamicsuser.net/forums/p/72274/384995.aspx

http://dynamicsuser.net/forums/t/53171.aspx

Thanks

Muhammad Zahid.

Deleting Legal Entity and its Transactions

Below is the the link that contains the info on how to delete the Legal Entity and its Transactions.

http://daxture.blogspot.com/2014/09/delete-legal-entities-in-ax-2012.html


Thanks

Muhammad Zahid. 

Microsoft Dynamics AX 2012 DataDictionary Synchronization errors

There was a working environment of Microsoft Dynamics AX 2012 with data.

I just changed its database file without changing the model file.The database file was without data.

After attaching the database i try to synchronized the data dictionary.

After synchronization I got the following error message on around 18 tables:

Below is the screen shot of this error that i was getting

I also compared the ids of the objects on which I was getting the errors in the sqldictionary table and the AX environment but the ids were same.

After getting some help from the below links I deleted the table on which I was getting the sync errors in the SQL Server Management Studio and than sync that table on Micosoft Dynamics.

After doing the above steps on each of the table that's generates the errors my issue was resolved.

Below are the links for more info on this.

http://blogs.msdn.com/b/axsupport/archive/2012/09/19/troubleshooting-aot-synchronize-errors.aspx

https://community.dynamics.com/ax/f/33/t/143042


Thanks

Muhammad Zahid.

Sql Query to Copy Data from one table of Database to Another table of different database

To copy large amount of data from one table of one Database to another table of different Database.We can use the below query.

note:To copy the data one thing keep in mind that the table definition in both the databases should be the same.

INSERT INTO MicrosoftDynamicsAX..userinfo 

SELECT * FROM MicrosoftDynamicsAX_Deleted..USERINFO where USERINFO.ID = 'admin'

The above code will copy the data from "userinfo" table of database "MicrosoftDynamicsAX_Deleted" to the "userinfo" table of database named "MicrosoftDynamicsAX"

Thanks

Muhammad Zahid

Error Renaming the Database name in Microsoft Sql Server

When I was trying the rename the database manually the Microsoft SQL Server was throwing the below error:

The database could not be exclusively locked to perform the operation.

After doing some research on this. I found out that there were some connections with that database already exists.

To resolve this we need to close all the connections first and than rename the database.

Below is the query to do all of this for us.

use master
ALTER DATABASE OldDBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE    
ALTER DATABASE OldDBName MODIFY NAME = [NewDBName]

ALTER DATABASE NewDBName SET MULTI_USER

here OldDBName is the name of your existing database and NewDBName is the name that you want to change.

More information on this can be found on the below link.

http://stackoverflow.com/questions/16685269/error-on-renaming-database-in-sql-server-2008-r2

Thanks

Muhammad Zahid.

Creating Multi Select lookup in SSRS reports in Microsoft Dynamics AX 2012

In this tutorial I share you the steps of creating the multi select lookup.

Below is the screen shot of the multi select lookup of how its looks like.

First of all we need to create the parm method in the contract class for this multi select company lookup.

As you can see this in the below image.

After that we need to bind the control to this parm method of multi select company lookup to the dialog box in the build method of the UI Builder Class.

After  that in the postRun method of the UI Builder Class we are calling the another method that we have created to create the lookup on the companyField Control.

Below is the definition of this companyLookup method.

In the above code the selected field container contains the fields which are selected by default when the lookup is open.You can also show the empty container if not to show any field selected by default.

This was all related to the multi select lookup in SSRS Reports.

If you have any question related to that than feel free to approach me.

Thanks

Muhammad Zahid.

Using Radio Button Control for RDP Based SSRS Reports in Microsoft Dynamics AX 2012 part 2

This is the second post related to the radio button control for RDP Based SSRS Reports.

In this post we will learn on creating the radio buttons using the enum with style property set to combo box.

below is the screen shot of the enum with style property set to combo box.

Below are the steps for creating the radio buttons from the enums of style type combo box.

First of all declare the following variables in the class declaration of the UI Builder Class.

After that write the following code in the build method of the UI builder class.

After that write the following code in the post run method of  the UI builder class after the super() method.

The above code is basically registering the override modified method on the selection change of the radio buttons.

Below is the definition of this reportTypeModifiedMethod

The above method is basically enabling and disabling the custAccount lookup on the selection change of the radio buttons.

Now after doing all of this please refresh the datasource node of the report on visual studio to see the parameters reflected there.

After running the report the parameters looks like this.

On the selection of "EEO prepartion" the custAccount lookup will gets disable as our reportTypeModified method that we have discussed previously is doing this.

One thing we noted here is that there is no need to create the contract method of the enum if the style of the enum is combo box.

This was all related to the creation of radio buttons from the enum having style = combo box.

Feel free to comment if you need further info on this,

Thanks

Muhammad Zahid.