Skip to main content
Solved

Set Generic Inquiry (GI) to be emailed (in csv/ excel format) to a specified address on a schedule


Forum|alt.badge.img

I have several supplier performance GIs that show outstanding items and due dates and would love to be able to set the GI to be extracted as Excel or CSV and emailed to a specific address each day. To be clear, each supplier has their own GI so it is not like i need to filter the GI based on supplier - all results in the GI can go on the same email.

Best answer by Naveen Boga

@DanielStarke  Yes.

  1. convert your GI to your report.
  2. Attach this report to Business Event
  3. Select the format as Excel
  4. Configure the BE as type of “Trigger by Schedule”.

 

Hope this helps!

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

11 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16

Hi @DanielStarke 

Have you tried a business event for this?


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • July 5, 2022

Hi @DanielStarke  I don’t think we can attach the GI results in the format of Excel.

By using the Business Event, we can attach only the Reports in the format of PDF, Excel and etc.

 


Forum|alt.badge.img
  • Author
  • Varsity I
  • 61 replies
  • July 5, 2022

@Naveen Boga and @kbeatty21 thank you for your help! I don’t know if it is possible to extract the GI in a Business Event - that would be ideal if possible but i cant see how to do that - is it possible?


dales50
Semi-Pro III
  • 68 replies
  • July 5, 2022

@DanielStarke It may be possible to send all the result details of your GI within the body of the notification email sent out of a business event.  You would need to use a for each loop to show all details lines.  There should be some articles on this with in the community and I found the article linked below that has been used by support for some time

https://asiablog.acumatica.com/2018/07/loops-in-notification-templates.html

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • July 5, 2022

Hi @dales50  The above link will help us to loop through the transaction details for the document in the body of the Notification Template.

GI may have millions of records, this is an not an ideal way to do this in the notification template. 

Also, how can we loop through the GI result data set?


Ahmed
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • 52 replies
  • July 5, 2022

@DanielStarke  the easiest alternative I think is to:

  1. Export to Report from the GI
  2. Setup the report in the tenant
  3. Set up a Report Template from the report to be emailed out regularly

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • July 5, 2022

@DanielStarke  Yes.

  1. convert your GI to your report.
  2. Attach this report to Business Event
  3. Select the format as Excel
  4. Configure the BE as type of “Trigger by Schedule”.

 

Hope this helps!


Forum|alt.badge.img
  • Author
  • Varsity I
  • 61 replies
  • July 27, 2022

Thanks Guys! I now have the solutiuon working


Forum|alt.badge.img+5
  • Captain II
  • 398 replies
  • July 27, 2022

Can I add something here?
Yes, using BE attached a report is definitely a solution.

However, if you have converted the GI to a report. Then

1, You can save the report as a template. Like choose the receiver, choose the format like xls.
2, You schedule the template.
Then the report can be sent on schedule, it would be quicker to make it set.


gprice27
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • 25 replies
  • August 5, 2022

Another very reliable solution we have used is to create an Export Scenario which uses the GI as it’s Screen (Source). You then combine this with a Process Export Scenario schedule,  a Scheduled business event and a custom notification template.

To to this - you need to

      1: in the GI designer - check the ‘Make Visible in UI’ so there is a registered Screen ID for the GI

  1. Create a csv or Excel Data provider based on the output you need
  2. Make sure the GI Results match the fields required for the output
  3. Create the Export Scenario using the GI Screen and the data provideryou just created, Nominate the appropriate GI fields in the Export result..
  4. Create an Automation Schedule for the ProcessExportScenarios screen - use the ProcessAll action and make sure the Conditions tab lists the Export Scenario(s) you want to run  (field = ‘Name’  and Value = Export Scenario Name)
  5. Then create a Notification Template for the emails - and include the link(s) to the exported file in the email body  - this is the trick part - you need to get the file url from the Export Scenario’s Files dialog -  use the External Link otherwise the file can’t be accessed from your email client…. example  https://yourdomain.acumatica.com/(W(49))/Frames/GetFile.ashx?fileID=832229c2-72fb-44c6-8b77-eb9f15dc9fb8

     

  6. Finally - create a Business Event with an Email Subscriber that uses your custom Notification Template… and schedule that to run after the Export Scenario (maybe 15 minutes after…

  7. Note - the email recipient has to be an Acumatica user - with read access to the Export Scenarios Screen. So this might not work if you are emailing an external party…. but it is a good solution for internal use or for Vendors/Subs who have portal access.

Easy…. (once you know how..)  lol


  • Freshman I
  • 1 reply
  • January 5, 2024
gprice27 wrote:

Another very reliable solution we have used is to create an Export Scenario which uses the GI as it’s Screen (Source). You then combine this with a Process Export Scenario schedule,  a Scheduled business event and a custom notification template.

To to this - you need to

      1: in the GI designer - check the ‘Make Visible in UI’ so there is a registered Screen ID for the GI

  1. Create a csv or Excel Data provider based on the output you need
  2. Make sure the GI Results match the fields required for the output
  3. Create the Export Scenario using the GI Screen and the data provideryou just created, Nominate the appropriate GI fields in the Export result..
  4. Create an Automation Schedule for the ProcessExportScenarios screen - use the ProcessAll action and make sure the Conditions tab lists the Export Scenario(s) you want to run  (field = ‘Name’  and Value = Export Scenario Name)
  5. Then create a Notification Template for the emails - and include the link(s) to the exported file in the email body  - this is the trick part - you need to get the file url from the Export Scenario’s Files dialog -  use the External Link otherwise the file can’t be accessed from your email client…. example  https://yourdomain.acumatica.com/(W(49))/Frames/GetFile.ashx?fileID=832229c2-72fb-44c6-8b77-eb9f15dc9fb8

     

  6. Finally - create a Business Event with an Email Subscriber that uses your custom Notification Template… and schedule that to run after the Export Scenario (maybe 15 minutes after…

  7. Note - the email recipient has to be an Acumatica user - with read access to the Export Scenarios Screen. So this might not work if you are emailing an external party…. but it is a good solution for internal use or for Vendors/Subs who have portal access.

Easy…. (once you know how..)  lol

For #7, just be careful, when you set up your business event, make sure it does not trigger on every row of the Generic Inquiry or this will send an email for every lines!


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