Automatically hold AP invoice from payment selection if a prepayment invoice exists for the supplier
In Oracle EBS, I need to automatically hold an invoice from payment selection if a prepayment invoice exists for the supplier.
We are using the PPR schedule process, but the program should exclude an invoice if a prepayment is pending application for that supplier.
Is there a way to automate a hold based on these conditions?