Re order Sales Order Lines/Quote Lines

Hello,

I found one post from Acumatica with instructions “How to Set a Default order for a Column on the Document Form”.  Irina from Acumatica Support provides step-by-step instructions.

https://community.acumatica.com/configuration-225/how-to-set-a-default-sort-order-for-a-column-on-the-document-form-or-generic-inquiry-3924

I’m not sure if you have access to the above post. In case you cannot see it, here is the info.

“Suppose that you need to save the ascending order of the Inventory ID column on the Document Details tab of the Sales Order (SO301000) form.

Step 1: Open a sales order that shows multiple line items on the Document Details tab.

Step 2: Click on the column header of the Inventory ID column. In the menu which opens, click Sort Ascending and then Click OK button.  The items are now sorted in the order preferred by the user.

Step 3: Click the leftmost icon among the column headers to bring up the Column Configuration dialog box which is shown in the following screenshot. Click OK button.

Results: Open any sales order. Detail lines are sorted ascending by the Inventory ID column by default. “

I found two previous posts that explain how to control sorting on the printed quote/sales order. Answered by suemackeown13 :

This previous post discusses sorting on Purchase Orders but has a downloadable example attached that may help. It’s also discussing sort on a Printed PO (not the screen). Answered by aborisova37 :

Good luck!

Laura

Hi afraid not without customisation I presume there are too many lines for the user to drag and drop them in the order they want

Hello,

I did a quick test of Irina’s steps in 2023 R1, using a Sales Order with 11 un-ordered lines. It works!

When I page to the next, and next Sales Order, the lines are suddenly In Alpha order by Inventory ID in every Sales Order!

Anyone in Administrator Role may share the same column configuration out to all users:

Laura

Realised drag and drop wasn’t working as the record wasn’t on Hold!