Announcements
No record found.
*This post is locked for comments
HI,
When you create a new line, AX will increment the line number automatically. When you hit the New button or uses the shortcut ctrl+N, a line above the existing line will be inserted. If this was at the point of the first row of the grid, you get a new line at the top. In this case AX can create negative line numbers. It tries to keep the line as inserted. The negative values do not harm your system.
Journals are having its logic to get new journal lines number
normally as per logic line numbers are in sequence, but let suppose if we press ctr+N in between two records logic generates line number in between, line 0.5 if line is created in between 1 and 2
like that if you have one record created with linenum = 1 and your you click 'New' button or press ctrl + N, system will give -1 as next line num
What is suggested over here as work around is to press 'Down arrow' to create a new record, in this case
you will get correct next sequence number
Please verify and let me know your findings.
Hi. I want to show line number for users, because they want to know number of each line for ease of access to journal line and can access lines faster. but when it shows negative value, I can't show it to user. what can I do?
Regards
create a display method using LineNum
if LineNum is return 0
and for text box which shows the linenum, set the property to not to show the 0 value
Please verify and let me know if you need details
Hi. I show this line number to users and based on line number, users find they lines of order or journals. when it shows minus value, they get confused about that. what have to do?
Hi,
As said in my previous reply it is standard behavior. If the users thinks it is confusing, you can consider create a small customization where the auto line increment will be disabled on the form and the increment will be done in the insert method of the table.
Note that then always newly added lines will be put at the end of the journal. It is then not possible anymore to insert a record between two other lines.
You can also teach the users to create the lines at the end of the journal instead of use the Ctrl+N funcitonality.
You can also tell them that the negative line number really do NOT harm the system. It is just a method of having the lines in a specific order.
Hi. Thanks for reply. in some cases in sales order line, we have duplicate line number.why?
This is another question. Can you provide an example of the duplicate number and records before and after this duplicate?
It could be caused by inserting records at the same point again and again. AX tries to create a line number between the records where the new sales line is inserted. Once it cannot create a new line number due to rounding and maximum number of decimals you can get the duplicate.
Overwrite create method of datasource and change the default parameter value to 'True' for positive numbers
Hi Srikanth Nunna,
After this Change Line Number Comes Positive Numbers. But i am Selecting inbetween line placed on cursor, then create new line same line number will be Repeated.
Please give any Suggestion
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 24
Michel ROY 14
Jagadabi 6
