Skip to main content
Answer

Relations/Joins using 2 different generic inquiries as data sources

  • July 30, 2025
  • 6 replies
  • 112 views
courtneyb
Freshman II
Forum|alt.badge.img

Has anyone successfully created a GI based off of other GI’s as the data source? I am able to add them as data sources no problem, but I am getting “Object reference not set to an instance of an object” error when trying to join the sources. I’ve checked to make sure the fields are existent in the database on the DACs I am joining. I am joining on inventory ID from both generic inquiries. Any advice or further documentation on best practices when joining two inquiries?

 

Best answer by varthinibhaskaran18

​@courtneyb 

The following help article might help

https://help.acumatica.com/(W(15))/Help?ScreenId=ShowWiki&pageid=ec13bad9-956f-4985-ad85-c4eedfd9c366

    6 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • July 30, 2025

    ​@courtneyb It might be helpful to see the two GIs to know for sure, but can you post images of your joins as well as the tables used in each GI?

    Uploading the GIs might be necessary to test, but I think at least seeing the joins will be the most helpful to understand the error.

    Chris Hackett
    courtneyb
    Freshman II
    Forum|alt.badge.img
    • courtneyb
    • Author
    • Freshman II
    • July 30, 2025

    ​@BenjaminCrisman  Yes. I’ve tried many different ways. Here are the joins I have tried.

     

     

    Data sources and relations of the first GI:

     

     

    Data Sources and relations of the second GI:

     

    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • September 25, 2025

    Hi ​@courtneyb were you able to find a solution? Thank you!

    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*.
    courtneyb
    Freshman II
    Forum|alt.badge.img
    • courtneyb
    • Author
    • Freshman II
    • September 25, 2025

    Hi ​@Chris Hackett . I was not able to find a solution in this particular instance. But, I was able to join simpler inquiries using GI’s. Is there any documentation that Acumatica provides on best practices when joining GI’s since it is a new feature of 24R1? That would be extremely helpful!

    Chris Hackett
    V
    Acumatica Moderator
    Forum|alt.badge.img+1

    ​@courtneyb 

    The following help article might help

    https://help.acumatica.com/(W(15))/Help?ScreenId=ShowWiki&pageid=ec13bad9-956f-4985-ad85-c4eedfd9c366

    Chris Hackett
    courtneyb
    Freshman II
    Forum|alt.badge.img
    • courtneyb
    • Author
    • Freshman II
    • September 26, 2025

    ​@varthinibhaskaran18 Thank you! I’ll check it out.

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility 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