This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

We're looking to include criteria in a workflow to send a Purchase Order back to Pending Approval status if the amount changes by more than $2000.... a dev we previously utilized had criteria similar to this screenshot. Is old.total a valid piece of data? How have other tackled sending a PO back to Pending Approval is the amount changes?

I think that is referencing the “old record” record in the visual builder but never used it in the formula builder so not sure

Usually I make a custom field on the PO called “last approved amount”. When the PO reaches the approved state I store the total in this last approved amount field
Then you can use that to compare to the current total and make easier calculations and conditions off that field

Thanks for the feedback, that sounds very manageable.

Yeah, I've done something similar to what MavenCloud said.  Though I feel like my solution was probably a lot more (unnecessarily) complex lol.

Though, to be fair, my team wanted to have a tolerance built in ie some changes are ok, while other aren't.  Also taking into account tax line items vs non-tax line items.  Anyway, it works but the construction even confuses me often, and I built it.