Inventory Stock Design

[saraa]

hi..may i know how the right design for inventory stock if there are transaction between branches.What i have think that every branch must have MasterStock for every item.I need to count every single item for every branch and also need to total every single item for all branches?I dont know how to design the table.

Example:

Branch A -------->Branch B--------> Branch C and so on.
Stock IN Stock Out

Please someone who have done this similar program before.I really need your help.Thanks

[kows]

uhh.. are you talking about designing a MySQL table to do what you want? or designing an HTML table to do that?

give some more information if you could.

[saraa]

uhh.. are you talking about designing a MySQL table to do what you want? or designing an HTML table to do that?

give some more information if you could.

Thanks..i mean Mysql table. I dont know how to do it...can u give me an idea..Thanks

[kows]

well, from what you told me i only understand that you need a table that references branches and inventory items.. i don't know what you mean by everything must have a "masterstock." but from your example, you need stock in and stock out? i don't understand. are they the amount of stock in and out? is it a boolean (either incoming or outgoing)? if you're asking for someone to design a table for you, you need to explain your ideas clearly.

soo.. taking a blind stab in the dark: assuming you want branch name, inventory name, stock in/out, and the date, you will need four fields, branch and inventory, both of them being either varchars or texts, date being an integer with a max length of 11 (length of unix timestamp), and stockmode as an enum with the values incoming or outgoing. i made the table for you:

CREATE TABLE `stock_inventory` (
`branch` TEXT NOT NULL ,
`inventory` TEXT NOT NULL ,
`mode` ENUM( 'incoming', 'outgoing' ) NOT NULL ,
`date` INT( 11 ) NOT NULL
) ENGINE = MYISAM ;

[saraa]

Thanks a lot..i try it now.