Sort Report Based on the Order of the Custom List when a Custom Entity Field is set as the Sorting Criteria

When a  custom entity field of ordered custom list/record type is set as the sorting criteria, the report is sorted alphabetically rather than the order of the custom list.

Steps to Reproduce:
1. Navigate to Customization > Lists, Records, & Fields > Lists
Note:  The list, "Progress", is ordered and contains the values in the following order: Beginners, Intermediate, Advanced
2. Navigate to Customization > Lists, Records, & Fields > Entity Fields
Note: Customer Progress is of type List/Record: Progress
3. Applies to customer = True
4. Navigate to Lists > Relationships > Customers
5. Edit 2 customer records with existing sales transactions > assign a Progress of A to one customer and C to another.
6. Navigate to Reports > Sales > Sales by Customer Summary > Customize
7. Add Customer Progress field to Columns
8. Add Customer Progress field as the only criteria under Sorting subtab, Descending = False
9. Run report

Note: Actual Result shows that the customers are sorted by Customer Progress in alphabetical order (Advanced, Beginners and Intermediate ) rather than from Beginners, Intermediate, Advanced which is the order of the lists.

To correct this in NetSuite, perform the following steps:

1. Add a letter or number prefix to the values of the ordered custom list so that reports are sorted using the prefix.
Example:
Stage 1: Beginners
Stage 2: Intermediate
Stage 3: Advanced

Note: This is the suggested workaround for Enhancement 101452. The solution provided is just a temporary fix and does not replace the supposed behavior of the system. Affected users are encouraged to call NetSuite Support should they encounter the same problem or if the temporary fix does not work for them.