Skip to Content
author's profile photo Former Member
Former Member

stock statement query--- help

Have any one got the stock statement query report in the folowing format....

1.ItemCode

2.Item Description

3.Item Price

4.Opening

5.Receipts

6.Issues

7.Closing

8. Value

The selection criteria are:

3.Posting Date

from wh

to wh

help me in making stock statement query

regards,

Vignesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2010 at 12:24 PM

    Hi Vignesh......

    Check this path......

    Inventory> Inventory Reports> Inventory Posting List.....

    This report will meet your exact requirement and as its standard report so it will give your proper data also.....

    Regards,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 22, 2010 at 12:54 PM

    Hi,

    Check stock-statement thread

    Thanks,

    Neetu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      Check This

      select w0.itemcode, i0.docdate, w0.whscode, w0.onhand - isnull (sum (i0.inqty - i0.outqty), 0), 0
      from oitw w0 left outer join oinm i0 on w0.itemcode = i0.itemcode and w0.whscode = i0.warehouse
      where i0.docduedate >= [%0]
      group by w0.itemcode, w0.whscode, w0.onhand, i0.docdate
      having w0.itemcode = [%1] and w0.onhand - isnull (sum (i0.inqty - i0.outqty), 0) >= 0
      union
      select w0.itemcode, i0.docdate, w0.whscode, 0, -(w0.onhand - isnull (sum (i0.inqty - i0.outqty), 0))
      from oitw w0 left outer join oinm i0 on w0.itemcode = i0.itemcode and w0.whscode = i0.warehouse
      where i0.docduedate >= [%0]
      group by w0.itemcode, w0.whscode, w0.onhand, i0.docdate
      having w0.itemcode = [%1] and w0.onhand - isnull (sum (i0.inqty - i0.outqty), 0) < 0
      

      or

      SELECT T0.ITEMCODE, T0.DSCRIPTION,T0.OPENQTY, T0.OPENVALUE, T0.INQTY, T0.INQTY*T0.PRICE AS 'RCPT VAL', T0.OUTQTY,T0.OUTQTY*T0.PRICE AS 'ISS. VAL', T0.INQTY-T0.OUTQTY AS 'CLOSING STOCK QTY',((T0.INQTY-T0.OUTQTY)*(T0.CALCPRICE)) AS 'CLOSING STOCK VAL' FROM OINM T0 WHERE T0.DOCDATE >=[%0] AND T0.DOCDATE <=[%1] 
      

      Thanks

      Kevin

      Edited by: Kevin Shah on Oct 23, 2010 5:37 PM

  • author's profile photo Former Member
    Former Member
    Posted on Oct 23, 2010 at 05:09 PM

    You may check this first: Monthly Open Balance & Closing Balance of Inventory Stock Report

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.