How to put Invoice on hold if there are prepayments available for a Supplier/Supplier Site?

Summary:

Need to put a invoice on hold if prepayments exists for that supplier

Content (please ensure you mask any confidential information):

I understand that Oracle has bell notification at the point of Invoice creation if that supplier has a prepayment already created but this is not enough. If a supplier has a $1 million dollar prepayment, we need a way for a hold or some sort of hard/soft stop to be put on that invoice so they do not pay any additional money to the supplier as they have already pre-paid them $1 million dollars. We need a way so that there can be an automatic hold placed if there is already a prepayment against that supplier for any open amount.