Dynamics 365 CommunityForums Microsoft Dynamics NAV forum Relationships between ...

Microsoft Dynamics NAV forum

Answered

Relationships between tables Purch_ Inv_ Line + Item Ledger Entry

(2) Share

Report

Report

Posted on by SM-29041451-0

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:

Attachments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

YUN ZHU 60,557 Super User on at

Like (1)

Report

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

Leaderboard

Andre Arnaud de Cal... 283,281 Super User

Martin Dráb 223,025 Super User

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans