Solved

Generic Inquiry Concatenate Field Values in Group By

  • 26 September 2023
  • 3 replies
  • 85 views

Userlevel 1
Badge

Hi! Is it possible to concatenate these values after group by?

 I want the output to be “Order Fulfillment, Customer Experience” since they just belong to a single activity.

icon

Best answer by dcomerford 26 September 2023, 11:20

View original

3 replies

Userlevel 1
Badge

Here’s my GI:

Userlevel 7
Badge +12

I dont believe you can do ths using the Standard GI functionality as there is not an Aggreate Option for Concat on a string value. Your other option would be to create a SQL view to do this and then use this as a DAC for your Generic Inquiry.

https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/

Userlevel 1
Badge

I dont believe you can do ths using the Standard GI functionality as there is not an Aggreate Option for Concat on a string value. Your other option would be to create a SQL view to do this and then use this as a DAC for your Generic Inquiry.

https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/

Thank you so much!

Reply


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