Just further to this: During the upgrade process from TMS 9.35 to 2010, accession values move from the ObjAccession table to the ObjInsurance table. This ensures that all valuations are recorded through a single set of tables. Accession values are identified on the ObjInsurance table by 'SystemValueType' = 4. There should only be one row with SystemValueType' = 4 per object i.e. an object should only have a single accession value. The attached CR sub-report (thanks, Werner!) returns Accession Value and Accession Date, plus the Source field and should be linked to a Container report on Objects.ObjectID (although could be amended to be used with any table that passes Objectid into the parameter). The Select Expert in the sub-report is set up to only select 'accession values' i.e. rows on the ObjInsurance table where SystemValueType = 4. Best wishes Jon From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jessica Wilks Sent: 28 June 2013 15:45 To: [log in to unmask] Subject: Re: Audit report needed for end of Fiscal Year I am also interested in this type of report. Thanks, Jessica Jessica Wilks | TACOMA ART MUSEUM Registrar T: 253.272.4258 x3021 1701 Pacific Avenue, Tacoma, Washington 98402 www.TacomaArtMuseum.org From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Suzanne Stephens Sent: Friday, June 28, 2013 7:44 AM To: [log in to unmask] Subject: Audit report needed for end of Fiscal Year It is the end of our fiscal year, and we just recently upgraded to TMS 2012. Does anyone have a report you can share that is formatted for 2012 that pulls values from the Accession Value field, instead of from Valuation? We do our annual report numbers from Accession Value. I hope there are others out there who do the same. Happy Friday. --Suzanne Suzanne Voce Stephens Database Administrator / Registrar's Office BIRMINGHAM MUSEUMOFART 2000 Rev. Abraham Woods, Jr. Blvd. Birmingham, AL 35203 P: 205.254.2975 F: 205-323-6093 Explore the World. Discover Yourself. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.