POR1 remaining quantities (even if OPOR is closed !)

[Former Member]

Hi

How can I get the the total quantity received for an item in POR1 ?

Suppose I placed an order for a quantity of 10  on Purchase Order in B1.

I create the folowing Good Receipt PO

GR1, Quantity 1

GR2, Quantity 5

GR3, QUantity 2

POR1.Quantity shows 10

POR1.OpenQty shows 2

So far so good

then i close the PO. I know those 2 remaining items will never be received.

SAP resets the POR1.OpenQty to 0 !

If I rerun the query, there is 0 OpenQty.

So 2 months later I need a report of all Items that were incomplete.

I cannot use POR1.

What shoud i do ?

thanks

[kothandaraman_nagarajan · Accepted solution]

Hi,

Once purchase order closed, there is no open quantity in POR1 table. You have create query to get the balance quantity.

Try this query:

SELECT T0.ItemCode,

SUM (T0.Quantity) 'PO Qty',

SUM (T1.Quantity) 'GRPO Qty',

SUM (T2.Quantity) 'Return Qty' FROM dbo.POR1 T0

LEFT JOIN dbo.PDN1 T1

ON T0.DocEntry = T1.BaseEntry AND T0.LineNum = T1.BaseLine

LEFT JOIN dbo.RPD1 T2

ON T1.DocEntry = T2.BaseEntry AND T1.LineNum = T2.BaseLine WHERE T0.ItemCode is not NULL AND T0.DocDate >= [%0] AND T0.DocDate <=

[%1] GROUP BY T0.ItemCode ORDER BY T0.ItemCode

Thanks & Regards,

Nagarajan