inventory

[Guest]

Is it possible to set up inventory, then create orders that will pull the
data out of the inventory. I would like to be able to create reports that
will give me a current inventory after orders are processed while also
allowing me to create reports on sales. Thank you for any input.
K

 

[Guest]

hi,
yes it is possible, that is what access id for.

 

[Guest]

You need to be very careful setting something like this up as if you are not
familiar with the processes, both business and Access, it can get real messy,
fast.

Sales and inventory represent two different things. To track and manage
sales, you are looking at a couple of one to many relationships with
customers having orders and then orders having products (or parts or
whatever).

The connection between what they order and what you ship is typically at the
part level which is how you relate to inventory. If you need to track orders
and be able to report on orders taken, filled, back orders, etc. Put a field
on the part level of the order to indicate that status.

You are better off setting up tables for sales as described above and not
trying to report on sales based on inventory.

Hope that helps.