Hi Christina,

 

We’re about to start using a combination of loan-level flex fields (for courier, insurance, and other fees), and shipment-step text entries to track detailed shipping fees.  We’re able to get much more specific about shipping fees using the text entries, although they have to be entered in a very specific way for them to work correctly. We are currently on TMS 2014, about to upgrade to 2016 next month, so we haven’t implemented it yet since flex fields are so much easier to query in 2016, plus we have a bit of tweaking to do in the Courier section. Attached is a draft report for a test record to show you more-or-less what the output will look like. My master plan is to be able to roll this information up to the exhibition level so you can see the costs from a high level, and drill-down on specific loans and shipments. Please feel free to contact me directly if you’d like more specific information.

 

 

 

Good morning TMSers:

 

We’ve been recording more loan-related fees in TMS lately and a question has come up as to the best place to record shipping fees.

 

The Loan Object xRefs screen has fields for Loan Fee, Conservation Fee (Catalogue now in TMS 2016 but we have relabeled it), Crate Fee, Insurance Fee, and Other Fee. Our registrars have asked to add shipping costs here, which doesn’t seem possible without repurposing one of the existing fields, such as the Other fee field..

 

I’m wondering where else we could record shipping costs, either on a loan record or loan object record level. What are other institutions doing?

 

Thanks!

 

Cristina Lichauco

Collections Database Adminstrator

Asian Art Museum
Chong-Moon Lee Center for Asian Art & Culture

200 Larkin Street

San Francisco, CA 94102

www.asianart.org

T: 415.581.3676

[log in to unmask]

 

 

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.