Does any body help me how to create Item table structure for POS system
and how to update SKU suppose i have these three record for sale-able items
item_no | Item Desc | Price | UOM | item_per_pk | Ref_no
001 Match box Pack Jumbo | 100 | PK | 10 | null
002 Match Box Pack Big | 70 | PK | 20 | 001
003 Match Box Unit | 10 | Unit | 1 | 002
What i want.
how to manage inventory these type of items and how to update as i can sale loose item from jumbo and same for big pack