Multiple Location Inventory Design

[Scott Walker]

I have an order processing system.  Currently it only handles inventory kept
in one location.  Now a customer wants to start keeping inventory at
multiple locations.  So the same part# could be in the inventory at the main
office and also at several branch offices.  I'm just starting to think of
the design of this.  Should I have a separate record in the inventory file
for each part#/location combination?  Should I use a qualified file for each
of the inventory of each location? (I don't use qualified files for anything
at the moment).   Of course, this design decision permeates itself
throughout the system (ie.  Order Entry, Shipping, Purchasing, etc).  Any
design ideas or thoughts would be appreciated.

 

Regards,

 

Scott

 

Scott Walker

RAM Systems Corp

(704) 896-6549

ScottWalker at RAMSystemCorp.com

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20100325/06824745/attachment.html