Golden Arrows Not Working For AR Invoice

[jimbo1234]

Hi

I have written the below and added as a UF. I have used the format wizard to successfully add golden arrows to the customer code field, but cannot seem to get them to work on the Invoice number column, they appear but do nothing when selected.

SELECT T0.[DocDate], T0.[DocNum],T0.[NumAtCard], T0.[CardName], T0.[CardCode], T1.[Weight1], T1.[U_SerialNumber], T1.[U_CheckedBy], T1.[U_SerialNumber2], T1.[U_CheckedBy2] 
FROM OINV T0  INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] 
WHERE T0.DocDate>='[%0]' and T0.DocDate<='[%1]' and T1.[U_SerialNumber] IS NOT NULL  and  T1.[U_SerialNumber] <> ' '

[jitin_chawla · Accepted solution]

Hi,

Have you checked using the DocEntry instead of the DocNum field?

Regards,

Jitin

[jimbo1234 · Accepted solution]

Thanks Jitin, just what i wanted

I have another one the same where i have used UNION ALL to combine results from invoice, Sales orders, Credit Memos and Down payment invoices. How do i get the golden arrows working on them with 4 doc types?

[jitin_chawla · Accepted solution]

Hi,

Did you check the DocEntry itself? This is a common field in all the documents mentioned by you.

Regards,

Jitin

[jimbo1234 · Accepted solution]

I just tried that, but which Golden Arrow type do I select in the Wizard? As each has its own unique - "OINV_ENTRY", "ORIN_ENTRY" , "ODPI_ENTRY"