Which Tables are used for Query to report on all Items receipted against Purchase Order

[former_member1259812]

I am using OIGN and IGN1 to get receipted date and items/quantity however this is pulling all receipted goods based in different stock transactions. I only want those receipted against Supplier Orders into our warehouse.

Any help would be greatly appreciated.

[MD1]

Dear Robert,

As I understand that you are talking about receipt from production.

If you try to understand it through a screenshot, then I can help you on this.

Something a bit like this

Danish

[former_member1259812]

Thanks jhozz I'll give that a go - i have a query that checks all receipts from Production Orders but we have items that don't get produced via a production order and my query i was running prevoiusly was picking up all reciepted items.

I'll give this ago and let you know.

[jhozz]

Hi robert_heywood86, you could use this Query structure:

SELECT --
FROM OPOR T0  
INNER JOIN POR1 T1 ON T0."DocEntry" = T1."DocEntry"
INNER JOIN PDN1 T2 ON T1."DocEntry" = T2."BaseEntry" AND T1."LineNum" = T2."BaseLine" AND T2."BaseType" = T1."ObjType"
INNER JOIN OPDN T3 ON T2."DocEntry" = T3."DocEntry"