Hello Fatima, We did a similar upgrade, TMS 2012 to 2018. The biggest change I remember is LoanObjStatus is no longer in the LoanObjXrefs table (that field is now LoanObjStatus_OLD). There is now a LoanObjStatuses table with a LoanObjStatusID, etc. This is true for AltNumDescriptions too (in 2020, there is an AltNums.Description_OLD field and a new AltNumDescriptions table). Quite a few reports needed to be rewritten due to these changes. If you have reports with the aforementioned fields, they will no longer work with the new, 2020 data structure. * Rob Morgan IT Specialist in Data Management and Systems Administration Office of the Chief Information Officer Smithsonian Institution From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Mahdi, Fatima Sent: Monday, October 5, 2020 2:37 PM To: ListServ tmsusers <[log in to unmask]> Subject: Issues to look for in TMS upgrades? External Email - Exercise Caution Hello folks! We are upgrading from TMS 2012 to TMS 2020. Happy Day! We are getting ready to review the test instance, and I am not sure what I should be looking out for. What issues have other institutions come across as they upgrade? Any other suggestions of things to keep an eye on? Thanks muchly, Fatima -- Fatima Mahdi Collections Information Specialist/TMS Virginia Museum of Fine Arts 200 N. Arthur Ashe Boulevard Richmond, VA 23220-4007 T 804.340.1443 [log in to unmask]<mailto:[log in to unmask]> 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.