AnsweredAssumed Answered

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

Question asked by pedroble on Jan 27, 2017
Latest reply on Jan 30, 2017 by JackRodges

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

Outcomes