On the inventory report page, this product shows two records, one record is 20 on hand, and the other record is -20 on hand. The actual inventory quantity of this product is 0. Generally, if the product quantity is 0, it will not be displayed. My question is why is it displayed here and how to eliminate this data record.
Thanks!
It seems you have 20 on hand in warehouse or location and -20 in another warehouse or location so the inventory report will show two records for each WH/Location
They are in the same warehouse/location and the actual on hand is 0.