Hi All
Is this Query regulation cannot person DocEntry hyper nexus to drill into posted transactions successful this customized Query?
SELECT
T8.DocEntry, T8.DocNum,
T2.DocNum,
T7a.[U_AF_MAJORGRP], T7a.[U_AF_OVERGRP],
T7b.ItmsGrpNam,
T7.ItemCode, T7.Dscription,
T7.Quantity, T7a.InvntryUom, T8.DocDate, T8.DocDueDate,
T8.CardCode, T8.CardName, T7.Price
--T6.DocNum,
--T10.DocNum
FROM POR1 T1
LEFT OUTER JOIN OPOR T2
ON T1.DocEntry = T2.DocEntry
LEFT OUTER JOIN PDN1 T3
ON T2.DocEntry = T3.BaseEntry
AND T1.LineNum = T3.BaseLine
AND T1.ItemCode = T3.ItemCode
LEFT OUTER JOIN OPDN T4 ON T3.DocEntry = T4.DocEntry
LEFT OUTER JOIN RPD1 T5 ON T4.DocEntry = T5.BaseEntry AND T3.LineNum = T5.BaseLine AND T3.ItemCode = T5.ItemCode
LEFT OUTER JOIN ORPD T6 ON T5.DocEntry = T6.DocEntry
LEFT OUTER JOIN PCH1 T7 ON T4.DocEntry = T7.BaseEntry AND T3.LineNum = T7.BaseLine AND T3.ItemCode = T7.ItemCode
LEFT OUTER JOIN OPCH T8 ON T7.DocEntry = T8.DocEntry
LEFT OUTER JOIN OITM T7a ON T7.[ItemCode] = T7a.[ItemCode]
INNER JOIN OITB T7b ON T7a.[ItmsGrpCod] = T7b.[ItmsGrpCod]
LEFT OUTER JOIN RPC1 T9 ON T8.DocEntry = T9.BaseEntry AND T7.LineNum = T9.BaseLine AND T7.ItemCode = T9.ItemCode
LEFT OUTER JOIN ORPC T10 ON T9.DocEntry = T10.DocEntry
WHERE
T8.[DocDate] >=[%0] and T8.[DocDate] <=[%1]
ORDER BY
--T2.DocNum,
--T1.LineNum,
--T4.DocNum,
--T3.LineNum,
--T6.DocNum,
--T5.LineNum,
T8.DocNum
--T7.LineNum,
--T10.DocNum,
--T9.LineNum
Kedalene Chong