You’re offline. This is a read only version of the page.
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 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.
I have same question with you
Hi Scotly,
What is your exact question? Did you have a look at the tables and the defined relations in the Application Object Tree (AOT)?
Can you please elaborate more about Primary key and foreign key relationship between these tables ?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (