The database view of Tables, specifically "Transaction Codes 1", has a sort function. This allows the data in the table and connected drop down menus in other applications such as GL coding in AP to appear in alphabetical order. As an organization we have over 40 active grants and 178 total grants. We use this table to name our grants. When a person does not remember the entry spelling by heart, having the information in alphabetical order is very convenient. Would you like to scroll through 100 drop down menu options not in alphabetical order? Although the database view has this function, the NXT version does not. Before you remove the database view functionality because in NXT is fully functional, please add this function to NXT. NXT might be functional, but it does not offer the same functionality. Or do something behind the scenes so the table sorts automatically.

BB NXT document...

Attachments Open full size