Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312

    Unanswered: Inventory Database

    I have to create an inventory database. I am looking for some design tips. I am trying to figure out how to store the data for transactions. The types of transactions will be:

    Transfer In
    Transfer Out

    Ship
    Receive

    Spoil/Loss
    Throw Out

    I am leaning toward separate tables for Transfers, Shipping, Receiving, and Loss. However, I can definitely see a table with all the transactions in it with different Transaction Types.

    I think both ways are viable, but I can't think of the pros and cons for each. Anyone with some insight they want to share? Other categories I might need? Other possible ways to store the transactions?

  2. #2
    Join Date
    Jul 2004
    Location
    Auckland, NZ
    Posts
    4
    Hi DCKunkle,
    You are right in thinking that a single transaction table is the way to go, however, it would benefit you greatly to have separate temp tables for each of the processes, transfers,shipment, receipts etc...
    Once the process has been completed, the results are transfered to the transaction table.

    There are many different ways to setup an inventory application, if you search this site, you will come across many very helpful posts and links.

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    As is often the case, the horse's mouth is often a good place to start! Microsoft offers two template (read that sample) Inventory Management dbs here:

    http://office.microsoft.com/en-au/te...366681033.aspx

    It's a place to start!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Hi DC
    I have to admit to a "re-invention of the wheel" going on here.
    Surely a bespoke would be more in keeping at this point?
    All the functionality you are pointing to is a basis of a good POS/Warehouse DB.
    Rather than going to the cost and effort of building why not buy in a package tried, tested and with support??

    Gareth

  5. #5
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Too many reasons to mention but the major reason is a package will have too many features for us. We just need a glorified/automated spreadsheet, nothing more. We have part of the system built already. We will need to integrate with the system that determines our usage.

    We are keeping track of direct mail pieces. Envelopes, insert, blank forms, etc. There are only about 50 different items. We only need to track incoming and outgoing quantities. An off-the-shelf inventory package will be overly complicated. No binning, warehousing, etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •