Prevent user from changing employee status to Inactive if employee has open document

HI All,

Do you know how to prevent user from changing Employee Status to Inactive if Employee still has an Prepayment does not Closed?

Employee has been using as a Vendor ID so when recording advance for Employee, we use Employee ID too. When Employee left the company, HR will change the status to Inactive and current the system has no warning that Employee still own company an advance or not. And then when Payable want to apply that Prepayment, they have to change status of that Employee again.

This flow annoys us a lot and seem does not make sense to me. The system may have some setting to prevent user from changing Employee Status to Inactive if Employee still has a Prepayment does not Closed?

Appreciated to your advice,

Thank you so much,

Yên Chi