Skip to main content
Question

Inquiry INLocationStatus with Formula INLocationStatus.QtyAvail - INItemPlan.PlanQty

  • March 5, 2026
  • 3 replies
  • 25 views
M
Freshman I

Hi, I found the error

"Column 'INLocationStatusByCostCenter.InventoryID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

when creating an inquiry INLocationStatus when adding the formula

=IIf( [INLocationStatus.LocationID] = [INItemSite.DfltShipLocationID], Max( [INLocationStatus.QtyAvail]) - IIf( [INItemPlan.PlanQty] = Null, 0, [INItemPlan.PlanQty]), 0)

The following is the result grid that I made

with the following additional conditions

 

3 replies

R
Jr Varsity II
Forum|alt.badge.img+3
  • Rakshanda
  • Jr Varsity II
  • March 5, 2026

Hi ​@mujib ,

Add Group By in Generic Inquiry to the required fields in the Results Grid.

  • INLocationStatus.InventoryID

  • INLocationStatus.SiteID

  • INLocationStatus.LocationID

  • INItemSite.DfltShipLocationID

  • INItemPlan.PlanQty

Then your formula can work with Max().

Hope above works!!

Rakshanda D || Acumatica MVP 2026
    KrunalDoshi
    Jr Varsity II
    Forum|alt.badge.img
    • KrunalDoshi
    • Jr Varsity II
    • March 5, 2026

    Hi ​@mujib,

    Can you upload your GI XML? That will help better understand the issue where it is happening so I can provide solution. In ideal scenario, you need Group By when you use any Aggregate function.

    Krunal D - Acumatica Developer | www.linkedin.com/in/onlyleader | https://krunaldoshi.com/
      BenjaminCrisman
      Acumatica Employee
      Forum|alt.badge.img+4
      • BenjaminCrisman
      • Acumatica Support Team
      • March 5, 2026

      ​@mujib In order to use Aggregate Functions you need to have a grouping applied on the Grouping Tab. Typically it will be a grouping on the table you are applying the Aggregate Functions to on the Results tab, but if you need more assistance with the GI I would recommend to upload the GI as Krunal mentioned.

        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