News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Relationships between ...

Small and medium business | Business Central, N...

Answered

Relationships between tables Purch_ Inv_ Line + Item Ledger Entry

(1) 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.

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

YUN ZHU 85,450 Super User 2025 Season 1 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 > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans