To create an arrivals list that has transfer details and accommodation requirements, you would need to create a Transfer quick report.

Adding in the transfer criteria, and also adding “Accommodation Finance Status Name” and setting the criteria to “Active” along with the fields for “Booking Accommodation Forename” and “Booking Accommodation Surname”.

This will produce a report on students who require transfer and have an accommodation booked.

There is a helpsheet (no. SQL138) which covers this.  Please click on the following link to view or download helpsheet – SQL138.net Transfer Report + Accom.doc