Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: jasy lavado
  Where is jasy lavado?
 manila
 Philippines
 jasy lavado
 To: BZ Dusk
  
 
 
 BZ Dusk
 Tags
Subject: RE: Help, Database design - grocery inventory s...
Thread ID: 23948 Message ID: 34420 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Projects and Design
Date: Saturday, December 13, 2003 2:17:24 PM         
   


> Hello everyone!
>
> I need ideas on how to design my database for a grocery inventory system. Here are the requirements: (for wholesale, and stock pull out from warehouse to main grocery)
>
> 1. Multiple warehouse - since they have 2 warehouses
> 2. How to keep track the inventory of an item in multiple unit of measurement - they have pcs, cases, box
> 3. Supplier's promo - sometimes a supplier delivers say one case of item A with 1 pc free.
> 4. How to deal with selling prices of item A in pcs,cases,box
> 5. Selling price mark up
> 6. Selling price increase
>
> I badly need help on this. Thanks in advance and more power.



j. lavado

ENTIRE THREAD

Help, Database design - grocery inventory system Posted by BZ Dusk @ 5/24/2003 5:45:19 AM
RE: Help, Database design - grocery inventory s... Posted by Rene Relucio @ 5/24/2003 6:21:37 AM
Warehousing, Retail Interact (RI) Style, AS400 Posted by Rene Relucio @ 5/24/2003 6:44:30 AM
RE: Warehousing, Retail Interact (RI) Style, AS400 Posted by Rene Relucio @ 5/24/2003 7:15:03 AM
RE: Warehousing, Retail Interact (RI) Style, AS400 Posted by Rene Relucio @ 5/24/2003 7:25:30 AM
RE: Warehousing, Retail Interact (RI) Style, AS400 Posted by BZ Dusk @ 5/24/2003 7:29:09 AM
RE: Help, Database design - grocery inventory s... Posted by jasy lavado @ 12/13/2003 2:17:24 PM