We have a custom PO approval workflow and currently at the last step of Approved state, the record is locked for everyone but a NetSuite admin.
Now, this has been raised as a major road-block from our product team because they frequently change the quantity or pricing of the items in the PO based on the feedback from the vendor they are working with.
So, if they change a quantity or the pricing then it ends up changing the total of the PO.
Now, our executives want to open up the edit option for users at the Approved state - but they need the approval workflow to start again ONLY if there was a change to the Total of the PO by plus or minus 10% of the original PO total. For e.g. if original Total was $100 and the new Total on the PO after PO was Approved is $111 or $89 then the executive needs to know about this and the approval workflow should start again. But if the new Total after the change is like $104 or $94 - less than 10% change of original Total - then the executive team don't care about this change so it should not trigger the approval workflow again.
I checked with NetSuite support who told me that we cannot have this type of custom condition to trigger the PO approval workflow again.
But we can have a condition on the transition from Approved state back to the Initiation state - that will compare the current total to the old record total and triggers the workflow if they don't match. (Total != Old Record : Total)
This means that even if there is a very minor change in the total after the PO is approved then it will go again in the approval workflow.
It will be adding more time to the lifecycle of the PO approval.
Does anyone know if there is any way to achieve the triggering of our workflow ONLY if there was a plus or minus 10% change in the original Total of the PO at the Approved state.