Skip to main content

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!

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.

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

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


Terms & ConditionsCookie settings
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 — 2024  Acumatica, Inc. All rights reserved