Environment: Project Server 2010/2013
Background: Customer has a large list of account code in the look-up table – some are current and some every old. Users were complaining that they needed to scan a long list of expired values before finding valid options.
As there is no out of the box option available to archive the values of the lookup table, we suggest you create one level hierarchy with the name ‘Do not Use’ and indent the Account code values which is very old.
This results in retaining the old account code values for existing projects and means users don’t need to scan these old when looking to select a current value.
Let us know if you know any other better solution.
Hope this helps you.