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.
David Thompson | MFAH
TMS Administrator
The Museum of Fine Arts, Houston
PO Box 6826 | Houston, Texas 77265-6826
5100 Montrose Boulevard | Houston, Texas 77006
713.639.7580 o
281.330.3803 m
[log in to unmask]<mailto:[log in to unmask]>
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Cristina Lichauco
Sent: Monday, September 26, 2016 12:46 PM
To: [log in to unmask]
Subject: Recording Shipping Fees
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<http://www.asianart.org/>
T: 415.581.3676
[log in to unmask]<mailto:[log in to unmask]>
[cid:65CD1E21-825C-4E2B-BF62-CDD64E6E0540]
To unsubscribe, send an email to [log in to unmask]<mailto:[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.
|
