[AccessD] Inventory Database

In the spirit of promoting a good discussion, let me ask:

How do you carry your on-hand, on-order &c. counts?
Suppose customer X wants 20 of item Y and there are only 10 in stock with 30
on order, due to arrive next week. How do you handle that? Split it into two
line items each with a delivery date? Split the order into two? Neither?
Have you dealt with situations in which X vendors supply the same item? If
so, given insufficient inventory how do you decide which vendor to order
from? What if their prices are different?
Do you make any attempt to factor in the cost of shelf-life (i.e. on-hand
inventory unsold for say 30 days)?

Arthur


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: July 6, 2003 7:53 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Inventory Database


Bill:

I've done a lot of inventory systems, but mostly in manufacturing vs.
warehouse/distribution.  Be glad to answer any particular questions you have
on or off line.