Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Linenum 0 for sales order line

(0) ShareShare
ReportReport
Posted on by 55
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.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans