News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... The join does not cont...

Finance | Project Operations, Human Resources, ...

Suggested answer

The join does not contain any link between the joined tables in the WHERE clause

(0) Share

Report

Report

Posted on by @rp@n

22

Hi all,

Purchase Order - Inquiries - Invoice

When i clicked on Invoice then got below error in AX 2009

5314.j1.jpg

Kindly let me know how will resolve this issue?

thanks!

All responses Img

All responses (11)

Answers Img

Answers (0)

@rp@n 22 on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

hi All,

Can anyone let me know how will resolve this issue?

pls give me more shed on this.

thanks!
@rp@n 22 on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

kindly help me on this?
@rp@n 22 on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

Ergun,

As the link you shared, what about Cluster table in our case?

Kindly let me know please.
@rp@n 22 on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

In our scenario, I need to check

PurchTable form , data sources -- PurchTable and PurchTableRef the join type ?

If in the PurchTableRef joinType is Outer join then we needs to change to Inner join.

Am I correct?
@rp@n 22 on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

Thanks Ergun,

Where & what modification require in our case?

Please give me more shed on this
Suggested answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

bmdax.blogspot.com/.../joins-inner-outer-combined.html
@rp@n 22 on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

any one faced the same issue before?

Kindly advice me how to resolve.
@rp@n 22 on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

Hi Martin,

I have also compared the form - PurchTable xpo from PROD in to DEV.

no difference found.

In PROD, it's working fine.

@ shall i import the PurchTable xpo ( Prod ) in to DEV ? Is it right approach?

If i do this? is it solve the issue?

kindly suggest me
@rp@n 22 on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

Thanks Martin

I have cross verified with PROD. Both having same data sources. I also checked the join type of each data sources.

Kindly let me know anything else need to check ?

Why this error occurred? What is the reason?

Please give me more shed on this

Thanks!
Martin Dráb 233,334 Most Valuable Professional on at

Like (0)

Report

RE: The join does not contain any link between the joined tables in the WHERE clause

You would have a better chance to get an answer if you gave us more information.

For example, didn't you recently made a change to the form? Do you have code or extra data sources there? If you have code there, can't you share it with us?

Helpful resources

Quick Links

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

#1

Abhilash Warrier 225

#2

Martin Dráb 174 Most Valuable Professional

#3

Adis 132 Super User 2025 Season 1

Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans