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

Notifications

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, ... / 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) ShareShare
ReportReport
Posted on by @rp@n 30

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!

I have the same question (0)
  • @rp@n Profile Picture
    @rp@n 30 on at

    Can anyone please help me on this 

    Its urgent. 

  • Martin Dráb Profile Picture
    Martin Dráb 237,976 Most Valuable Professional on at

    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?

  • @rp@n Profile Picture
    @rp@n 30 on at

    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!

  • @rp@n Profile Picture
    @rp@n 30 on at

    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 Profile Picture
    @rp@n 30 on at

    any one faced the same issue before?

    Kindly advice me how to resolve.

  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,826 Moderator on at

    bmdax.blogspot.com/.../joins-inner-outer-combined.html

  • @rp@n Profile Picture
    @rp@n 30 on at

    Thanks Ergun,

    Where & what modification require in our case?

    Please give me more shed on this 

  • @rp@n Profile Picture
    @rp@n 30 on at

    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 Profile Picture
    @rp@n 30 on at

    Ergun,

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

    Kindly let me know please.

  • @rp@n Profile Picture
    @rp@n 30 on at

    kindly help me on this?

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans