Skip to main content


Microsoft Dynamics NAV forum
Suggested answer

I can't complete the connection between the tables

Posted on by 4

HELLO! Can someone please advise on how to now link to the purchase invoice? How to complete this chain?

FROM [Training$Sales Invoice Header$437] AS sih
LEFT JOIN [Training$Sales Invoice Line$437] AS sil ON sil.[Document No_] = sih.[No_]
JOIN [Training$Value Entry$437] AS ve ON  ve.[Document No_] = sih.[No_] AND sil.[Line No_] = ve.[Document Line No_] 
JOIN [dbo].[Training$Item Ledger Entry$437] AS ile ON ve.[Item Ledger Entry No_] = ile.[Entry No_]
WHERE ve.[Source Code] != 'INVTADJMT'
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 62,411 Super User on at
    I can't complete the connection between the tables
    I think it would be easier to do it in C/Side, such as creating a Query~
    Hope this can give you some hints.
  • Judy Profile Picture
    Judy Microsoft Employee on at
    I can't complete the connection between the tables
    Hi, please refer to the old thread for some hints, hope it can help:

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,700 Super User

Martin Dráb Profile Picture

Martin Dráb 225,058 Super User

nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans