Meeting with Bryan. We spent the whole time looking at sub inventory data on data 8 for a single corporation. We are trying to look under the covers and see if we can see why two reports are giving different numbers. We ran query after query checking the data. We thought that it was dealing with our inner joins and left joins. We discovered some stuff dealing with how the relationships are made. Some of them are just plain one-to-one. Some are one-to-many, and some don't even exist. That makes it a little bit tougher to follow and get consistent info.

The crux of the problem seems to be dealing with the relationship between po/invoice lines items and sub inventory packages or sub ids. Anyways, we documented a bunch of the queries that we were running to keep track of our findings. Brandon has those queries on his local computer in a file.