relating two count units for same item

[djeans]

Hello,

I have an inventory database that I have created for counting stock of items using a barcode scanner. The basic function is to scan an item, the database matches the barcode against a master catalog, returns the name of that item, and I enter a count that I then tally up on a report.

It all works fine, except for one thing. Some items will be counted in different units with different barcodes, although they are the same product. I'm trying to figure out a way to relate them so that when I run my tally report, they are summed together as a total count.

For example, if widget A comes 24 to a case, and I count 2 cases (by scanning the case barcode then entering 2) and I count 10 more of widget A (by scanning the individual barcode and entering 10) when I run my stock tally report, I would like for it to show that I have 58 of widget A on hand. Currently the report shows 2 cases of Widget A and 10 individual widget A, which is not optimal.

Any suggestions?

Thanks

Darron

[LaRetta]

Your product table should have field indicating how many per case. You can then create a calculation (or what I've always done) is set a number field with the conversion. If user selects 2 Cases, calculation evaluates as: 24 * 2 = 48 in the qty field (or actually Products::QtyPerCase * LineItems::NumCases = total units.

Although cases are available for User selection, I never store it as such in the quantity field but rather have auto-enter (replace) re-evaluate. Then I can count cases if need be by the reverse (using a standard calculation). Order contains 2 cases + 12 (so shipping can pull the cases easier).

[djeans]

Thanks for the reply.

I think I follow you, except that I'm still unsure of how to tally them together. I have the report set right now to group by barcode number, and since case and individual counts have separate barcode numbers, they show up separately on the report. Perhaps I should assign a different key field for the report, with the same key assigned to those items and sum the calculated count. I'll give that a shot.