Hello all
I have created a query for an alert where a link to Blanket Agreement (OOAT) and to Purchase Order Table (OPOR) should be available.
SELECTT0.[AbsID],T1.[DocNum],V0.[OwnerCode],V0.[DocDate],V0.[Typ],V0.[CardName]FROM [vw_query1] V0LEFT ...
late, but i hope this can help someone somedaySELECT
T0.DocNum AS SalesOrderNr,
T0.DocEntry,
FORMAT (T0.DocDate, 'dd.MM.yyyy') AS 'Posting Date (Formated)',
FORMAT (T0.DocDueDate, 'dd.MM.yyyy') AS 'Delivery Date (Formated)',
T0.CardName,
CASE...
Thanks for the quick reply!I have already tried with the DocEntry from OPOR.The column with DocEntry is also displayed without arrow if it is not the first 'Golden Arrow'-column.
