How to Sort a UD Field Drop-Down List A-Z?

Epicor ERP 10
,
1

We have a UDField for “Color”. Over the past 5+ years we’ve added many color UDCodes to this list. The drop down list is no longer displayed alphabetically (or numerical in other UDFields cases). How can we “re-sort” the UDFields so the drop down list displays A-Z or 1-9?

Edit: UDField drop down list is in the order of the CodeID. Can Epicor sort the drop down list based on the “Full Description” or “Description”?

2022-05-25 14_32_26-User Defined Codes Maintenance
2022-05-25 14_32_26-User Defined Codes Maintenance895×587 89 KB

2

In the EpiCombo object there is a property called “EpiSort”. Type the column name you wish to sort by, for example, “CodeDesc” to match the display text or “CodeID” for the actual value.

Personally, I solely use the “LongDesc” field in User Codes for holding a hidden sort value if I can’t sort by the CodeDesc.

image

3 Likes
3

Is that in the “Personalization” screen? I see EpiCombo but not able to do anything.

2022-05-25 14_40_01-Part Maintenance - BARK_10.2.700.3_PE_1.0.7
2022-05-25 14_40_01-Part Maintenance - BARK_10.2.700.3_PE_1.0.71563×1191 295 KB

4

It looks like you’re using a BAQCombo box instead of a EpiCombo. In which case, I guess you could go into whatever BAQ the powers the box and set the sort order there?

5

Thanks! They were BAQ’s, just had to add a Sort Order!

Thanks for your quick responses, co-workers are already happy about this find!