Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tariq Mehmood
  Where is Tariq Mehmood?
 BAHAWALPUR
 Pakistan
 Tariq Mehmood
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: Closing Stock Value
Thread ID: 267600 Message ID: 268715 # Views: 50 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, July 14, 2010 8:37:08 AM         
   


> > Hi Cetin,
> >
> > In this query, will it give correct results if there is purchase of an item which is not present in opening stock?
> >
> > Vivek
> >
> > Vivek
>
> Look at "left join" or "left outer join" in help. Here since I used left join, no. I am not into accounting and I thought you wouldn't be able to purchase an item that doesn't have a stock definition hence opening.
>
> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> Blog (main)
> Blog (mirror)

Yes cetin, yor are right, we could not make any transcation of such product that is not exists in products master file.

ENTIRE THREAD

Closing Stock Value Posted by Tariq mehmood @ 7/5/2010 8:41:07 PM
RE: Closing Stock Value Posted by Anders Altberg @ 7/6/2010 10:42:00 AM
RE: Closing Stock Value Posted by Tariq mehmood @ 7/6/2010 6:30:03 PM
RE: Closing Stock Value Posted by kulwant singh @ 7/6/2010 5:25:15 PM
RE: Closing Stock Value Posted by Tariq mehmood @ 7/6/2010 6:33:58 PM
RE: Closing Stock Value Posted by Anders Altberg @ 7/7/2010 4:37:23 PM
RE: Closing Stock Value Posted by kulwant singh @ 7/7/2010 5:28:33 PM
RE: Closing Stock Value Posted by anand kulkarni @ 7/6/2010 5:45:49 PM
RE: Closing Stock Value Posted by Cetin Basoz @ 7/7/2010 1:49:30 PM
RE: Closing Stock Value Posted by Anil Sharma @ 7/7/2010 3:40:29 PM
RE: Closing Stock Value Posted by Cetin Basoz @ 7/7/2010 4:06:36 PM
RE: Closing Stock Value Posted by Anil Sharma @ 7/7/2010 4:32:13 PM
RE: Closing Stock Value Posted by Tariq mehmood @ 7/8/2010 7:04:08 AM
RE: Closing Stock Value Posted by Cetin Basoz @ 7/8/2010 12:26:03 PM
RE: Closing Stock Value Posted by Tariq mehmood @ 7/8/2010 5:26:18 PM
RE: Closing Stock Value Posted by kulwant singh @ 7/8/2010 12:31:55 PM
RE: Closing Stock Value Posted by kulwant singh @ 7/7/2010 5:01:03 PM
RE: Closing Stock Value Posted by Tariq mehmood @ 7/8/2010 5:29:48 PM
RE: Closing Stock Value Posted by Vivek Deodhar @ 7/13/2010 7:50:47 AM
RE: Closing Stock Value Posted by Cetin Basoz @ 7/13/2010 1:04:29 PM
RE: Closing Stock Value Posted by Tariq mehmood @ 7/14/2010 8:37:08 AM
RE: Closing Stock Value Posted by alwy ali @ 7/8/2010 6:17:58 PM
RE: Closing Stock Value Posted by Anil Sharma @ 7/8/2010 8:35:14 PM
RE: Closing Stock Value Posted by Tariq mehmood @ 7/8/2010 10:14:54 PM
RE: Closing Stock Value Posted by tushar @ 7/11/2010 7:55:52 AM
RE: Closing Stock Value Posted by Tariq mehmood @ 7/12/2010 5:39:46 PM
RE: Closing Stock Value Posted by Tariq mehmood @ 12/2/2010 5:47:07 PM
RE: Closing Stock Value Posted by tushar @ 12/4/2010 8:27:12 AM
RE: Closing Stock Value Posted by Anders Altberg @ 7/15/2010 2:54:21 PM
RE: Closing Stock Value Posted by Mohammad Iqbal @ 7/15/2010 7:15:20 PM
RE: Closing Stock Value Posted by Anders Altberg @ 7/15/2010 7:26:49 PM