Hi,
I’m using AX2009, my client always encountered problem while creating a general journal. The number sequence for GL 2013 is setup as “XXXXXXXX13”, but sometimes system will appear number for “XXXXXXXX12” (GL 2012). I know how to resolved it. Need to delete all number in (Basic > Number Sequence > List). But now, I just want to know, why this problem will be happened? how to prevent it?
Hi,
No need to delete all number in (Basic > Number Sequence > List). don’t do that.
The problem with the duplicated number is available in the Table. Delete the duplicated record in the table and change you number sequence setup to continuous.
Hi Mukund,
Thanks for helping. But, I think your way is same as I did. I’m just trying to find the solution, how to prevent this issue will be not happen again. Do you have any idea or solution? Another things, why this issue will be happened? Is it because of mistake from user?
Hi,
we cant say this is user mistake it may or may not be. Its a strange behavior of AX. Pls. follow below links to resolve this issue.
http://www.amer-ax.com/2010/04/error-cannot-create-a-record-in-the-record-already-exists/
http://community.dynamics.com/ax/f/33/t/70736.aspx
http://community.dynamics.com/ax/f/33/t/112225.aspx
http://community.dynamics.com/ax/f/33/p/70737/227804.aspx
hope this information will help you
Thanks
Hi Mukund,
I think you are not understand my situation. For example, “12-0099” is batch for year 2012 and the number didn’t used before. We are in 2013, so the setup batch is for 2013 and the sample for the next number is “13-0022”. When user try to create a new batch for this year (2013), suddenly system use the number “12-0099” instead of “13-0022”. To solve it, need to delete the number “12-0099” in (Number Sequence > List). So, my question is how to come system suddenly use the number for year 2012 instead of 2013? What is the root cause and how to prevent it?
