1 Reply Latest reply: Aug 24, 2012 8:05 AM by Felim Shanaghy RSS

    help with data model for stocks

    kevin cool

      Hi All,

                I need to create a data model for stock control .The database is from sage 200 .I have a query regarding this.The stock control module has Stock item,Bin Item and Warehouse Item tables and their quantities constantly change.I am creating a data model with dimensions on one side and all events on one side so should I create separate event tables for stockitem,binitem and warehouseitem or integrate all into one event called stocks.Will give you more information if you require.thanks in advance.