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

Notifications

Announcements

Community site session details

Community site session details

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

Unable to Join Order Lines (NotExist) to Released Products View

(0) ShareShare
ReportReport
Posted on by 166

Hello 

I am trying to create a simple view of released products that have no sales orders lines.

I attempted to join Order Lines (Not Exist) as per below:

pastedimage1685634070183v2.png

but the table displays as the regular Order Lines table:

pastedimage1685634096869v3.png

No issues adding the On-hand Inventory table as NotExist

pastedimage1685634143322v4.png

Again, note that below the On-hand Inventory is NotExist, but the Order Lines is not

I need to add the Order Lines as NotExist.  Am I doing something wrong? 

Thanks

Paul

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

    Hi Paul,

    On what form or report are you trying to add this non-exists join link? This works for me correctly on the released products form.

  • Paul V Profile Picture
    166 on at

    Hi Andre.

    I am on the Released Products Grid

  • Paul V Profile Picture
    166 on at

    EcoResProductDetailsExtendedGrid is the last part of the URL

    Released Products Detail is the form name

  • Paul V Profile Picture
    166 on at

    We are on :

    Installed product version : 10.0.31 (10.0.1406.165)

    Installed platform version : Update55 (7.0.6651.135)

    I am using the Released Products Grid.

    EcoResProductDetailsExtendedGrid is the last part of the URL

    Released Products Detail is the form name

    Thanks!

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

    Hi Paul,

    This is the same form as I tried. Can you check if there is a customization or a previous saved query with the Order lines table?

  • Verified answer
    Paul V Profile Picture
    166 on at
    I just rechecked this and I am now seeing "NoExist" for Order Lines.  Not sure what has changed

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…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 437 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 348 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans