Skip to Content

Golden Arrows Not Working For AR Invoice

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] <> ' '
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 31, 2017 at 05:31 AM

    Hi,

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

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded