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 :
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
    303,481 Super User 2026 Season 1 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
    303,481 Super User 2026 Season 1 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

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... 527 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 473

#3
Adis Profile Picture

Adis 284 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans