I have 3 fields (inv line item:quantity) , (inv line item:shipped) and (inv line item:bkorder) . I want to subtract shipped from quanity to get backorder.
(inv line bkorder = inv line quantity - inv line shipped)
I then want to evaluate if inv line bkorder is less than 0, then set inv line bkorder to zero. I am able to ship more within a certain percentage.
Can this be done in single calcuation field? How would the code look? I would appreciated any input. Thx.