EFT Processing Email Tab
The Email tab lets you define your email server. When you fill in the email option on the EFT Processing Options, it will email directly to your email server using the selected service. You can email documents using 2 methods, SMTP with basic authentication or App password or Microsoft Graph (when using Microsoft Office 365 and SMTP basic authentication is not enabled).
Email Service
SMTP (Simple Mail Transfer Protocol). You can use your own SMTP server, or an SMTP service.
Example: SMTP Email Examples
Microsoft Graph. This service sends email via Microsoft Office 365. It is generally used when SMTP Basic authentication is not enabled in Office 365.
Refer to Office 365 and Microsoft Graph
Note: Microsoft Graph is available in the latest product updates for Sage 300 versions 2020 and above, since October 2022.
If you leave the SMTP details blank in EFT Processing> Options Tab, the Sage 300 default way of sending emails will be used. Refer to Using Sage Company Profile Settings. However, the program cannot verify that the email has been sent and cannot report the number of emails sent. If you want to use the ability to password protect the PDF attached to emails in EFT Processing, you need to configure SMTP details in EFT Options.
Email Field details
Select the Service you want to use to email:
Basic Authentication SMTP:
: smtp.domain.com:587 Enter the details of the SMTP Server you want to email from.
: There is no specific field for the Port in Orchid modules. You can specify a port number after filling in the email server details. After the email server name, enter “:xx” i.e. colon xx where xx is the port number required.
Tip: The default port is generally port 587 with TLS.
Example: smtp.office365.com:587
and : Enter a correct combination of Email user and password
Note: If using multi-factor authentication and App password, enter the App password you create in he Email Password field. Refer to Using Orchid Modules with Office365 App Passwords
: Enter the email address to be used when sending email.
Microsoft Graph:
This service sends email via Microsoft Office 365 where basic authentication is not enabled to use SMTP.
Refer to Office 365 and Microsoft Graph
. Enter the tenant ID (alternatively called the directory ID) from your Microsoft 365 account.
. Enter the client ID (alternatively called the application ID) from your Microsoft 365 account.
. Enter the client secret from your Microsoft 365 account.
Tip: This is actually the secret , not the one called Secret ID. It is the one that you only see once when you first create the client secret.
. Enter the email address to be used when sending email.
Send Email copy
In EFT Processing, if you are using the SMTP Email option, you can use the cc or bcc option on the EFT Options > AP and AR email tab if you want a copy of the emailed remittance advice in Outlook.
Examples
Refer to the examples below for detailed settings with commonly used mail providers, such as Office 365 and Gmail.
Example: SMTP Email Examples
Using Sage Company Profile Settings
Using Sage Company Profile details
If you leave the SMTP details blank in EFT Processing> Options Tab, the Sage 300 default way of sending emails will be used. However, the program cannot verify that the email has been sent and cannot report the number of emails sent.
-
It will use SMTP or Microsoft Graph depending on the option selected on the Company Profile,
-
If the details are not filled in, it will use Microsoft Outlook if installed on the client machine.
For more details, refer to Emailing from Sage 300 in Sage 300 documentation.
If you want to use the ability to password protect the PDF attached to emails in EFT Processing, you need to use EFT's SMTP options.
Similarly, if you want to save a copy of the Payslip/paystub in the directory configured on the EFT Setup> Options > Default Advice Tab, you need to fill in the A/P Email or the Payroll Email SMTP details. If emails are sent using default Sage's configuration through Outlook, a copy of the file will not be saved.
Limit per Session/Minute
Configure limits when sending emails: (None / Per Minute / Per Session)
If you are getting errors relating to "exceeding limits" when sending email remittance advice, you can configure the options to Number of emails per minutes or Number of emails per session to match the requirements of your email server.
- Defaults to "None".
- Choose Per Minute if your email server has a limit per minute when sending SMTP emails (e.g. Office 365).
- Choose Per Session if your email server has a limit per session.
- Enter the number of emails to send per minute or per session.
How does it work?
When printing Advices and if the number of advices is greater than the limit, EFT will send the number entered in the limit, then pause if "per minute" is selected or Disconnect and start a new session if using "Per session" is selected.
Example: Limit per minute: If you set the limit to 30 per minute and you email 50 remittance advices, EFT Processing will send the first 30, pause for a minute, send the next 20, and will then display the result.
Example: Limit per session: If you set the limit per session to 10 and you select to Print/Email a batch of 50 remittance advices, EFT Processing will make a connection to the SMTP Server, send 10 emails (1 to 10), disconnect, then reconnect, send the next 10 emails (11 to 20), disconnect, connect again, send the next 10 emails (21 to 30), disconnect, etc. When all emails are sent, it will display the delivery results.
