Skip to main content
Solved

How to automatically email a GI (Generic Inquiry) to a user (within the company) on a regular basis ? ( daily or weekly)

  • December 9, 2024
  • 3 replies
  • 106 views

.

Best answer by jzhu

Hi, you could try creating a business event that triggers by schedule to send an email to the employee and include the link of the generic inquiry in the email.

  1. Create a business event and use the generic inquiry as your source screen. Event Type should be ‘Trigger by Schedule’

     

  1. In the Subscriber tab, Create an Email Notification Subscriber. Fill in your ‘From’ and ‘To,’ insert a link of the generic inquiry in your message
  2. In the Schedules Tab, hit ‘Create Schedule,’ and here is where you can set the event to send either daily or weekly 

     

Hope this helps!

View original
Did this topic help you find an answer to your question?

3 replies

  • Freshman I
  • 3 replies
  • December 26, 2024

Hi ​@sravikumar,

As far as I know GI results cannot be emailed the same way that reports can. A quick search revealed that a business event can be configured to email an excel export of a GI. Let me know if this works.

 


Forum|alt.badge.img
  • Semi-Pro II
  • 122 replies
  • Answer
  • December 27, 2024

Hi, you could try creating a business event that triggers by schedule to send an email to the employee and include the link of the generic inquiry in the email.

  1. Create a business event and use the generic inquiry as your source screen. Event Type should be ‘Trigger by Schedule’

     

  1. In the Subscriber tab, Create an Email Notification Subscriber. Fill in your ‘From’ and ‘To,’ insert a link of the generic inquiry in your message
  2. In the Schedules Tab, hit ‘Create Schedule,’ and here is where you can set the event to send either daily or weekly 

     

Hope this helps!


craig2
Pro I
Forum|alt.badge.img+3
  • Pro I
  • 97 replies
  • December 27, 2024

Hi ​@sravikumar ,

In addition to ​@jzhu ‘s advice in configuring the Business Event, consider using a <foreach> </foreach> loop in the body of your Email Template. 

 

In the Business Event configuration, set Raise Event to Once for Group of Records.  Then, in the body of the Email Template you can add the fields of your GI between the <foreach> tags.

 

A simple version may look like this:

<foreach>

Date: ((SOOrder.OrderDate)) Product: ((SOLine.InventoryID_Description)) Qty: ((SOLine.OrderQty))

</foreach>

 

It can be a little tricky, but once you get it firing properly there are some html techniques to improve the formatting.  See the post below if you want to dive into that space:


https://community.acumatica.com/reports%2Dand%2Dgeneric%2Dinquires%2D115/the%2Dformatting%2Dof%2Dfor%2Deach%2Dloop%2Din%2Dnotification%2Dtemplate%2D4505

 

Good luck!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings