HELP! Verifying the existence of an item in a storage before taking it out

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a database for an existing stock in a warehouse. I made a table with
the entries in the storage, and a query with the total of materials which
are in the repository at a moment, for each name of the material, quality
dimension, measurement unit and price.
Now, I want to take some materials out of the storage. I want to a table
for them, but HOW CAN I VERIFY WHEN I ADD A MATERIAL IN THAT TABLE IF THIS
MATERIAL IS (EXISTS) IN THE STORAGE (if I have entries for it) and to GET AN
ERROR MESSAGE IF I DON'T HAVE IT IN THE STORAGE?

I would apreciate any help.
Thank you!
 
Chris, this is a big question.

To get an answer, you will need to think through the data structure and the
processes you will have to set in place to:
- order materials;
- receive materials into stock from your purchase orders;
- remove materials from stock (either through customer orders, or possibly
to a shop floor);
- calculate the difference between quantity received and quantity removed,
to get the current stock quantity;
- allow for stocktakes to correct the stock levels periodically, and use
this as the base quantity for your calculations.

For an introduction to these issues, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html
 
Back
Top