Cannot Separate Stockable from Non-Stockable using Find?
Im using the Find on a Table Layout to filter out Stockable and Non-Stockable products (Item Type) to be exported on a spreadsheet.
The problem i encounter here is that i can't filter out product with Stockables only, i already used =, == , "" operators but it keeps showing the Non-Stockable products
But if i use find Non-Stockable, it shows the Non-Stockable types only.
I also tried the script
Go to Layout ["LINE ITEMS TABLE"]
Enter Find Mode
Set Field [INVOICE::date = Get (CurrentDate) ]
Set Field [PRODUCTS::itemtype = "Stockable"]
Go to Layout [original layout]
How do you find the Stockable only without Non-Stockable?