cancel
Showing results for 
Search instead for 
Did you mean: 

DocEntry hyper link not working

kedalenechong
Participant
0 Kudos
175

Hi All

Is this Query limitation cannot have DocEntry hyper link to drill into posted transactions in this customized Query?

kedalenechong_0-1719290178146.pngkedalenechong_1-1719290193049.png

 

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

View Entire Topic
LoHa
Active Contributor
0 Kudos

Hi,

you can't mix up different DocTypes

regards Lothar