Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Vivek Deodhar
  Where is Vivek Deodhar?
 SANGLI
 India
 Vivek Deodhar
 Tags
Subject: RE: Closing Stock Value
Thread ID: 267600 Message ID: 268589 # Views: 52 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, July 13, 2010 1:04:29 PM         
   


> 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)

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