web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Customer Pool Criteria - Invalid Filter Error

(0) ShareShare
ReportReport
Posted on by 266

Hello All - 

After setting the customer pool criteria I receive this message: 

The filter Customers.Name is invalid and will not be added to the query for one of the following reasons: (1) The data source is not part of this query. (2) The query is split into multiple queries due to 1:n fetch mode. (3) The data source is used in a sub query.

If I remove the Customer name field from the criteria then the pool is saved without this message appearing otherwise the criteira is not saved and no aging snapshot is created. Anyone else experiencing this issue? 

 Customer-pool-criteria-message-clear.png

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,069 Super User 2025 Season 2 on at

    Hi Barry,

    If you need to filter on the name, have you tried the field Name from the Global address book table? The name field on the customers table is not a real field. A customer is linked to a global address book party which contains the name.

  • BarryR Profile Picture
    266 on at

    André - the Customer table with field 'Customer' is one of the default tables listed when I click on Select Pool Criteria. But, I'm not selecting Customer as one of my criteria. In my example I only chose table 'Customer aging snapshot' line. It doesn't seem to matter which table I choose though, as I always get the error message and am not able to save the pool criteria. I have to manually remove the Customer table in order to proceed.

    Thanks for your response.  

  • André Arnaud de Calavon Profile Picture
    301,069 Super User 2025 Season 2 on at

    Hi Barry,

    I tried to reproduce your issue and now noticed what you experience as the issue. When you create new pools the query is indeed showing the Customers.Name field in the ranges which is causing an error if you don't remove it.

    It can be considered as a bug. You can create a support ticket for Microsoft Support to log this incident.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans