I think I've been down this road before but have situation where I need to filter based on a field <> A & <> B & <> C Nothing I've tried so far has given me anything other than VALUE error
If it helps any this is a report out of Navision based on Customer ledger entry remaining amount
One line for Invoices
One line for Credit Memos
One line for Payments
One line for everything not one of those three and unfortunately I suspect there are blanks in the field being filtered
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Yes I was trying to do this by Document type ended up the only way I could get numbers to balance was ignore type and do it by remaining amount >0 or < 0 so I got total debit and total credit just no break down by type . He's happy so this one is TCO .
-
Jet Reports Historic Posts Are you filtering on the Document Type field of the Customer Ledger Entry table? This field has 7 options: (blank),Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund. If so, why don't you filter on "equal to" the 4 options you need instead of filtering on "unequal to" the 3 you want to avoid.
Options are numbered - starting at 0. (blank) is option number 0, Payment is option number 1 etc. You may use these numbers in your filter:
NL("Filter","Customer ledger entry",,"Document type","0|4|5|6") -
Jet Reports Historic Posts Hi!
If you want to filter by field values that don't start with the letters A or B or C, the best thing to do is a range filter for "D..". Of course if you want to filter for values not equal to some set of disparate letters, like A or F or H, you could do a combination like this: "B..EZ|G..GZ|I.."
Does that help?
Regards,
Hughes
Please sign in to leave a comment.