Hi All,
I'm troubleshooting an issue, and wanted to ask around if anyone has ran into anything similar, or might have some suggestions:
We ran into an issue where one of our sales orders, I believe after being invoiced, added a new line with a linenum of 0. The item number of the line added was just the same as the existing line with a line amount of 0:
The concerns were, how could this new 0 line have been added and whether it may cause issues. I checked in SQL and it is our only sales line with a linenum of 0. I tried through the UI to recreate a line with 0 linenum, and tried through the excel connector. I was not able to change or affect linenum through either of those.
When writing this, this post is suggested as a similar issue, but in the post the answer is to set the Counter Field property. I checked this in the forms in VS and the counter for the SalesLine data source on the forms is set to Linenum:
I've checked any customizations we have around sales orders, and none of them seem to affect linenum, and have been in place for quite some time. When this issue happened it had also been quite some times since we last upgraded.(10.0.30 at the time the SO was invoiced and 0 line was created)
The only other thing I could think of was a data import, but we don't have any data import projects setup for sales orders/lines and could not find any history of an import for it.
So my question is, is this 0 line something to be concerned about? And if anyone has ran into it or similar before, what other paths should I look into for troubleshooting. Any help or suggestions are greatly appreciated, thank you.