Skip to main content
Solved

Grouping issue

  • January 6, 2026
  • 9 replies
  • 65 views
S
Freshman II
Forum|alt.badge.img

I have created this report in GI. Everything looks good until I found out the grouping is not work well.

 

 

 

After I view the inquiry, I released that some of my price class did not group

 

Best answer by Naveen Boga

I don’t see this issue in my demo instance?

 

Have you reviewed the HYDRANT Price Class related stuff as it is only duplicated?

 

 

    9 replies

    nickcerri32
    Semi-Pro II
    Forum|alt.badge.img+6
    • nickcerri32
    • Semi-Pro II
    • January 6, 2026

    ​@SandyA Did you use the standard join for ARTran and InventoryItem (InventoryID = InventoryID)?  Have you attempted to do this as a Pivot Table and experienced the same behavior?  You may need to bring in some more fields to determine where the split is coming from first.

    Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
      S
      Freshman II
      Forum|alt.badge.img
      • SandyA
      • Author
      • Freshman II
      • January 6, 2026

      i have not try it in Pivot Table yet. What can of fields do you think i should add.

      S
      Freshman II
      Forum|alt.badge.img
      • SandyA
      • Author
      • Freshman II
      • January 6, 2026

      I just tried Pivot Table it is this same problem

       

      Naveen Boga
      Captain II
      Forum|alt.badge.img+20
      • Naveen Boga
      • Captain II
      • January 6, 2026

      ​@SandyA  If possible, can you please share the XML format of the Generic Inquiry here?

      Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
        S
        Freshman II
        Forum|alt.badge.img
        • SandyA
        • Author
        • Freshman II
        • January 6, 2026

        this is the XML

         

        Naveen Boga
        Captain II
        Forum|alt.badge.img+20
        • Naveen Boga
        • Captain II
        • Answer
        • January 6, 2026

        I don’t see this issue in my demo instance?

         

        Have you reviewed the HYDRANT Price Class related stuff as it is only duplicated?

         

         

        Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
          S
          Freshman II
          Forum|alt.badge.img
          • SandyA
          • Author
          • Freshman II
          • January 6, 2026

          this is my item price class

           

          S
          Freshman II
          Forum|alt.badge.img
          • SandyA
          • Author
          • Freshman II
          • January 7, 2026

          ​@Naveen Boga, I ended up join the InPriceClass table then it worked

            Naveen Boga
            Captain II
            Forum|alt.badge.img+20
            • Naveen Boga
            • Captain II
            • January 7, 2026

            ​@SandyA Awesome!! Thanks for sharing the update!

            Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
              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