3 Replies Latest reply on Aug 18, 2015 6:03 PM by starstuff

    Cannot Separate Stockable from Non-Stockable using Find?

    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!