Solved

Get Email List into GI

  • 31 July 2023
  • 1 reply
  • 50 views

Userlevel 3
Badge

Hi,

I need to get all the contact emails related to the customer from the GI.

When I join the customer and contact table GI is showing like that.

Above customer has 5 contact emails. I need to show all 5 contacts as a list (not 5 rows only 1 row).

ex: 1st email,2nd email,3rd email

How I do that ?

icon

Best answer by dcomerford 31 July 2023, 11:56

View original

1 reply

Userlevel 7
Badge +12

I dont believe this is possible using a generic inquiry as each record is its own rpw and you cannot use the Aggregate function for a text field to group by customer. I would write a SQL based View for a DAC and use that in the GI instead

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