on 10-31-2017 2:07 AM
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] <> ' '
Hi,
Have you checked using the DocEntry instead of the DocNum field?
Regards,
Jitin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.