I guess creating a custom report is one way to solve the problem, but it would be good if a report bundled with TMS, that's designed to show current location, actually did that. It wouldn't be a big change for GS, whereas not all institutions have the resources, in-house, to do this. The glitch may be caused by your use of TMS. If you're recording a retrospective move, use the 'Historical' transaction type - TMS disregards these when calculating the current location of objects - the report should be designed in a similar way. Not sure from your posting whether you're doing this. Regards Jon Thristan Tate Systems Manager call +44 (0) 20 7887 8983 email [log in to unmask] -----Original Message----- From: Danielle Uchitelle [mailto:[log in to unmask]] Sent: 03 October 2002 20:52 To: [log in to unmask] Subject: Re: Accurate location Reports Margie, Simplest solution is to create a custom report that shows the location corresponding to the most recent move date for each object. --Danielle Uchitelle Solomon R. Guggenheim Museum -----Original Message----- From: "Gill, Margie" <[log in to unmask]> Sent: Thursday, October 03, 2002 3:34 PM To: [log in to unmask]; [log in to unmask] Subject: Accurate location Reports I am re-visiting a problem which was discovered during the implementation/testing phase of TMS, and we have found recently that the problem still exists. That is, when running a location report, the systems pulls from the most recent date the location MOVE was recorded, not the date of the MOVE. A location change was recorded 4/10/2002 for a MOVE which took place on Dec. 5, 2001 (the object's current location) Another slip was recorded two days later on 4/12/2002 for a previous MOVE on Nov. 8, 2001. Therefore, the system draws from the 4/12/2002 date as the most recent MOVE & current location, which is inaccurate. Jeri was going to look into this problem so please check with her. I am sending this out to TMS UsersListServ to see if anyone else is having this problem & might have a solution. Thanks, Margie Gill Registrar of Collections The Colonial Williamsburg Foundation P. O. Box 1776 Williamsburg, Virginia 23187 757-220-7519 Fax: 757-565-8752 email: [log in to unmask]