[AccessD] Inventory Database

Here is a short article by Allen Browne
on Access Inventory Control Quantity on Hand
http://users.bigpond.net.au/abrowne1/AppInventory.html


Sad Der wrote:

>Hi,
>
>last 2 years i've been busy using Oracle Applications
>for Xerox...can't get any more inventory-like I guess.
>
>What it comes down to is business rules. How does
>you're boss (read: the customer) wants it?
>
>--- Arthur Fuller <artful at rogers.com> wrote:
>  
>
>>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?
>>    
>>
>
>You could also do a combination! Depends on the
>customer, customer location and order amount. eg is it
>my most important customer, to what location
>(country/province) do we have to ship, etc.?
>
>  
>
>>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
>>
>>    
>>
>I suggest looking through some oracle documentation
>(scan the documents so you know the basics!) You could
>look at cramsession.com and search for Oracle and for
>Order Fullfillment. This explains how Oracle handles
>Order fullfillment.
>
>Hope this helps.
>  
>
>>-----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.
>>
>>
>>_______________________________________________
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>    
>>
>
>
>__________________________________
>Do you Yahoo!?
>SBC Yahoo! DSL - Now only $29.95 per month!
>http://sbc.yahoo.com
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>