[Axapta-Knowledge-Village] Hi

[ramesh_p2384]

Hi Every body 

I have a issue in report and its from inventory Management,

the requirement is PurchQty , SalesQty Finally Onhandqty.
[For ex ; purchqty 100, salesqty 40 finaly onhandqty = 60 ].

the problem is i am getting same values for sumof purchqty and  sum of 
salesqty. 
Based onthat i want calculte onhandqty, and i wrote coding in fetch method, 
like this


     "   select sum(qty) from inventtrans
        where inventtrans.ItemId==inventtable.ItemId &&
        inventtrans.DatePhysical>=romdate &&
        inventtrans.DatePhysical<=todate &&
        inventtrans.TransType==inventtranstype::Purch;

        purchqty = inventtrans.Qty; 
        this.send(inventtrans);   "

Finally how to calculate Onhandqty.

Regards

Ramesh