Am I correct to say that this requires scripting?
Whenever a bill is created with unit price higher than the related PO unit price (achieved via a saved search condition), the vendor bill goes through approval process. Achievable via workflow. BUT, it should also change the status of the related PO back to pending approval (I know that may be an odd business process). So, I suppose we can create a transition from approved state to pending approval state in PO approval workflow. Is this is a scheduled transition every 1 hour with a saved search condition of POs linked to pending approval Bills?
If I don't want it to be scheduled, is my next option scripting it so it would be in real time?
Also, once the PO is approved, the related vendor bill is approved as well. Again, if real time, this would require a UE script to transition the vendor bill to the approved state?
If scheduled, so a scheduled transition with saved search condition of related PO in approved status (context is what? Considering that I don't want this to go straight to approved upon bill creation where the PO is still approved at the time)