Skip to main content
Solved

Sales Order Invoice Approval Email Notification and attached report problem


kyoung14
Varsity I
Forum|alt.badge.img

We set up approvals on SO Invoices.  When the approval is created we want to send the approval requested email to the salesperson along with a PDF of the invoice.  I created the email template and assigned it to be used for invoice approvals.  I have 2 issues. (1) the email fires off when a new approval is created but for some reason it is creating 2 identical emails.  Issue (2), even though I have a report configured to be attached as a PDF to the email, it is not creating and attaching.  I know the email template is connecting to the correct data because in the body of the email I include the invoice # and approval ID - so it is seeing the correct data (see 2nd screenshot).   And on the report attachment screen (1st screenshot) I specified the report, it sees the parameters and it sees the possible values to select for answering each parameter.  But for some reason it doesn’t generate and attach the report.a

 

Any ideas?

 

 

 

Best answer by BenjaminCrisman

@kyoung14 The duplicate email issue is actually something reported just a few weeks ago I think in the beginning of March, it’s a bug unfortunately. I would recommend to make a support case so we can get more cases on the issue to raise the priority. As for the report you may want try using a business event and a GI containing the details necessary to populate the report parameters and fields. I’ve set quite a few of these up so I’m sure it should work.

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

3 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 733 replies
  • Answer
  • April 7, 2025

@kyoung14 The duplicate email issue is actually something reported just a few weeks ago I think in the beginning of March, it’s a bug unfortunately. I would recommend to make a support case so we can get more cases on the issue to raise the priority. As for the report you may want try using a business event and a GI containing the details necessary to populate the report parameters and fields. I’ve set quite a few of these up so I’m sure it should work.


kyoung14
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 46 replies
  • April 7, 2025

@BenjaminCrisman  - I’ve done many of the Business Event / GI things too and that was going to be my next step today.  When I saw the email for approvals fired off I was just hoping it would be easy to just add the report as all the needed data seemed exposed.  I wanted to be able to pull in data from the SO Invoice and needed the current pending approver.  I had to refresh my memory that to connect EPApproval DAC to ARInvoice/SOInvoice I had to join RefNoteID = NoteID to get the correct Invoice record related to the approval.  I’ll go down that route.  Thanks!!


kyoung14
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 46 replies
  • April 9, 2025

@BenjaminCrisman  - UPDATE

As you suggested and was going to be my next step, I was able to make a Bus Event work for this need.  Still odd that the email sent when specifying an email template for Invoice Approvals in SO Preferences wouldn't run and attach the report.  But regardless - I have a solution that works.


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