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

I am also interested in this type of report.

Thanks,

Jessica

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 MUSEUM^OFART 
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.