Skip to Content
0

Golden Arrows Not Working For AR Invoice

Oct 31, 2017 at 02:07 AM

38

avatar image

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] <> ' '
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jitin Chawla
Oct 31, 2017 at 05:31 AM
1

Hi,

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

Regards,

Jitin

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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?

0

Hi,

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

Regards,

Jitin

0

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"

0