11 Replies Latest reply on Jan 30, 2017 10:27 AM by JackRodges

    In an inventory list, how can I remove unnecessary items?

    pedroble

      I have an inventory where some of the products are the same but made by different companies.

      I wish to be able to remove all those same products (*) where the stock = 0 but only if there is one (or more) in stock

       

      ProdID     Company     Product     Stock

      0503            CCCC       KKKK1            3

      0109             TTTT       LLLL 1            0

      0337            UUUU       LLLL 2            6

      0313             PPPP       LLLL 3            0 *

      0298             SSSS       LLLL 3            0 *

      0465            HHHH       LLLL 3            0 *

      0510            UUUU       LLLL 3        109

      0397             TTTT       MMM1          25