Questions Reordering / Rearranging Lines on a Sales Order

Acumatica 2017 introduced the ability to reorder / rearrange lines on the Sales Orders (SO301000) screen. Basically, all  you do is grab a line and drag it to where you want it to go.

This is great for the screen itself, but what about the printed version of the Sales Order?

As far as I can tell, the printed Sales Order still prints the lines in their original order. But you can change it.

Note, I almost put this post in the Report Designer forum, but since it's really related to the Sales Orders, I decided to put it here. Warning, going forward is all Report Designer work.

When you add lines to a Sales Order, the line numbers get stored in the SOLine.LineNbr Data Access Class (DAC). It's important that those line numbers don't change because that field is a primary key on the SOLine table.

When you reorder lines on the sales order, the new line numbers get stored in the SOLine.SortOrder DAC.

To get the printed version of the Sales Order to print correctly, open the report in Report Designer and make the following changes:

1. Go to the Sorting area in the Report Properties and click the ... button

2. Click the Add button, put SOLine.SortOrder in the DataField area, then click the OK button

3. Save the report back to the server and run it again. You should now see the Sales Order lines sorted in the same order as they are sorted on the screen.