Skip to main content
Solved

What is the correct order to add filters to the AR Aging Report

  • February 28, 2024
  • 6 replies
  • 115 views

Forum|alt.badge.img

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

 

Best answer by Laura02

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

 

 

 

View original
Did this topic help you find an answer to your question?

6 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • February 28, 2024

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


Forum|alt.badge.img

Thanks Laura - see below. This report should run to several pages.

results:

Regards

Barbara


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • Answer
  • February 29, 2024

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

 

 

 


Forum|alt.badge.img

Thank you so much Laura. This worked just fine!


Forum|alt.badge.img

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:

Many thanks in advance.


Forum|alt.badge.img

Don’t worry - I got it at last!

No brackets and all Or. ðŸ¤”

Thanks anyway!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings