​Golden Arrow disappears (SAP Business One 9.3)

[former_member773342]

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.

SELECT
T0.[AbsID]
,T1.[DocNum]
,V0.[OwnerCode]
,V0.[DocDate]
,V0.[Typ]
,V0.[CardName]
FROM [vw_query1] V0
LEFT JOIN OOAT T0 ON V0.[AbsID] = T0.[AbsID]
LEFT JOIN OPOR T1 ON V0.[DocNum] = T1.[DocNum]
FOR BROWSE

As expected in the query editor the AbsID and DocNum columns are displayed with golden arrows.

Then in the 'Alert Overview', the golden arrow is displayed only for the first column.

The second arrow also disappears when I swap the columns.

(It's okay. The number of rows have changed in the meantime.)

Does anyone know how I can fix this, so that the golden arrows appear as intended?

Thanks and greetings

Roger

[jitin_chawla]

Hi,

Check your query by including the DocEntry field from OPOR table.

Regards,

Jitin

[former_member773342]

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.