Server Actions - Mass Sort Lines

This module extends the standard Server Actions screen (Settings > Technical > Actions > Server Actions) with a new action type called 'Sort'.

When you create or edit a server action and pick 'Sort' as its type, two extra fields appear: 'Field to Sort', where you choose the one-to-many field whose lines should be reordered (for example the order lines of a sale order), and a 'Sorting Criterias' list. In that list you add one or more lines, each selecting a field of the related model and optionally ticking 'Inverse Order' for descending sorting; you can drag the lines to set the priority of the criteria.

When the action runs on a set of records, it searches all the related lines of each record, orders them using your criteria, and rewrites their sequence numbers starting from 1. This means the lines are physically renumbered in the order you defined.

Business rules and safeguards: the action refuses to run if no sorting criteria are defined, and it also refuses to run outside the contextual 'Action' menu. Only users in the Settings group can create, edit or delete sorting criteria; other users can only read them.

It works on any model that has a one-to-many field with a sequence, so it is not limited to sales: purchase orders, invoices, manufacturing orders and similar documents can be sorted the same way.