Notifications
Announcements
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
TAHER Mehdi 3
Nakul 2
Mea_ 2
