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:
- Open SQL Server
- Expand Databases
- Select your database
- Expand Programmability
- Expand Stored Procedures
- Right Click on dbo. getNumInternal
- 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.
