Issue
The user cannot add or insert a line between the Sales Order line items if they are not sorted by sequence #.
Solution
If the user wants to add a row between some sequence numbers, the Sales Order items must be in sequence # order. The sequence # of all records below the insert point will be raised by 1, by Spire.
Reason
The Sales Order Items list was designed this way because it frequently contains a tree of items. For example, Job Header groups and kits with their component parts. By using the sequence #, these items must remain together. Additionally, there are instances where comments must be placed precisely in the line that follows since they might be related to the line above.