Hi all,
I'm having difficulties creating a filter. I want to filter only Sales type entries from the VAT Entry table but these should also include reverse charge VAT calculation type, which can be of type purchase.
=NL(;"Tax Entry";;"Type";"Sale";;;"Document No.";$B3;"Company=";Options!$D$10)
Any ideas? Thanks!
Date
Votes
1 comment
-
Jet Reports Historic Posts If I understand correctly, what you want is…
The first record where EITHER
FieldA is "XXX"
OR
FieldB is "YYY"
Is that correct?
If so, perhaps something like this would work:=NL("First";"Table_Name";;"=OR(NF(;""FieldA"")="XXX";NF(;""FieldB"")="YYY")";"@TRUE")
Please sign in to leave a comment.