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

(0) Share

Report

Posted on by Paul V

135

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:

but the table displays as the regular Order Lines table:

No issues adding the On-hand Inventory table as NotExist

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

All responses (6)

Answers (1)

Verified answer

Paul V 135 on at

Like (0)

Report

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

I just rechecked this and I am now seeing "NoExist" for Order Lines. Not sure what has changed
André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at

Like (0)

Report

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

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?
Paul V 135 on at

Like (0)

Report

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

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!
Paul V 135 on at

Like (0)

Report

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

EcoResProductDetailsExtendedGrid is the last part of the URL

Released Products Detail is the form name
Paul V 135 on at

Like (0)

Report

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

Hi Andre.

I am on the Released Products Grid
André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at

Like (0)

Report

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

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.