i have created transaction column field
name: Inventory Details Print
type: text area
then created saved search, I want all the invoices those have Inventory details blank on line item
Criteria tab,
Type > Invoice
Item > is not none
Transaction Serial/Lot Number > is not empty
Formula (Text) > is empty > {custcolInventorydetails}
also instead of formula tried : Inventory Details Print> is empty
REsult tab
Number
Transaction Serial/Lot Number
Inventory Details Print
But the search result showing the all invoice having Inventory Details Print entered.
In search result showing ‘Inventory Details Print’ column blank but when respective record open, it shows value in ‘Inventory Details Print’ field.
The result I want is those invoice only with empty ‘Inventory Details Print’ field value.
This is a cached copy. Click here to see the original post.