Take Generic Inquiry Results (Multiple Lines) to Email Body

Hi ​@apallawala21 

Please refer to the following handling methods:

Option 1 – Simplest, no customization (recommended)
Attach the Generic Inquiry results as a file (Excel or PDF) to the email triggered by the Business Event.
This is the standard and supported approach in Acumatica when the GI returns multiple rows, because email templates cannot loop through result sets.

Option 2 – Customization required
Create a custom DAC based on a SQL View that aggregates or summarizes the GI results into a single record (one row).
That single-row result can then be used in the email body. This approach requires customization and development effort.

Best Regards,

NNT

Hi ​@apallawala21 ,

Instead of trying to insert multiple GI result lines into the email body, we recommend attaching the Generic Inquiry results as a file. This approach is fully supported and avoids the limitation of handling multiple rows in email content.

Steps:

1. Use a Business Event.

2. Select Generic Inquiry as the event source.

Hi ​@paalisaksen , you can try this reference. 

 I hope this help.