Am I correct to say that this requires scripting? ...
# general
l
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)
m
This could be achieved via workflows but the User Experience might be a little clunky> 1. Create separate workflow (and saved search) that looks for any PO where your criteria is met - Bill Price higher than PO price. Make this a scheduled workflow and have it change the Approval Status to Pending Approval. Run this every 30 min 2. In your existing PO Approval workflow add a transition after record submit from Approval BACK to pending approval if the approval status is Pending Approval. 3. ALSO add another transition on Before Record Load from Approved BACK to pending approval and use your saved search from the above scheduled workflow as the criteria of this transition
This will cover 2 scenarios 1. It will revert PO's back to pending approval on a scheduled basis 2. AND it will revert the PO back to pending approval in "realtime" if someone tries to view/edit the PO in the UI