Skip to main content

Notifications

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?

 
SELECT *
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'
Categories:
  • 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.
    Thanks.
    ZHU
  • 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 ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 225,058 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans