Skip to main content
Solved

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

  • February 3, 2022
  • 3 replies
  • 164 views
  • Translate All
xkylewrightx
Semi-Pro I
Forum|alt.badge.img+1

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!

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.

View original
Kyle Wright CSW, Inc. | www.cswgraphics.com

    3 replies

    xkylewrightx
    Semi-Pro I
    Forum|alt.badge.img+1
    • xkylewrightx
    • Author
    • Semi-Pro I
    • Answer
    • February 3, 2022

    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.

    Translate
    Kyle Wright CSW, Inc. | www.cswgraphics.com
      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • February 3, 2022

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

      Translate
      Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
      TimRodman
      Pro III
      Forum|alt.badge.img+1

      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

      Translate
      Acumatica Consultant since 2013 and 8-time Acumatica MVP award winner ⚡⚡⚡⚡⚡⚡⚡⚡ Currently an Ambassador for Traild AP Automation: ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ AugForums.com/Traild ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ Traild is 2026 Acumatica ISV Partner of the Year, the most sold Acumatica ISV in 2025⚡⚡ Checkout my Acumatica Podcast, live broadcasting on LinkedIn and YouTube: ⚡⚡ AugForums.com/Podcast
        Terms & ConditionsAccessibility statement
        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