Need a query

[Former Member]

Hi experts

i need a query which shows 3 fields

Item code                Total Out Qty                                                                                      Stock in hand (whs selection wise)

001000120               Delivery( delivery which is not Cancal or Return is not Done )  +                    10

                               Good Issue +

                               Stock Transfer            

filtering Whs wise and From To date based

Regards

[Former Member]

Dear Shahan

            Tell me, Exactly what you want?

[Former Member]

Hi

i need total qty of Delivery + Good Issue + Stock Transfer against an item in one row

if a delivery not is cancelled or Return is created , then that qty should not come

same way if a Stock transfer is Reverse then it should not get effect

like this

item code                                Total item went outside              Whse code               stock in hand

10000100                                            250                                      ABC                           1010

This 250 should be from  (

i need total qty of Delivery + Good Issue + Stock Transfer against an item in one row

if a delivery not is cancelled or Return is created , then that qty should not come

same way if a Stock transfer is Reverse then it should not get effect )

[Former Member]

Hey Dear,

     Try out this one query.

     SELECT T0.[ItemCode], T0.[IsCommited], T0.[OnHand] FROM OITW T0 WHERE T0.[WhsCode] =[%0]

Regards

Rahul P.

[Former Member]

Hi rahul

no rahul

am not getting the correct data

[Former Member]

Hi experts

Any Solution ,.......