Number sequence showing 0000 after upgrade to AX2012 R2 in place.

After doing an in place upgrade from previous version of AX2012 I faced this issue:

When you have a number sequence that is set to continuous and the number that pulls into the form is 000000 and is not a valid number.

This is caused by the Stored Procedure not getting updated when the R2 in place upgrade process is complete.  We suspect that this problem may be due to incorrect steps done during the upgrade that we are not able to reproduce.

To copy out the stored procedure from a working data base you will use the following steps:

1. Open SQL Server 
2. Expand Databases
3. Select your database
4. Expand Programmability
5. Expand Stored Procedures
6. Right Click on dbo. getNumInternal
7. Click Modify

 9. Select all and Copy the code form the old environment in which the number sequence was working good.

Copy the stored procedure in the R2 environment under the same stored procedure and then you can execute the code by clicking the Execute button.


Please make sure you have a backup of your data base before you try these steps.  You will need to restart the AOS and AX after you have run this code.

This will resolve your number sequence problem.

Hope this helps.

AX 2012 Button click events override not found under Action tab.

In AX2012 I faced the following issue:

I tried to add a new method or override any existing method on CustListPage form, I was not able too as the option was not available. Also I am not able to find how to write method for list page new buttons. I also try button, command button and other but not working. Check below Image


I found out the solution to fix this problem, this problem is a new feature in AX2012 - the ability to use the same list pages both in AX client and on Enterprise Portal. If  I change buttons DisplayTarget property to "Client", then you can override buttons methods - but you can't use that button on EP any more. By default the value of this property is "Auto" as shown below:

Hope this helps.