Hi everyone, I'm running the standard Inventory Valuation report on a 2016 database, and I'm seeing a LOT of items popping up that say there are 0 on hand (for that location), but still has an inventory value. Most of these are between -$1.00 and $1.00, so it's not a huge problem financially, but there are many times more of these than there are items with actual "On Hand" quantities, and I'm worried that it's affecting the performance of the report.
If it's something I could clean up (or maybe limit totals to "On Hand" > 0 somehow?), then I think it could make a big difference.
Has anyone else seen this?
"OMG ALL MY DATA IS GONE"