Announcements
No record found.
Hi Every One,
I am new to this community ,
I have requirement that I need pull data from VendPackingSlipJour,vendtrans and VendInvoiceJour
I am struggle to join three tables
Please Help
*This post is locked for comments
Hi Scotly,
The most common relation on these tables is the Voucher (or Invoice) and Transaction date (or Invoice date). The relations are also visible in the table designs.
Can you please elaborate more about Primary key and foreign key relationship between these tables ?
What is your exact question? Did you have a look at the tables and the defined relations in the Application Object Tree (AOT)?
I have same question with you
Hi Crispin,
yes i have a same idea with you before you mention it.
but since the VendPackingSlipTrans.InvoiceTransRefRecId = 0... i changed my mind and go to this community.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sagar Suman 2 Super User 2026 Season 1
Alexey Lekanov 2
Pratik Bhosle 2