Open Items Query Report

[former_member593234]

Hi All,

I want open item list query (SO & PO), including Date, Sales Employee Name, Owner Name, Description, Part NO, Document name, selection of SO & PO. Thank You.

[dinesh-pn]

Dear athul,

Refer with this query :

Replace the ORDR as OPOR and RDR1 as POR1 for purchase open list

SELECT

T0."DocEntry",T0."DocNum", T0."DocDate", T0."DocDueDate" as "Expected Delivery Date", T0."CardCode" as "Customer ID", T0."CardName" as "Customer Name", T1."ItemCode", T1."Dscription", T1."Quantity", ( T1."Quantity"-T1."OpenQty") as "Delivered Qty", T1."OpenQty", T1."Currency",T1."Rate", (T1."OpenQty"*T1."Price") as "Open Value" , T2."SlpName" FROM ORDR T0 INNER JOIN RDR1 T1 ON T0."DocEntry" = T1."DocEntry" LEFT JOIN OSLP T2 ON T1.SlpCode = T2.SlpCode WHERE T1."LineStatus" = 'O' AND T1."OpenQty" > 0 AND T0."DocDate" >=[%0] AND T0."DocDate" <=[%1]

Regards

Dinesh PN

[former_member593234]

Thank You Dinesh