Right now I have my inventory in a solution but I found i was making mistakes when I was manually entering the numbers and as inventory came in I had no way of knowing or should I say rememoring what i added into stock on what day.
If your barcode based system just adds and subtracts values, you'll have the same problem and it will be compounded by the fact that with your scanner it's easy to scan an item twice or to point the scanner at the barcode on not notice that it didn't scan at all--particularly if you have a lot of items to scan and are in a hurry.
I suggest you set up a "ledger" system that logs items in and out of inventory just like you would record deposits and withdrawels from a bank account. That way, you can have a record not only of the current quantities on hand, but also of each event that changed those quantities.
The structure of such a table might have these fields:
ItemID (Your barcode or an ID value looked from a related table when the barcode was scanned.)
QtyIn (This can always be 1 or you can have the option of entering a larger quantity)
cBal (calculation field, QtyIn - QtyOut)
sBalance (Summary field, running total of cBal, restart totals when grouped by ItemID)
Set up in a list or table view, and sorted by ItemID and Date, this will give you a "ledger" showing not only quantities on hand, but also what events have changed those quantities. (This can be useful in setting re-order points for your inventory.)
Wow!!! that worked thank you so much.. Now i can keep track of my inventory with no problems thanks