Hello, I need to set a workflow approval level for...
# suiteflow
f
Hello, I need to set a workflow approval level for every time a upfund on just amount and not total ? Why doesn't the approval work for amount change ?
m
Is this a custom workflow or suite approvals?
f
This is a custom workflow. I just want to create an approvals for once the PO has an amount change but not total
m
What’s the difference? Do you mean the amount on the line changes vs overall PO total?
f
Correct the boss, just the amount on the line change for instance if the PO has changed amount 500 set it to approval
m
This will be pretty difficult
But we can try this
Create a custom Tran line field called last PO line amount
f
The isue with sublist action group it only works for items, this could also include expenses I think.
m
Oh yes that is a problem
1
You would need a client or user event script to mark a checkbox on the line if the amount changes Then use a saved search or other condition to transition your workflow based on that checkbox
f
That's what I also though maybe it will need scripting.
m
Is it common that PO line amounts change but the PO total won’t?
Yes to interact with the expenses Sublist a script is the only way
f
well in the workflow we don't want the total to be the approval process because it already went through 1 workflow. It should be the amount change we call it upfund which is an amount change increase or decrease.
m
It's kind of a confusing use case but I understand wanting to track changes at the line level. I really think your only option is to use a script to mark specific line items as "changed" then use that custom checkbox as the criteria for your workflow transitions, especially considering you are using the Expenses sublist which is not avialable to workflows. I don't think it would be a very large customization to implement. If it's just as simple as marking a line as Amount Changed = T then it would be fairly low effort. If you needed to include all sorts of data like Last amount, what it changed to, who changed it, what time it was changed, etc then it gets more complex
f
got it Maven, thanks so much for your input I will be working on that now 🙂