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