Hi,
Was wondering if anyone can help me with the table joins that are required for me to include SO header fields on my invoice reports AR641000 and SO643000
Any help is appreciated
TY!
Answer
Report Designer - Access SO header from AR Invoice (Report AR641000)
Best answer by xkylewrightx
Nevermind, got some help off site.
The two joins that are needed on the AR641000 report are:
And:
The SO Invoice report (SO643000) already has access to the SOOrder table.
Nevermind, got some help off site.
The two joins that are needed on the AR641000 report are:
And:
The SO Invoice report (SO643000) already has access to the SOOrder table.
Kyle Wright CSW, Inc. | www.cswgraphics.com
Thank you for sharing the solution with the community
+1Keep in mind that you’ll get duplicate data if you have multiple Shipments on an Invoice.
Also, in your second join, it’s best to include OrderType as well since that’s part of the primary key as you can see here:
Acumatica Consultant since 2013 (worked at Acumatica and multiple VARs) ⚡⚡⚡⚡⚡⚡⚡⚡ Currently an Ambassador for Traild AP Automation: ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ AugForums.com/Traild ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ Traild was the only AP Automation named finalist for Acumatica ISV Partner of the Year 2025⚡⚡ Lastly, please checkout my Acumatica Podcast, live broadcasting on LinkedIn and YouTube: ⚡⚡ AugForums.com/Podcast
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.