Inventory database

M

mdk

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??
 
S

Sharkbyte

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
 
H

Haris Rashid

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top