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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Advanced filtering doe...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Advanced filtering doesn't work when criteria is set on the joined table

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Have any of you observed the situation that on the Header/Line form (Free text invoice for example), even though you can join the line table (CustInvoiceLine) in the Advanced filter but when you specify the query criteria on the line lever (amount < 50 on CustInvoiceLine for example), the filtering doesn't work, it would still show all of the free text invoices.

So my questions are:

(1) How to make the Advanced filtering work when query criteria set on the joined table only?

(2) How to debug this to find out what is exactly query being run when running Advanced filtering?

Thank you!

I have the same question (0)
  • Mea_ Profile Picture
    Mea_ 60,286 on at

    I cannot say anything on 1 but for 2 you can run trace parser and see what query is generated and from where. 

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,163 Super User 2026 Season 1 on at

    Hi Yvonne,

    If you have a form with multiple data sources, you have to filter per data source. If you open the advanced filter for the header and you include new table joins, it will only filter the header records with your query. So it will then show e.g. all free text invoices containing lines with an amount < 50. But for those invoices it will show all lines. If you only want to see certain lines, you have to apply a filter starting on the lines data source.

  • Community Member Profile Picture
    Community Member on at

    Is there a proper documentation for using Tracer Parser for D365 F&O?  It's very straightforward in AX2012 but in F&O when I opened the Tracer Parser tool to open the trace I collected it gave me error ""This trace doesn't contain a session which can be analyzed.".

  • Mea_ Profile Picture
    Mea_ 60,286 on at

    Sure, here you go docs.microsoft.com/.../trace-trace-tutorial

  • Community Member Profile Picture
    Community Member on at

    That's the document I was following but got that error.  I've opened a MS ticket so they can take a look.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 797

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 589 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 534

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans