I have a custom workflow for procurement approvals; our company is small so staff wear many hats which can make approvals complex to standardize. (And to think I used to carry all this in my head and made it work.)
In our current workflow, some approvers must approve the same procurement transaction 3 times. Example: our CFO may approve 1st as an Employee Supervisor, 2nd as a Class manager, 3rd as the CFO due to the dollar value.
Screenshot of approval section - highlighted levels are all the same user
Our Purchase Order transaction carries a check box and name of the approver assigned as pulled from the system. When the appropriate user approves (Next Approver), the workflow marks the check box beside the name.
I need a workflow condition to evaluate the name of the approver at level 1 and if it is the same as the name of the approver at level 2, mark the checkboxes for both level 1 & 2. The evaluation would happen after approval at level 1.
In simple language:
If checkbox Approved by Supervisor is marked; compare the field 's name' to the field '1 name' if equal mark checkbox Approved by 1st Approver.
I have tried a couple of custom formulas I found on the web but with no results. Last one was a nlapiGetFieldValue formula.
Or would it be easier to create a Saved Search condition?
Or is there a better way I have not found yet?
We only have a year in NetSuite so I have never done either.
Any advice or examples are welcomed!