Solved

Report Designer - Access SO header from AR Invoice (Report AR641000)

  • 3 February 2022
  • 3 replies
  • 46 views

Userlevel 3
Badge

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!

icon

Best answer by xkylewrightx 3 February 2022, 20:05

View original

3 replies

Userlevel 3
Badge

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.

Userlevel 7
Badge

Thank you for sharing the solution with the community @xkylewrightx !

Userlevel 5
Badge +2

Keep 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:

https://help.acumatica.com/dacBrowser/PX.Objects.SO/SOOrder

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved