Total GRN Quantity

[Former Member]

How to Know the total grn quantity for an item against PO??

[former_member227598]

Hi Siva,

Try Below Query .......

select  T0.DocEntry as 'PO No',T0.Quantity POQTY ,(select sum(T1.quantity) from  PDN1 T1 where T1.BaseEntry=T0.DocEntry and T1.baseline=T0.LineNum and T1.itemcode=T0.ItemCode) GRNQty from POR1 T0

Rgds,

Kamlesh Naware

[Former Member]

Hi ,

select itemcode,Quantity POQty ,OpenQty, (quantity-OpenQty) GRNQty ,LineStatus from por1

Regards

Rajesh NS

[Former Member]

if GRN took more than po quantity??

Regards,

Siva

[Former Member]

Hi ,

select  a.itemcode,a.Quantity POQTY ,(select sum(b.quantity) from  PDN1 b where b.BaseEntry=a.DocEntry and b.baseline=a.LineNum and b.itemcode=a.ItemCode) GRNQty from POR1 a

Regards Rajesh N