Skip to Content
0
Jan 29, 2016 at 07:28 AM

how to insert Issued qty Prodcution Production Order Detail

25 Views

Dear All,

kindly help on below query

-----------Report Any FG product against

SELECT distinct T0."DocNum",t0."U_UNE_BTNO" AS "BPR BATCHNUM",t0."U_UNE_MFGD" AS "BPRMFG",t0."U_UNE_EXPD"AS "BPREXP",T0."ItemCode",

T4."ItemName", T0."PlannedQty", T0."CmpltQty", T1."ItemCode",T5."ItemName", SUM(T1."IssuedQty") AS "Total Qty"

FROM OWOR T0

INNER JOIN WOR1 T1 ON T0."DocEntry" = T1."DocEntry"

LEFT OUTER JOIN IBT1 T3 ON T3."BsDocEntry" = t1."DocEntry" AND T1."ItemCode" = T3."ItemCode"

inner JOIN OITM T4 ON T0."ItemCode" = T4."ItemCode"

inner JOIN OITM T5 ON T1."ItemCode" = T5."ItemCode"

WHERE (T0."Status" = 'R' OR T0."Status" = 'L') AND T1."ItemCode" = '1013120032'--AND T0."ItemCode" = [%0] AND T0."PostDate" BETWEEN [%1] AND [%2]

GROUP BY T0."DocNum", T0."DocNum",t0."U_UNE_BTNO" ,t0."U_UNE_MFGD",t0."U_UNE_EXPD",T0."ItemCode", T4."ItemName",T0."PlannedQty", T1."ItemCode",T5."ItemName", T0."CmpltQty"

Danish

Attachments

2016-01-29_12.png (89.0 kB)