Joining the inventory detail to an item search results in multiple lines and summarizing those lines does not equal the actual quantity on hand. I was hoping someone else has run into the same thing and was able to solve it.