Set Field Script with Calulation
I wondering if this is possible, and if it's not maybe there is a work-around.
I'm trying to write a script that if a field has certain data in it to change related fields to 0.
If (invoiceitem = shipping
Set Field Commission; 0
I have 4 fields that i would like to make zero if the item on our invoice is "shipping". My problem is is that those 4 fields are all calculation fields, so i can not modify them with this script step.
Any idea would be amazing!!