web

You’re offline. This is a read only version of the page.

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.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

YUN ZHU 99,968 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,024 Super User 2026 Season 1

#2

YUN ZHU 1,145 Super User 2026 Season 1

#3

Khushbu Rajvi. 705 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans