Requirement:
I converted a “location” LIST to a custom record so I could add a “category” field to help define the location (only for reporting purposes). The “location” field is alphanumeric. As a LIST, the dropdown could be sorted by order entered. How can I accomplish this as a custom record dropdown? Here are simplified examples…
List Example:
Box 1
Box 2
Box 3
Record Example:
Box 1
Box 10
Box 11
Box 2
Box 20
Solution:
As per checking by default, the system lists the custom record values based on the internal id.
If you want to sort them specifically, this is currently a system limitation and an enhancement under:
Enhancement 163273: Custom List/Record > Custom field > List > to have the ability to sort and order of the list by hierarchy
You can vote for this enhancement on the SuiteIdeas page.
At this time, there is no documented workaround.