Skip to main content
Question

Generic Inquiry: Group By: Contains String

  • May 28, 2026
  • 1 reply
  • 11 views
C
Varsity I
Forum|alt.badge.img+1

I was hoping I could pick your brain about modifying a Generic Inquiry where the results can be grouped together based on a specific string or text pattern. For example, values such as “COMPANY1”, “COMPANY2”, and “COMPANYABC” would be grouped under “COMPANY,” while “SELLERA” and “SELLERB” would be grouped under “SELLER.”

 

I was hoping to manipulate it in the Group By tab but was getting an error: Operand data type datetime is invalid for sum operator.

 

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

​@Crisel I don’t think the error is coming from that grouping. The error is coming from the results grid where there is a SUM applied to the date parameter:

This can’t be summed so it needs to be removed or have the aggregate function turned off, as it works when this field is not included in the GI results

    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