Is there a way to re-sequence sales order lines without deleting or adding the lines again?
Nope. Closest alternative is to use the POLine field. Depending on your requirement you could use this value to sequence lines in various reports; Order Acknowledgement, Packing List, Invoice, etc.
QuoteDtl has a hidden DisplaySeq but OrderDtl does not. You could either add that as a UD field or borrow a field like POLine as Zack said and then sort by that.
As far as renumbering the actual line numbers though, no.
1 Like
If no transactions have occurred copy the lines out to excel, reorder them, delete the lines and paste new back.
Why do you want to resequence the lines, is it for ordering the lines on the pdf output if so, then you can just add a ud field for sequence and configure the SSRS to support it.
We have a UD field for sequence, one for Description and one for the ‘master’ order line. All so we can print in the order we want, and to ‘scrunch’ lines so that they all roll up to the ‘master’. (mostly for the scrunch part)
You could probably alter whatever report you are using to sequence the lines in the report itself, but you can’t change the OrderLine without delete and re-add, and even then, it’s likely to just start with the last OrderLine value used.