Archive a Look-up table old values

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.

Solution:

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.

 

 

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: