designing a stock control system

• francissvk

  SSChasing Mays

  Points: 620

  More actions

  July 1, 2011 at 11:16 pm

  #243752

  Hi,

  I am designing a stock control system. Does anyone have a sample database schema I could get some ideas from?

  The parts I am not sure how to model are:

  - Tracking stock-in and stock-outs

  - One table for tracking stock currently on hand?

  Thanks for the help

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 3, 2011 at 4:01 pm

  #1347572

  It would be a combination of the entities and the logic to track the quantity on Hand, etc.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• jasonmorris

  SSCrazy

  Points: 2492

  More actions

  July 4, 2011 at 10:33 am

  #1347972

  Have a quick google for FIFO (first in first out) and LIFO (last in first out) which are the 2 main options for stock control.