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, ...
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by 56

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
    56 on at

    Can anyone please help me on this 

    Its urgent. 

  • Martin Dráb Profile Picture
    239,208 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
    56 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
    56 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
    56 on at

    any one faced the same issue before?

    Kindly advice me how to resolve.

  • Suggested answer
    ergun sahin Profile Picture
    8,826 Moderator on at
  • @rp@n Profile Picture
    56 on at

    Thanks Ergun,

    Where & what modification require in our case?

    Please give me more shed on this 

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

    Ergun,

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

    Kindly let me know please.

  • @rp@n Profile Picture
    56 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 657

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 453 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Martin Dráb 190 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans