Cannot bring Fields into Routing Emails

Epicor ERP 10
, , ,
1

Hi I am trying to setup Routing so that when a report is printed an email is sent instead.

I have successfully set this up and I am getting the emails.

The problem I am encountering is the user requires certain fields to be in the subject and the body of the email. I can successfully add system constants (i.e. today/> or userID>) However when I try to add any Field from any table to the subject or to the body then the email is no longer sent.

I have tried everything and cannot work out what is gong wrong. Any advice would be greatly appreciated.

2

Welcome @Simon.Orrell !

Are you using the Insert Fields functionality when you right click?

1 Like
3

I have been using the insert button located at the bottom of the screen. I assume it does the same as right clicking.

4

Yes. Can you post a screenshot of the email template?

5

email template
email template882×592 9.37 KB

This template works fine as it doesn’t specify a field

6

Can you add a field in just to see?

7

email template 2
email template 2883×595 10 KB

This one I just dont get an email anymore :frowning:

8

email template 3
email template 3464×542 6.71 KB

This is the criteria behind the field. But no matter what table and what field I use the result is the same

9

The only thing I can think of is that it may not like the name you are giving the field. Try just naming it “aaaaaa”.

10

removed the field. Emails send again

added the field and named it aaa. The emails do not send again.

email template 4

11

That is strange. I would put in a ticket with Epicor. This makes no sense.

1 Like
12

agreed i have put a ticket in. Awaiting a response.

I have tried everything I can think of. All different ‘Break Table’, different names, different tables, different fields. Whatever I do when I have the field I sit and wait until I realise the emails not coming :-(. Whenever I remove the field the email works.

and the system constraints are working fine i.e today/> and userid/>

thanks for trying

13

I found this in a KB for a similar looking issue. What email are you using?

  1. Go to the Email Settings Maintenance screen
  2. Delete the email address set up in the From Email Address field
  3. Save changes
  4. Re-enter the same email address
  5. Save changes once again
  6. Test the email to verify if it keeps failing
14

the email is SMTP through office 365 using a do_not_reply@company.com email address.

it works for emails from method and data directives. It also works in the routing as long as I am not specifying any fields

15

I am completely stumped. @Mark_Wonsil , do you have any ideas?

16

Bake Off What GIF by The Great British Bake Off

Me? Oh, I’m not the person one thinks of for automated emails. I would defer to @josecgomez (if he’s got power) or @klincecum.

2 Likes
17

What does the system agent log say for these emails? It should show them going out, maybe your relay is rejecting them somehow?

2 Likes
18

Look at the email log, that will show what is happening.
image

4 Likes
19

I was about to ask the same. Do you have anything in System Monitor?

2 Likes
20

Hi All sorry for the delay. I have done some testing.

I have enabled the email logs.

I removed the field from the routing email template and sent an email.
It arrives and it also appears in the email log

I have then added a field in the routing email template and send an email.
It doesnt arrive and it also does not appear in the email log

so the system isnt even trying to send the email. Something is going wrong when it trys to render the email with a field inserted.

as mentioned before system.constants are not an issue these work. its when I insert a field

2 Likes