Custom field formula to only apply to certain Item types. I have a ITEM custom field which has a calculation based on the {weightunit}. The issue is, when we create 'Non inventory item for purchase' the {weightunit} field is not available, so we get an error. I am trying to set an excluding on the formula to not execute when we save/create the 'non inventory item for purchase' type. this is what have, but it doesn't work, presumably as the record is not saved and therefore doesnt have a type yet...

CASE WHEN {itemtypename} <> 'Non-inventory Item for Purchase' THEN

(Case When {weightunit} = 'lb' then ROUND ({weight}*0.453592) else ({weight}*1) end)

Else ''
end

Any thoughts on how to solve this one? Thanks 😀

Do you need to use the field on Non-inventory, Other Charge and Service items? If not, there is an option in the custom Item field to apply it only to For Sale subtypes.

Ah ha, turns out we dont!! thank you. I inherited the custom field so presumed it was needed on non-inventory.