Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anil Tayal
  Where is Anil Tayal?
 Delhi
 India
 Anil Tayal
 To: Khozema Adenwala
  Where is Khozema Adenwala?
 sanaa
 Yemen
 Khozema Adenwala
 Tags
Subject: RE: Want to work on a VFP Project for free
Thread ID: 50304 Message ID: 52117 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Jobs
Date: Wednesday, September 22, 2004 6:15:27 AM         
   


> I have an inventory of chemicals , say. Now these chemicals come in bulk lets say a container/barrel
>
> When the actual sales start , this is split into smaller quantities, say 100l,50l,25l and so on upto 50ml.
> Do you have any idea as how to take that into inventory. At any point of time I should be able to get
> the figures of all unit quantities.
> Khozema
>
> > > I am developing an accounting/stock/invoicing system formy small business. if ypu would like to share your package
> > > with me , I would be most grateful
> > > > >
> > > > >
> > > > > what kind of systems do you usually do?
> > > >
> > > >
> > > > I have developed a share accounting cum financial accounting package and a package for traders with invoicing,stock maintainance, financial accounting.
> >
> >
> > Hi Khozema,
> >
> > I shall be gald to share my package with you. But the problem is its too big a piece of software. If however you wish to discuss some points we can surely help each other.
> >
> > Thanx,
> >
> > Anil

Hi,

I think the problem can be solved if you change the qty field in your sale/purchase table to accept three decimal places. Then you can let the user choose a unit of measurement while entering purchase & sale invoices. This way you will have different kinds of units in your table. You will have to store the conversion factor of the bigger units to smallest one in another table. When you want to take the inventory first convert all the barrels/containers/litres etc to ml. After calculating the inventory in ml. convert it back to higher units.

HTH,

Anil


ENTIRE THREAD

Want to work on a VFP Project for free Posted by aktayal @ 8/31/2004 5:40:55 PM
RE: Want to work on a VFP Project for free Posted by Frodo Baggins @ 9/1/2004 4:56:34 AM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/1/2004 7:08:09 AM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/2/2004 4:08:22 AM
RE: Want to work on a VFP Project for free Posted by Mike Shea, Jr @ 9/2/2004 2:30:25 PM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/2/2004 4:30:42 PM
RE: Want to work on a VFP Project for free Posted by Mike Shea, Jr @ 9/3/2004 2:29:17 PM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/4/2004 1:20:59 PM
RE: Want to work on a VFP Project for free Posted by Mike Shea, Jr @ 9/8/2004 3:07:28 PM
RE: Want to work on a VFP Project for free Posted by Hermo Buenaflor @ 10/15/2004 9:54:09 AM
RE: Want to work on a VFP Project for free Posted by aktayal @ 10/16/2004 8:10:37 PM
RE: Want to work on a VFP Project for free Posted by Dzune Lao @ 9/11/2004 7:09:35 AM
RE: Want to work on a VFP Project for free Posted by khozema adenwala @ 9/9/2004 8:16:10 PM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/15/2004 7:30:53 AM
RE: Want to work on a VFP Project for free Posted by khozema adenwala @ 9/15/2004 10:58:39 AM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/22/2004 6:15:27 AM
RE: Want to work on a VFP Project for free Posted by Mz @ 9/4/2004 9:13:06 AM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/4/2004 1:10:26 PM
RE: Want to work on a VFP Project for free Posted by Mz @ 9/5/2004 8:12:21 AM
RE: Want to work on a VFP Project for free Posted by Boudewijn Lutgerink @ 9/6/2004 6:58:54 AM
RE: Want to work on a VFP Project for free Posted by Mz @ 9/6/2004 7:01:15 AM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/6/2004 7:59:51 AM
RE: Want to work on a VFP Project for free Posted by Boudewijn Lutgerink @ 9/6/2004 9:32:53 AM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/6/2004 6:13:25 PM
RE: Want to work on a VFP Project for free Posted by Boudewijn Lutgerink @ 9/7/2004 6:06:11 AM
RE: Want to work on a VFP Project for free Posted by Satyapal Singh @ 9/13/2004 12:33:58 PM
RE: Want to work on a VFP Project for free Posted by aktayal @ 9/15/2004 7:28:19 AM