Within the past week, a strange issue is sporadically occurring.
When entering a new quote/order, the first sales line "Line No." is assigned 10000. (Like it should be)
However, Navision is occasionally assigning lower "Line No." numbers for subsequent line items. For example, the 2nd line item is assigned 5000.
It's acting like your entering a new line between two existing lines and the AutoSplit key is taking over. However, this is happening on the very bottom line.
In some cases, I have created "test" quotes with two line items like this:
Line item # 1: Type = Item, Line No. = 10000
Line item # 2: Type = Resource, Line No. = 20000
And when I converted it to an order, it did this:
Line item # 1: Type = Item, Line No. = 10000
Line item # 2: Type = Resource, Line No. = 5000
Has anybody ever seen this???
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
regards
Document Type,Document No.,Line No.
I did noticed that, when changing the TYPE, it will not always change to what I selected, such as Resource. I have to select it twice from the drop-down. Doesn't happen every time but, when it DOES, is when it screws up the numbering. It's almost as if there is a ghost line item with a Line No. of "0" so my new entry gets insert between "0" and "10000", since the new entry's Line No. is "5000".
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Like, perhaps, a network problem.
I think I'll start looking into that possibility because, after all, it IS a sporadic issue.
It's called inserting between lines...
if you are inserting before of the first line it takes as line no. the middle number between that line (10000) and the previous line, since there is no previous line, that no. is 0.
Ok, when you are not changing the type, you can check this:
1) On the form check the OnNewRecord trigger.
2) In OnInsert on the table, check if the Line No. is already filled in when the trigger is called. Check if there is correct value.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Regarding step 2
<<2) In OnInsert on the table, check if the Line No. is already filled in when the trigger is called. Check if there is correct value.>>
I'm not sure how I can make sure that the value is correct.
How would I know if the line is be inserted at the bottom or between existing records??
](*,)
You know as user if you hit the F3 when you are on the last record or not... and you need to look on the record line no. and the next record line no to know which line no you need to be used (you need what you are really doing and compare it with what system creates for you).
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Follow David's advice and check the tables from the object designer.
RIS Plus, LLC