AnsweredAssumed Answered

Cannot Separate Stockable from Non-Stockable using Find?

Question asked by starstuff on Aug 18, 2015
Latest reply on Aug 18, 2015 by starstuff

Title

Cannot Separate Stockable from Non-Stockable using Find?

Post

Hi All!

 

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"]

Perform Find[]

Export Records["today_stockables.xlsx"]

Go to Layout [original layout]

 

How do you find the Stockable only without Non-Stockable?

 

Thank You!

Outcomes