We have to separate the inventory count up into Lot and Part because some of the parts were mislabeled with a bad Lot#. What we want is a way to count parts using either method, depending on whether the Lot # is correct. In a bin, you might see an odd amount of parts loose, and a few bags labeled with the correct Lot#. The handheld can be set to count either by Lot# or by Part# and creates separate records for each.
I then have 3 tables to compare and sort.
Table 1 contains Part#, Lot#, and Qty. Part# is a one to many relation to lot#, ie you can have more than one lot# for a single part#. There are entries which do not have entered qty, ie lot#'s which we are sold out of.
Table 2 contains the inventory from a handheld scanner, created using the Lot#, qty and Date.
Table 3 does the same thing using the Part#, qty and Date.
I want to weed out zero Qty. Lot# entries (easy) and also where the Lot# is counted by Table 2. The idea is to determine which Lot# is being counted by part#.
Also, I will need to see whether the counts for the inventory is correct, so this would look like a reconcile report when it's done.
Thanks in advance.
I then have 3 tables to compare and sort.
Table 1 contains Part#, Lot#, and Qty. Part# is a one to many relation to lot#, ie you can have more than one lot# for a single part#. There are entries which do not have entered qty, ie lot#'s which we are sold out of.
Table 2 contains the inventory from a handheld scanner, created using the Lot#, qty and Date.
Table 3 does the same thing using the Part#, qty and Date.
I want to weed out zero Qty. Lot# entries (easy) and also where the Lot# is counted by Table 2. The idea is to determine which Lot# is being counted by part#.
Also, I will need to see whether the counts for the inventory is correct, so this would look like a reconcile report when it's done.
Thanks in advance.
