AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Sending a Report th...
 
Notifications
Clear all

Questions Sending a Report thought a Business Event and Import Senario

 
Everything Else
Last Post by Tim Rodman 5 years ago
4 Posts
2 Users
1 Reactions
1,891 Views
RSS
Adam Brunner
Posts: 14
 Adam Brunner
Topic starter
February 5, 2021 1:35 pm
(@abrunner)
Eminent Member
Joined: 6 years ago

I am working to try and automate my companies orders processing so in particular QTs that don't need manual attention get sent to the customer. I was originally thinking about using a GI with a number of filters that binned the data based of location (US, Canada, International) and when a QT hit the filter it would trigger a Business Event with a Notification Templet a Report Attached (pdf). But, I came to the realization that the number of different filters were going to get hard to manage and it could be too easy for someone to change the filter parameters and screw up the entire process. 

To simplify my filter situation and protect the process I was thinking about doing the following:

  1. Create a GI that contained either all QTs or all orders generated by the SO301000 page. (The additional order types would allow for future development.)
  2. Run a Business Event when a record is inserted that would trigger Import Scenarios.
  3. Each of the Import Scenarios could trigger the report through the "Action: Email Sales Order/Quote" but would have different Source Restrictions ensuring the right report goes out based off of Country ID

I'm really wondering if this seems logical or if anyone has something else that they have done? 

-Adam 


3 Replies
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
March 19, 2021 5:19 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Sounds good theoretically, except I don't think that you need to use CREATE SUBSCRIBER -> Import Scenario on the Business Events (SM302050) screen. I think you can use CREATE SUBSCRIBER -> Email Notification instead.

 

Then, use the ATTACHED REPORTS tab on the Notification Templates (SM204003) screen to attach the report to the email:

image

Reply
Adam Brunner
 Adam Brunner
(@abrunner)
Joined: 6 years ago

Eminent Member
Posts: 14
March 22, 2021 8:42 am
Reply toTim RodmanTim Rodman

@timrodman I the reason that I'm thinking about going away from using the Email Notification is because I was 1) tying to get away from having different GI filters that would trigger the different emails and 2) we do have to change the hold status of QTs and SOs based off of some of there parameters. 

Since my initial post I have come to realize that their are other ways to achieve the first part of that, we are planning on using Customer Classes so we can set the Report and Notification Template at that level, I believe the second part will still need and Import Scenario. 

Unfortunately, we are currently running into an issue with our version of Acumatica 2019 R2 Build 19.205.0023 that is preventing the Import Scenario from looking at any source restrictions. So, we are investigating if it is a bug and/or if we are just going to update to 2020 R2. 


Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
March 22, 2021 11:50 am
(@timrodman)
Famed Member
Joined: 10 years ago

Ah, gotcha. If it's a bug, hopefully it's been fixed already in another build.


Reply
Adam Brunner reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,530 Topics
  • 11 K Posts
  • 16 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Negative/Credit Inventory Value?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×