Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

Relationships between tables Purch_ Inv_ Line + Item Ledger Entry

Posted on by 15
Hello!
I'm having trouble with two questions, please help:
1. How to find relationships between tables?
   How to join them?
   Purch_ Inv_ Header + Purch_ Inv_ Line + Item Ledger Entry
   I am joining them on document_no
   But for some reason, not all Purch_ Inv entries are appearing in the Item Ledger Entry
   Documents in Purch_ Inv look like PPINV-00000076
   In the Purch_ Inv_ Header table, I have 181 such documents, but only two have appeared in the Item Ledger Entry
   What could be the reason for this? Please advise.
Categories:
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 64,374 Super User on at
    Relationships between tables Purch_ Inv_ Line + Item Ledger Entry
    These two tables are not directly related because there is a one-to-many situation. Item Ledger Entries are the movement of items (Quantity), and Purchase_Inv_Line is the amount. Multiple invoices may be issued for a line of item receipt, or a Charge (Item) may exist.
    If you need to associate these two tables, you need to use Value Entire.
    Invoice No.
    Item Ledger Entry No.
     
    Hope this helps.
    Thanks.
    ZHU

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans