Solved

Generic Inquiry Concatenate Field Values in Group By

  • 26 September 2023
  • 3 replies
  • 67 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

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!

Userlevel 7
Badge +11

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

Here’s my GI:

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