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]