Does anyone know how to make a workflow that when ...
# suiteflow
j
Does anyone know how to make a workflow that when it contains a certain word in the line item automatically approves? We have abacus which is pushing expenses as JEs to Netsuite but dont want to approve the JEs as we already approved it in abacus
p
Unfortunately Workflows can't handle line items on transaction so if your only way to tell if they're from Abacus is on line level then you would require scripting. However if you could tell by (for example) who created it (a system user perhaps) or by some field in the header you could create a workflow based on that which automatically approves the expenses.
👍 1
however think about safety, don't auto approve everything with "Abacus" in the header memo field, instead use something locked down 🙂
j
thanks @Petter thats helpful. So it's my account that runs the script but its through a certain role (abacus integration which I have the ID for) is there a field for a certain role I'd be able to push it through?
p
Yeah that would work
I would create a before submit workflow on create with a condition that "user role" = "abacus integration" and there approve it
note that it's not user.role but a field called user role
j
thanks @Petter you've been extremely helpful!!
p
no problem, good luck!