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.
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?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
15
Share
Report
All responses (
Answers (
