Find Active Records of Students that have Left School

When you import student details from the school database, students that have left the school will not be imported. Sometimes, however, they haven't notified YOU that they've left the school, so you still have active Tuition, Ensemble or Hire records for them!

These scripts are found at Common Tasks > General tidy-up, where you will see one for Ensembles, one for Loans & Hire, and one for Tuition.

The scripts will find any records in those files that do not have a related record in the Students file (the scripts use the Year Level field to search) and display them in a list for you to check. You can then enter a termination/finish/return date in the records that need to be archived.

To quickly enter the same date for the whole found set, you can use the Replace command. Enter a date in one of the records, then leave your cursor in that field and select Records from the menu at the very top of your screen, then Replace Field Contents.