Sure, in SQL Server Management Studio, you could right-click on the SO_SalesOrderDetail table and select Edit Top 200 Rows, which opens the grid where you can directly edit the table. To filter down, press Ctrl+3 to view the SQL Statement, and you can then edit (maybe add "WHERE LineSeqNo IS NULL OR LineSeqNo = '' OR LEN(LineSeqNo) = 0" to the end of it), and then press Ctrl+R to execute your new SQL statement.
------------------------------
Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
------------------------------
Original Message:
Sent: 09-25-2019 21:47
From: Jeff Schwenk
Subject: Can't move certain lines on an order down or up
I thought the beauty of Premium was that you could fix the tables via SQL for this sort of thing @Steve Inowaski (sp? Sorry).
------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------
Original Message:
Sent: 09-25-2019 13:19
From: Wayne Schulz
Subject: Can't move certain lines on an order down or up
In further reviewing SO_Sales_Order_Detail it appears some of the lines are missing the field LinkeSeq$ which is likely the culprit here. This particular customer has 3rd party solutions including Accellos so I'm unsure if integration could be causing this.
Is there a way to rebuild the line sequence numbers? I tried reset all rows and that didn't seem to do it ( or do anything for that matter )
------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990