Skip to main content
Solved

How to join two GIs on a Formula column?

  • October 6, 2026
  • 5 replies
  • 56 views
Freshman II

Hi everyone,

I have 3 Generic Inquiries:

  • GI A with a Division column that's a formula,
  • GI B which also has a Division column as a formula.

I'd like to create GI C by joining GI A and GI B on Division. However, Acumatica throws an "invalid" error.

Any ideas on how to work around this? Thanks.

Best answer by hieutran

Hi ​@hieutran ,

Please attach the GIs so we can take a look.

Thanks! I've figured out that we can handle this case by directly referencing Acumatica's formula names—for example, joining PMProject_Formula416d30d... with Sub_Formula6bf6abc25....

5 replies

lauraj46
Captain II
Forum|alt.badge.img+9
  • lauraj46
  • Captain II
  • October 6, 2026

Hi ​@hieutran ,

Please attach the GIs so we can take a look.

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • October 6, 2026

    ​@hieutran We’d likely need to see the GIs but the error isn’t really clear from what you’re describing. If you can provide screenshots of the functions and the error at least, or the GIs, we could help. Maybe you need a function to convert the end values to INT?

      valentynbeznosiuk
      Varsity I
      Forum|alt.badge.img+5

      Hi ​@hieutran 

      I've tried something similar in the past and concluded that the system doesn't allow fields with formulas to be used for joining GIs. To me, this looks like exactly that case.

      Valentyn Beznosiuk | Acumatica MVP 2026 | Acumatica Consultant & Business Analyst at Acupower ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ www.linkedin.com/in/valentynbeznosiuk
        Freshman II
        • hieutran
        • Author
        • Freshman II
        • Answer
        • October 8, 2026

        Hi ​@hieutran ,

        Please attach the GIs so we can take a look.

        Thanks! I've figured out that we can handle this case by directly referencing Acumatica's formula names—for example, joining PMProject_Formula416d30d... with Sub_Formula6bf6abc25....

          valentynbeznosiuk
          Varsity I
          Forum|alt.badge.img+5

          ​@hieutran 

          That’s awesome, thank you for sharing this!

          Valentyn Beznosiuk | Acumatica MVP 2026 | Acumatica Consultant & Business Analyst at Acupower ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ www.linkedin.com/in/valentynbeznosiuk
            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