Skip to Content

Golden Link Arrow on Query Alerts

Hello Experts,

     i tried add  link arrow on Sales order Document No. And Delivery Document No. I can Put Link Arrow on Delivery Document No but I can't Put On Sales Order Document No. If I pull up the query in the query manager it has several golden arrows but when the alert comes up and it's clicked on there is no golden arrow.

SELECT T1.[DocEntry] As [Delivery No], T0.[DocEntry] As [Sales No],T1.[DocNum],T0.[Quantity], T2.[Quantity] FROM  ODLN T1 INNER JOIN DLN1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN RDR1 T0 ON T2.[BaseRef] = T0.[DocEntry] WHERE T0.[TrgetEntry]= T1.[DocNum] and T0.[Quantity] < > T2.[Quantity] FOR BROWSE

Thanx & Regards
Harshit

Query.JPG (104.1 kB)
Alter.JPG (153.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 24, 2014 at 07:42 AM

    Hi,

    1. Try:

    SELECT T1.[DocNum], T1.[DocEntry] As [Delivery No], t3.docnum,T0.[DocEntry] As [Sales No],T0.[Quantity], T2.[Quantity]

    FROM  ODLN T1 INNER JOIN DLN1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN RDR1 T0 ON T2.[BaseRef] = T0.[DocEntry] inner join ORDR T3 on T3.docentry = T0.docentry

    WHERE T0.[TrgetEntry]= T1.[DocNum] and T0.[Quantity] < > T2.[Quantity] FOR BROWSE

    2. It is not possible to get sales order document link arrow in alert. Only first document no in the query  will be displayed alert message.

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded