web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

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.
  • Rafael Araujo Profile Picture
    193 on at

    Hi @Cody M ,

    Did you solve the issue? I have the same issue in ProjSalesItemReq form, that add line in SalesLine table.

    Thanks!

  • CU25090513-0 Profile Picture
    2 on at

    Hello, Beelink’s current information says GTi12/13 share the same BIOS, and the 2026 update addressed CSME issues, but I haven’t seen www myfedloan com confirmation that it specifically fixes PCIe dock freezes. There are also recent GTi13 reports where Gen3 was needed for stable external-GPU operation. Since Gen3 has already stopped your freezes with little performance loss, I’d keep it there until Beelink confirms the correct BIOS/ME combination for your serial number and whether T201 can be upgraded directly.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    15,320 Super User 2026 Season 2 on at

    Hi @Cody M  and @Rafael Araujo ,
     

    ProjSalesItemReq works with project item requirements, which are represented internally as sales-order documents. Therefore, finding the corresponding record in SalesLine is expected. However, a persisted line with LineNum = 0 should still be investigated.

    The CounterField = LineNum property only assigns numbering when a line is created through that particular form data source. It is not a database-level constraint. A record created through X++, an integration, a data entity, batch processing, or another form can bypass that form behavior.


    I suggest the following:
    -Reproduce the issue in a sandbox using the exact same item-requirement process.
    -Confirm whether it also occurs in a current, supported application version without customizations.
    -Review extensions, integrations, batch jobs, and event handlers that insert or copy SalesLine records. Pay particular attention to code using insert() or doInsert() without executing the standard sales-line initialization and line-number assignment logic.
    -If the issue is reproducible, capture a trace of the operation and inspect the X++ call tree to identify where the record is inserted.

    Even when its quantity or amount is zero, do not assume the line is harmless. Check for related inventory, project, packing-slip, invoice, and other downstream records before attempting remediation. Also, do not update or delete the record directly in SQL. Any correction should use a reviewed X++ data-fix script or be handled with Microsoft Support.
     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284 Super User 2026 Season 2

#2
Aayush Tiwari Profile Picture

Aayush Tiwari 217

#3
Subra Profile Picture

Subra 200 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans