anyone know how to do a condition on item type for...
# advancedpdf
m
anyone know how to do a condition on item type for lines on a PO? specifically trying to show a tag only when the line item is lot-numbered. but line.item.islotitem seems to return true for all items, and line.item.recordtype isn't specific enough
d
Depending on your account setup (whether you have bins), you could infer it from the inventory detail. The easiest option however would be to populate a custom column field with
islotitem
Field default formula I've used before is:
DECODE({islotitem}||{isserialitem},'TF','Lot Numbererd','FT','Serial Numbered','Standard Inventory')
b
and I suppose if both could be an option you would just add another condition
'TT', 'Lot Numbered and Serialized'
or something like that.
m
appreciate the help, ill try this
d
I wrote that from memory, as it's a transaction field I think it needs to be
item.islotitem
and
item.isserialitem
m
yeah i figured. unfortunately those don't seem exposed to the transaction line. even with something as simple as setting a transaction line field to
{item.islotitem}
returns an error
as a backup i was thinking of adding a "is lot numbered" checkbox to the line with a stored value and just set it via script or workflow whenever the item is changed
d
Yeah, I went back and checked and see that I was actually populating via script too. That formula was a from a saved search... 😔
m
gotcha, backup it is! thanks anyway