Inventory database

[Guest]

I am setting up an Inventory database where I want to post and track invoices
that come from a company with multiple products. I will also need to do
weekly inventories that will keep track of begining inventory, purchases and
ending inventory then caculate those usages based on sales. I have a table
with all products involved and also a categories table to split the products.
Any ideas on how to proceed from here??

 

[Guest]

mdk

You will need a stock table, which reflects quantity on-hand, and possibly
Unit of Measure, and whatever else. You will need a table for sales, for
purchases, and a function that when sales are added your on-hand quantity is
reduced, and increased with purchases.

Make sure you record the purchase and sales dates, so you can rebuild to
quantities for a given day, in the past.

Good luck.

Sharkbyte

 

[Guest]

hi,

MS Access is shipped with some database applications as templates and
inventory control is one of them. You should be able to access the complete
inventory database as FILE>NEW>DATABASES adn Select Inventroy Control. The
wizard will guide you through the tables.

Kind regards,