Results 1 to 4 of 4
  1. #1
    grantdredelic is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2016
    Posts
    2

    Order/Stock Control Database System


    So I'm wanting to create a very basic control system where I can order items from my products list. But I don't know how to do this.

    How can I make an order where it removes the number of in-stock items and puts it into 'on-order'? I can't seem to figure a way to do this?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    grantdredelic is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2016
    Posts
    2
    Quote Originally Posted by orange View Post
    You may get some ideas from this free video.
    Thanks for the video, but it doesn't tell me how to reduce a quantity of an item, say 8, and order 3 of those items and remove it so it makes it 5. I can't find anything on how to do this.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    There is much more to database and stock control than
    ...reduce a quantity of an item, say 8, and order 3 of those items....
    Do you have a complete description of the business and associated rules? That's your starting point.
    I notice you have 2 posts on this forum, could you please tell us more about yourself and your background, so more focused and appropriate responses could be made.

    Reorder point/level, backorder, substitution may all apply, but we don't know the details of you or your "business".

    Usually, people deal with transactions, where, for each product/StockItem

    Code:
    CurrentStock = LatestStockTakingAmount +StockAcquired - StockSold
    and

    StockAcquired are positive transactions and StockSold are negative transactions. This allows you to do arithmetic on the transactions for a stockItem and determine current levels.

    You may get additional info from Allen Browne's article.

    Good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 10-10-2015, 05:09 PM
  2. Replies: 1
    Last Post: 12-07-2014, 12:33 PM
  3. Replies: 4
    Last Post: 11-21-2013, 12:25 PM
  4. Stock Control/ Customer/ Sale database
    By Halwa in forum Access
    Replies: 1
    Last Post: 06-06-2012, 02:49 PM
  5. creating a stock control database!!! HELP!!!!
    By Legend9 in forum Database Design
    Replies: 1
    Last Post: 09-10-2009, 02:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums