What is the correct order to add filters to the AR Aging Report
Good day
I am trying to add additional filters to an AR Aging Report Template that is specifically for certain Customer Classes. It also adds and excludes certain customers from a different class.
It worked before I tried to add additional customers, but no longer does.
Is there a specific order that these filters must be added? Or are there too many criteria?
Customer (alias).Customer ID Equals
Customer (alias).Customer ID Does not Equal
Customer (alias).Customer Class Equals
Customer (alias).Customer Name Does not Contain
Many thanks in Advance
Page 1 / 1
Hello @BarbaraPietersen23 ,
In order to answer, I’d like to see an exact example, including the Operator on each line of Additional Filters, and where brackets are placed. Can you describe what isn’t working (report results in too many customers? report results in too few customers, no customers?)
Thank you.
Laura
Thanks Laura - see below. This report should run to several pages.
results:
Regards
Barbara
Hello,
Thanks for the details; it helps me understand when I can SEE things.
I think you will need to use some double parenthesis, and approach like this:
((Classes to include:
Customer Class Equals GRWINF, Or customer class Equals GRWFOR, ... etc.)
AND
(Customers to exclude that are in the above classes: Customer ID Not Equal IB002747 AND Customer ID Not Equal IB004710))
OR
(Add Customers who are NOT in the above classes:
Customer ID Equal IB000123 OR Customer ID Equal IB000456 OR Customer ID Equal IB000789)
AND
(List customers with certain names that should be Excluded:
Customer Name does not contain ExpressBox and
Customer Name does not contain BUAN )
I hope this works for you.
Laura
Thank you so much Laura. This worked just fine!
Hi Laura
Hope you can help me again - your advice worked so well last time. Once again I can’t get my head around brackets and the and/or operator. Please tell me what is wrong with the below conditions:
