To create an arrivals list that has transfer details but no 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 “Not Equal To” “Active” or “Is NULL”.

This will produce a report on students who have not booked accommodation or has cancelled accommodation, within the date selected.

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