Hello! I am trying to filter transactions to only show the transactions that made a "quantity change" in the system. My query has the following columns - Item Number, TransQuantity, PrevQuantity, NewQuantity, Warehouse. If the line has the same value in both PrevQuantity, and NewQuantity - I do not want those to show as those were internal moves that did not actually change the quantity with movement in or out of the warehouse.
How can I create a new query that does not show the line items with the matching quantities in the same line. Thank you very much for your help!